Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Facing issues in the drill down charts in SSRS


Facing issues in the drill down charts in SSRS

Author
Message
geetha.jasmine
geetha.jasmine
Forum Newbie
Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)

Group: General Forum Members
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
Attachments
drilldown_charts_SSRS.docx (7 views, 549.00 KB)
gsc_dba
gsc_dba
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1593 Visits: 1987
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

_____________________________________________________________________________________
[font=Courier New]gsc_dba[/font]
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search