If you get the exception: {"System.Web.Services.Protocols.SoapException: Cannot create a connection to data source ”. —> Microsoft.ReportingServices.Diagnostics.Utilities.DataSourceOpenException: Cannot create a connection to data source ”. —> Microsoft.ReportingServices.DataExtensions.ReportServerDataProvider.RSDPException: You have specified integrated security or credentials in the
If you have created a Microsoft Reporting Server report with a drillthrough. The user can Navigate to another report by clicking a link. This will fire the ReportViewer.Drilltrhough event on a ReportViewer control in ASP
http://www.infoq.com/articles/Gogolowicz-Swanson-SSRS
This examples uses the Microsoft SQL Server 2008 example database AdventureWorks (http://msftdbprodsamples.codeplex.com/) If you want to return all rows of a table when a parameter is null, use the TSQL function isnull: declare @productModelID as
Exception: Error 1 [rsInvalidReportParameterDependency] The report parameter ‘productModelID’ has a DefaultValue or a ValidValue that depends on the report parameter “productModelID”. Forward dependencies are not valid. C:\Projects\Temp\Report Project1\Report Project1\Products.rdl 0 0 This error occurs, because
To allow nullable parameters on a Microsoft Reporting Services report, add an extra row for all product models: — Dataset 2 select null as ‘ProductModelID’,‘[All models]’ as ‘Name’ union select pm.ProductModelID, pm.Name from
After changing the websitename, hostheader or computername of a Microsoft Reporting Services Server, you get the error: The report server is not responding. Verify that the report server is running and can be accessed from
The error An error has occurred during report processing. Login failed for user ‘(null)’ can occur, when "anonymous access" is enabled on the Microsoft Reporting Service virtual directory and the datasource in Microsoft Reporting Services
http://msdn.microsoft.com/en-us/library/ms252090(VS.80).aspx