Change color of a row on click event in the SSRS report.
Hi all,
I need a way to change the color of a row on click event of it in SSRS.
Please can anyone help me with a Sample of the same. I need this functionality to happen on the client side.
Hope to get a response ASAP.
Thanks & regards
BK
October 14th, 2010 2:32pm
Hi BK,
By design, the SQL Server Reporting Services(SSRS) will render a report on the server side without the event you mentioned. This means the functionality is not enabled in current SSRS versions.
It seems you want to high light each row, if so, we can use the altering color instead to fix the issue. Chris Hays provides a sample about this on his blog:
http://blogs.msdn.com/b/chrishays/archive/2004/08/30/greenbarmatrix.aspx
Or, please submit a wish at https://connect.microsoft.com/sqlserver
If you have any more questions, please feel free to ask.
Thanks,
Jin ChenJin Chen - MSFT
Free Windows Admin Tool Kit Click here and download it now
October 19th, 2010 5:29am
As per above, SSRS is not an event driven engine.
the only way I can imagine being able to do this would be to have a parameter on the report which is set to NULL by default. On click, call the same report but pass the unique reference for the row clicked on in the parameter and test for this to set the
background colour of the row. This does of course have the major drawback of re-running the report every time a row is clicked on.....Rgds Geoff
October 19th, 2010 6:24am