|
Slow Performance with Dynamic Grouping and ReportViewer In Local M I'm having quite a problem with very poor performance in RS. This is definately not a data related problem. In order to find the bottle neck I have created two reports with one grouping. One has a normal static grouping expression of Fields!MyFieldName.Value while the other also has a static expression but of t... 3 Jun 2010 16:48
Report Builder error when opening report Our user created a report in Report Builder and saved it to Report Server. The report executes just fine from Report Server. But when we try to open the report in Report Builder to change it, we receive this error: "Cannot open this item. This report cannot be opened in Report Builder. Detail's value expre... 3 Jun 2010 11:10
+/- signs dont match the display state I have several large reports where my clients are able to select the initial Collapsed or Expanded state from a parameter. ie initial visibility = iif(parameters!Display.value="H",true,false) This works great, except the "+" or "-" signs do not match the selected state when the report is openned. eg if the repor... 2 Jun 2010 23:08
conditional color formatting for line chart background color Does anyone know how to or even if it's possible in RS2008 to change the background color of a chart based on the data point values being charted....for ex If the data point value is > 80, then the background color for the that y axis range should be "RED", if data point is between 61 & 79, the backgrouund c... 2 Jun 2010 13:10
SOAP Webservice Data Source (Input object type) Hello: I am using a SOAP webservice as the datasource for my report. How should i specify the report query to retrieve data from a SOAP web service? The input to the web service is of type 'filter' which has teh following 4 properties: The web service wants the request to be of the form: <soap:Body> ... 1 Jun 2010 13:06
date format Hi all, I am getting the results from reporting services using Excel as datasource. The date format is dd/mm/yyyy hh:mm:ss. I want out put from reporting services should be dd/mm/yyyy only. I am using the query as: select date from Excel$ where datepart("m",date) = datepart("m",@rundate). please hel... 2 Jun 2010 06:34
Report Parameters in SQL 2008 I have no issues with parameters using sql as a datasource but many issues with SSAS Cube as a data source. My report will not isolate the data to the selected report parameter. Any hints? ... 31 May 2010 21:52
Final Reminder - Microsoft Responds to the Evolution of Community What is Happening? This message is to inform you that Microsoft will soon begin discontinuing newsgroups and transitioning users to Microsoft forums. Why? As you may know, newsgroups have existed for many years now; however, the traffic in the Microsoft newsgroups has been steadily decreasing for the past sev... 28 May 2010 17:05
Page Break Separator Row I have a page/section/detail layout with tables that may or may not repeating and continue across pages. I've followed Chris Hay's hack to get the "continued..." at the top of the next page but the report design requires a blank row immediately after the last detail row before it continues to the following page... 27 May 2010 18:11
Clickable charts/graphs? I just figured this out with SSRS 2008 (the following assumes you have two charts on one report - the source chart that you will click on and the target chart that will be modified based on the series value you click on in the source chart). You need to create a parameter for the report that will be used by the targ... 27 May 2010 17:05
Report Builder 1.0 Filter Prompts I have created an ad-hoc report and want to add a filter. I understand that the Report Builder will only pre-populate the 'in this list' for that filter if the list contains less than a pre-determined number of entries. Fair enough. However, where can I find out what this magical number is...it would certain... 27 May 2010 17:05 |