I have a reporting services 2005 report that filters a table based on what a user clicks on. I have a parameter named @regionId. When this param is null I don't filter any of my results, when it is not null, I filter based on the regionId. All this filtering is performed in a stored procedure.
The parameter is set when the users clicks on a region. This hyperlink action jumps to the current report and sets the @regionId to an appropriate value.
Everything is working fine, EXCEPT, when the report is deployed to the server the re-rendering that happens on the jump to bookmark call is way too slow.
Is it possible for me to
- monitor where the user is clicking and use that to filter a cached set of data
- re-query the database without re-rendering the report (queries are fast enough to run on demand)
- something else.