Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Open a report by clicking another report Expand / Collapse
Author
Message
Posted Thursday, September 12, 2013 8:21 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, March 6, 2014 1:35 AM
Points: 178, Visits: 547
Hi,

Is it possible to click a chart / X axis value, grab the values as parameters and open another report passing those parameters to the new report?

I have 3 reports with timelines.
1st : Weekly averages
2nd : Daily averages base on week of 1st report
3rd : Quarter hourly based on date from second report.

Using Report Builder 3.

Edit : There is an Action tab under series properties, but I don't know how to get the coordinates of the mouse click.

Param1 = Chart1.Series1.XAxis.Major.Value
Param2 = Chart1.Series1.XAxis.Minor.Value

Cheers.




For better, quicker answers on T-SQL questions, read Jeff Moden's suggestions.

"Million-to-one chances crop up nine times out of ten." ― Terry Pratchett, Mort
Post #1494210
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse