Simple Talk has a great article on the top 10 things you might have issues in dealing with SQL Reporting Services.
SSRS offers a range of different reporting techniques and technologies, to cater for the reporting needs of all levels of users, from the chief executives, to business analysts, to operational staff. Their reporting needs range from simple, tabular ad-hoc reports, to parameterized, linked or snapshot reports, to complex drill-down and drill-through multi-level reports.
Following is the list of some of the challenges I have encountered while developing such reports using Reporting Services 2000/2005. In the sections that follow, I will cover each challenge individually, providing insight into what may cause the difficulty, alongside a possible solution.
- Horizontal Tables: Calendar Reports
- Select "ALL" Query Parameter option
- Multiple Sheets in Excel
- Excel Merged Cell Issues
- Blank Pages
- Vertical Text
- Report Data in Header/Footer
- Are you missing XML/CSV data on your exports?
- Template Reports
- Using the Reporting Services database
A ZIP file containing samples of the reports detailed in this article is available to download, try out and amend to suit your own needs.