August 27, 2010 at 12:16 pm
I have a report that has multi-valued cascading parameters. Every time a parameter is chosen the screen refreshes and this happens after each parameter choice. Does anyone have any suggestions on how I can limit the time something refreshes. This is very annoying to the user. Thank you
August 27, 2010 at 12:58 pm
If it's taking too long to refresh chances are the underlying queries that drive your cascading report parameters are taking too long to execute. When you have cascading parameters the page needs to refresh in order to populate the next parameter choice.
You could create a custom front end for gathering the required parameters and then use the reportviewer control or URL access to open the report with the required parameters already populated. By doing that you might be able to create an ajax style application where the entire page doesn't need to reload, only portions of it.
-Luke.
August 27, 2010 at 1:02 pm
Any idea how this could be accomplished in Sharepoint? Sharepoint is where the reports are being ran from. Thanks.
August 27, 2010 at 1:08 pm
I don't deal with Sharepoint all that much, but I'd imagine that you'd be able to launch a web page from your sharepoint site that would open in a new browser window(or even the same one) correct? Create a web application hosted on the same server and just link to it. Use you custom front end to gather your parameters and pass them through URL access to your SSRS instance.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply