ssrs

Unable to load client print control

Categories:

If you see this message when trying to print a SQL Server Report, you probably don't have local admin rights. These instructions explain how to resolve the issue http://www.kodyaz.com/articles/client-side-printing-silent-deployment-of-rsclientPrint.aspx

 Personally, I used the excellent VNCScan to make a remote script so I
can fix this with one click.

How to create a simple string filter in SSRS

Categories:

If you are sure you've typed your filter condition correctly, to either include or exclude data based on a string match, try this.

How to rename a report in SSRS (SQL Server Reporting Services)

Categories:

Here's how to change the name of your SQL Server report.

To rename a report in SSRS (SQL Server Reporting Services), from the Visual Studio environment, fire up the Solution Explorer sidebar. Then, you should see your report(s) in the tree view. Right click the report to rename, and choose "rename". Easy as pie, but hard to figure out.

You receive "Cannot create a connection to data source" when opening a report on SQL Server Reporting Services

Categories:

This error may be caused because of insufficient permissions to open the data source. Check the properties of the data source in the Reporting Services web interface. If it is set to use Windows Authentication, it is possible that the user does not have sufficient privileges to open the data source.

To resolve this problem, either grant the users permission to connect to the data source, or set a default username and password to connect to the data source.

This is the error that you may see:

Visual Studio will not deploy report to SQL Server Reporting Services

Categories:

If Visual Studio will not deploy your report to the Windows Server, and you have not deployed to it before, check the security (SSL) settings for the server. If the server requires an SSL connection, and your workstation does not trust the SSL certificate, Visual Studio will create an error about "couldn't establish trust relationship". This is a problem when the server is using a self-signed certificate. The solution is to visit the Reporting Service's website with Internet Explorer, and install the Server's certificate to your machine locally.

Subscribe to RSS - ssrs