Browse by Tags

All Tags » sql server » reporting servi... » report builder   (RSS)
TSQL to list all the reports inlcuding data sources on the SQL Server Reporting Server?
27 December 07 05:35 AM | SQL Master | 2 Comments   
Use ReportServer Go SELECT DS . Name as DataSourceName , CT . Name AS ItemName , CT . Path FROM dbo . Catalog CT INNER JOIN dbo . DataSource DS ON CT . ItemID = DS . ItemID Where Type = 2 Order by DataSourceName , ItemName Read More...
Dynamic formatting within the reports using TSQL?
03 October 07 02:56 AM | SQL Master | 2 Comments   
I felt this is more about SQL Storage engine related blog, but there is blend of TSQL involved in tasking the dynamic reporting within the Reporting Services. Here it goes, the task is to change/highlight the color of a row, based on its value. Therefore, Read More...