Browse by Tags

TSQL to list all the reports inlcuding data sources on the SQL Server Reporting Server?

Published 27 December 7 6:35 AM | SSQA.net

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 ) Read More.....

Filed under: sql server, report builder, view, reporting services, tsql, data sources

Dynamic formatting within the reports using TSQL?

Published 3 October 7 4:56 AM | SSQA.net

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...

Filed under: sql server, report builder, storage, reporting services, tsql, results, iif