Interactive reports using SQL Reporting Services

Question

Is it possible to generate reports which give a feel of an animation? For e.g. after selecting a particular value from a list the value displayed in a gauge (feature provided in SSRS 2008) changes.

Answer 1

Hi Amit,

I can't understand your purpose exactly. Could you elaborate it? If it's clear, here will be some one who can help you.

thanks,
Jerry

Answer 2

Thanks for the reply. My idea was to have a report which would give a feel of animation. For e.g. To create an interactive mechanism so that a user can somehow select a customer and have a subreport update to show that customer's data, without jumping away from the parent report? 

 

Recently I am came through this link which tries to attempt similar stuff : http://digitalcamel.blogspot.com/2008/02/tabbed-sub-reports-with-srs-and.html 

But as I am not much aware of windows sharepoint and how it would help to solve my purpose by integrating with SSRS, I was not able to make much progress on this. If someone can share some knowledge or some links it would be great.

Answer 3

Hi amit,

How about poping up a window to show the customer's data when a user select a customer? To do it as this, right click the customer textbox and select Text Box Properties->Click Action->Go to URL and edit the URL expression like this: "javascript:void(window.open('http://Server/ReportServer?/Project1/YourCustomerReport&rs:Command=Render?param_practice="+Fields!Customer.Value+"'))", you also can add some command in the javascript like 'location=no,toolbar=no,left=100,top=100,height=200,width=200' to let the window make sense.

About javascript to pop up a new window, please see http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/82132a97-6e8f-4df4-aa3b-86dbe209684e .

Hope this help,

thanks,
Jerry

Answer 4

Thanks for the reply. This approach would help if the information to be displayed is a text. But I want to change the data displayed by a chart or a gauge. For e.g. Selecting a customer name should up his sales information for different years on the same report in a chart.