SQL Server Reporting Services FAQ, Mar 2010

Question

 [ Note that we have created a ebook (PDF format) to combine all these FAQs and some new FAQs and walkthrough articles together. The eBook is published in this blog and available for download now. ]

The SSRS FAQ is collected from those frequently asked questions in the SQL Server Reporting Services (SSRS) forum. It attempts to answer the most frequently asked questions related to the design, development, security and administration of SSRS 2005/2008, and to reduce the number of posts that result from the repetition of questions on the same topic, wrong answers to these questions and corrections to the wrong answers etc. It serves as a repository of consolidated answers to these most common questions. If there is any feedback, please send to [e-mail] by removing "online.".

The following is a complete list of the FAQs posted in this forum:

1.       How do I hide the toggle image (+) if there is no row when using drill-down?

2.       How do I achieve nested aggregation?

3.       How do I achieve column break in a matrix?

4.       How do I use Parent-Child Hierarchies and formatted value in report with Analysis Services?

5.       How do I set interactive sort across multiple groups in SSRS 2005?

6.       How do I get distinct values of SharePoint column using SQL Server Reporting Services?

7.       How do I resolve the printer problem “Unable to load client print control”?

8.       How do I allow Enter key to act like the “view report” button?

9.       How do I avoid prompting Login dialog while deploying report from Microsoft Business Intelligence Development Studio?

10.   How do I resolve the error “No report servers were found on the specified machine”?

11.   How do I get the subtotals of each page and previous pages at the bottom of the report?

12.   How do I resolve the Reporting Services Client printing Error-"Object doesn't support this property or method"?

13.   How do I get the alternate row coloring in a matrix report with more 2 RowGroups?

14.   How do I show a particular image based upon the data retrieved from database?

15.   How do I combine the multiple data tables from one database or different databases in a report?

16.   How do I anonymously access the Report Manager?

17.   How do I deploy a Report Server for Internet Access?

18.   How do I resolve the Reporting Server Error 1053: The service did not respond to the start or control request in a timely fashion?

19.   How do I dynamically load an external image in a report?

20.   How do I call the public methods of Reporting Service Web service in XML Datasource to query report server metadata?

Answer 1

Some additional Questions on Advanced SSRS.

1)How to configure the Custom datasource using dlls?

2)How to list the reports avilable in the Reportserver?

3)How to control the issues like #error when we export the data into Excel?

 

Thanks,

Veeren.

Answer 2

Veeren,

Could you pls let us know answer for those questions.

1)How to configure the Custom datasource using dlls?

2)How to list the reports avilable in the Reportserver?

3)How to control the issues like #error when we export the data into Excel?

Thank you.

Answer 3

To List reports available in report server: Using proxy class/ webservices extension you can read the catalogitems and bind to a gridview.

Using SSMS and Report Server database you can do a select query.

-hth

---

gkd