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 in reporting services

Published 17 October 7 2:57 AM | SSQA.net

Second time again I have been caught in performing the dynamic formatting, though this is more kind of development type of question and I was searching through Reporting Services side. The issue is to change/highlight the color of a row, base on its value...

Filed under: sql server, reporting services, tsql, report viewer, iif, format

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