SSRS 2005:
| Sno | Problem/ Issue | Workaround / Comments |
| 1 | Once the data is exported to excel, few columns are merged in the excel sheet. | a. Keep the header into excel header
This can be done by including SimplePageHeaders=true in device info. Another tips is to remove the blank columns by adding RemoveSpace item in device info.
A sample of reconfiguring device info thro Reportserver.config is pasted below.
<Extension Name="EXCEL" Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer,Microsoft.ReportingServices.ExcelRendering">
<Configuration>
<DeviceInfo>
<SimplePageHeaders>true</SimplePageHeaders>
<RemoveSpace>0.012in</RemoveSpace>
</DeviceInfo>
</Configuration>
</Extension>
b. Change width to points
c. Left and right edges of all report items line up with each other. |
| 2 | 1. Table control header contents within Matrix Row header will not be displayed in Excel export.
2. Interactive Sorting in Matrix,
3. Hiding columns in matrix due to inavailability of Visibility property | These are limitations in 2005 edition. Try to get the display of the Matrix in Dataset itself by modifying SQL script and use Table instead. |
| 3 | You may have learned about sparklines or you want to add a chart to your Tablix. You either copy/paste your working(!!!) chart into the tablix and then you preview and you get:
"The chart 'Chart1' has a detail member with inner members. Detail members can only contain static inner members." | It is a simple logic behind. The chart you are adding already have categories/series axis which is going to grow dynamically, now when you put this chart inside a detail level row of a tablix it is going to throw the below error. You should add the chart in the group header level, in that way the chart gets replicated w.r.t each group item in the tablix. For example “Product Category” can be row header in the tablix and the chart categories/series can have “Product”. Suman.sundar@accenture.com.
In a Tablix you cannot put dynamic member in a Detail row. You have to put it into a Group header or Group Footer row.
Steps:
1.Insert a table into your report.
2.Set the DataSetName for the Tablix (either in the Properties pane or by dragging a field into the tablix).
3.In Row Groups, right click the (Details1) group. Select Add Group –> Parent Group…
4.In the Tablix group dialog, Select your Group by: clause.
5.Check the Add group header checkbox.
6.Press OK.
Notice the two rows next to big parenthesis on the left. These are the rows in your group. The top row (where I has the highlighted cell) is the group header row. You can put a chart in any group header row. The bottom row (where the three link icon is) is the details row. If you put your chart in this row, you will get the aforementioned error. From http://blogs.msdn.com/b/lukaszp/archive/2009/12/21/charts-in-a-tablix-cell-don-t-work-for-me-but-i-ve-see-these-nice-demos-where-they-do.aspx |
| 4 | Determine number of Columns shown in matrix | Would you be able to do a count on the dataset to get your column count?
Count(Fields!FieldUsedAsColumnGrouping.Value,"DatasetName")
Not sure how your data and matrix are setup, I do something similar where I have to know the number of columns so that I can draw an appropriate border line. But I think you should be able to a Count on either the dataset or grouping to get what you are looking for. (I can paste some code come Monday if needed.). From http://stackoverflow.com/questions/495174/reporting-services-determine-number-of-columns-shown-in-matrix |
SSRS 2008:
| SNo | Issues | Workaround |
| 1 | Does not display all the Labels on the axis of a Bar Chart | Check one of the following :
1. Select X-Axis (where we show task names example) -> Right Click Axis Properties -> Axis Options -> check the option "Enable Variable Interval".
2. Right click on the chart, Click Show Data Labels |
| 2 | Column Headers in pages are not repeating and they appear only in first page. | Choose Advanced Mode in the Grouping pane (Click on V Button near Column Groups, Select Advanced Mode). Select "Static" that appear under Row Groups,Go to Properties Pane by pressing F4. Under the Properties List, Set the value True for FixedData and RepeatOnNewPage. |
| 3 | Query Execution Failed for Dataset | Check one of the following:
1. Remove or comment those Declared variables which is already in the Parameters list
2. If the Stored Procedure was not set to public in the properties section,it will work on local computer but not on the report server. (Right click the stored procedure in Sql server, and click properties, when the box opens up , select Permissions and click add, type in public and click ok.)
3. Increase the SessionTimeout on the SQL Server Reporting Service server to extend the time the session is alive which can increase the time before a failure could occur.Please follow the detailed steps:
a) Open Report Manager using http://<servername>/Reports.
b) Navigate to the specific report, and then click the tab “Properties”.
c) In “Properties” tab, click “Execution”
d) Then, select “Limit report execution to the following number of seconds:”, and set it to a new value.
4. If the step3 does not help, please use the following steps:
a) Please run the Query string of DataSet in SQL Server Manager Studio, and then check if there have Dead locks in SQL Server
b) If so, please re-design the Query String, or optimization the database.
c) If not, try rebuilding the report.
5. Make sure that the dataset name is changed everywhere in the report layout, not only in the data tab. All the controls in the report will be pointing to the old dataset name, change these.
6. If you are viewing the report and then you update it, there is some metadata which needs to be rebound when you press the View Report button. This doesn't get rebound correctly.
The solution is to navigate back to the folder containing the report and run it again. |
| 4 | Display Total Rows for the Dataset. Show table based on record count, hide the table when row count is 0 | Add "=CountRows("DataSetName")=0" in the Visibility expression does the trick |
| 5 | "Unclosed Quotation Mark" or "Incorrect Syntax near" | Possible Causes:1) The Column values that are part of IN filter may contain a quote - Eliminate these quotes using REPLACE function. 2) While using Dynamic SQL, the Column values built for IN Criteria assigned to a VARCHAR Variable getting truncated due to limitation of the length - All IN filters should be cascaded directly to the EXEC Statement. |
| 6 | Report when exported as Pdf inserts alternate blank pages | 1. Adjust the Page width by resisizing text, label and other object placed on the report
2. In the Report Properties -> Page set up -> Adjust the Margins, set Left = 1.5cm , right = 0cm, top = 0cm and bottom = 0cm |
Thanks and Regards,
Subhash Subramanyam
This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of the email by you is prohibited.
Comments