December 26, 2007
I've run into this annoyance a few times in SSRS. Instead of seeing your image on a deployed report, you see only a Red X. This typically occurs when your image is in a virtual directory. The workaround is to make the virtual folder available to ANONYMOUS access. Microsoft has acknowledged the bug...
December 21, 2007
I've got an article over at SQL Server Central that describes how to get Gantt charts in SSRS using native controls, not third party. And it has a holiday spin. This is the abstact: Gantt charts in SSRS aren’t included in the 2005 release. You can purchase a third-party add-on, or, if you can wait...
December 20, 2007
The following table lists examples of connections string for various data sources. Data Source Example Description SQL Server OLTP database data source="(local)";initial catalog=AdventureWorks Set data source type to SQL Server . Analysis Services database data source=localhost;initial catalog...
December 18, 2007
When launching SSRS reports by URL, it is often necessary to include parameters. To do so, simply include the parameter name, an equal sign, followed by the parameter. So param=value for a report where CustomerID is 1 would look like: http://localhost/ReportServer/Pages/ReportViewer.aspx%2ReportFolder...