I have developed few SSRS reports in SQL Server 2008 R2 for one of our customers. I have deployed those reports to Reporting Server URL. All users are able to access and print reports. When the user wants to export to excel, it just exports as same format as it is printed on screen. It exported excel is not at all in user friendly format. It has the following problems:
1. Unwanted additional blank rows & columns.
2. Data exported fields are not fit into one cell. It scattered and merged few cells to display data of that field.
3. Exported excel data sheets cannot be used for sorting & filtering and also other excel functions.
4. Ctrl+F is also not functioning since the data in each cell has empty trail spaces.
I have suggested users to use XML & CSV exports. This is exporting just as table with unwanted header labels and not in the same order as put on the report layout. I think this is just exporting the data as table export. If they have any subtotals, subtotals are not getting exported to XML/CSV files.
User are also facing problem with Print Page Setup to print as pdfs. They cannot have option to fit the complete report to an A4 page. Page setup option which provided by SSRS report is limited.
I am really having tough time with SSRS reports. I appreciate if you can help me in sorting out all the above issues.