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, in case if a column value is say greater that...
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, if a column value is say greater that 90%, the...
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 )