One of the constant/standard task that happens when a SSRS reports is developed is that the data in the report is exported to Excel. I had developed a report which had the Interactive sort turned on the columns. The user liked this feature so we made it a standard requirement while developing the reports. One of the issues which I faced was when the report (which had the interactive sort on the columns) was exported to excel, there were blank columns being added after each column. Then i went through forums and discussions, checked the alignment of each column in the report, made sure there were all lined up correctly, there were no headers or footers overlapping the data area. Once these were all checked, did the export , still saw the blank columns. Then i started turning off the interactive sort on couple of columns, did the export to excel, the blank columns did not appear. So it turned out that the interactive sort on SSRS reports can distort data when exported to excel. Here is a link from microsoft which states these features are not persisted in the export.
http://msdn.microsoft.com/en-us/library/ms345232.aspx
Interactive sorting
Preview/Report Viewer
For tabular repots, users click sort arrows on column to change how the data is sorted.
HTML
For tabular repots, users click sort arrows on column to change how the data is sorted.
PDF
Not available in PDF.
Excel
Not available in Excel.
No comments:
Post a Comment