Get a SQL Reporting Services report to only show selected rows in a datagrid.
Posted on 2006-03-20
In an asp.net page (I'm using VB.Net) can you have a user select rows in a datagrid, using say a check box and then trigger a reporting services report to only report on the selected items. Reporting all items is not an issue I can just use the same SP that populated the datagrid in the first place.
If I could find the reference to include in my project that allows me to work with Reporting Services items, that might set me on my way?
I want to avoid having to create some long winded dynamically created query string if possible. Not only because of the security risk but it could end up being to long.
Any lateral thoughts and suggestion much appreciated.