Submitted by northben on Mon, 05/24/2010 - 10:14
Submitted by northben on Tue, 06/16/2009 - 13:42
If you are sure you've typed your filter condition correctly, to either include or exclude data based on a string match, try this.
Submitted by northben on Mon, 06/15/2009 - 15:11
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.
Submitted by northben on Mon, 12/29/2008 - 12:14
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:
Submitted by northben on Wed, 12/17/2008 - 23:07
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.