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

Facing issues in the drill down charts in SSRS Expand / Collapse
Author
Message
Posted Saturday, April 6, 2013 6:11 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, April 10, 2013 5:45 AM
Points: 5, Visits: 24
Hi,

When we have two parameters that are passed to get two charts in SSRS -- by clicking on any value in the primary chart, it will force parameter to go back to its "default value".

I have best explained the issue in the attached word document in detail. Could someone who is an expert in building drillthru(drilldown) charts in SSRS please suggest ways to overcome this.

Thanks


  Post Attachments 
drilldown_charts_SSRS.docx (7 views, 549.15 KB)
Post #1439575
Posted Friday, April 12, 2013 7:16 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, July 24, 2014 3:58 AM
Points: 1,270, Visits: 1,540
I believe you have already highlighted the issue - the value is reverting back to its "default" value.

If you check the parameters on the sub report (and parent report) by adding text boxes on the report with its value:
=Parameters!YourParameter.Value

You can determine if it is being updated by the parent report or not - this should help you troubleshoot the actual issue when passing parameters between the two report.

HTH
GSC



_____________________________________________________________________________________
gsc_dba
Post #1441682
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse