CODEWITHSUNDEEP
reporting-servicesdrillthrough
clare
clare

Reputation: 13

SSRS Drill through Report not populating parameters automatically

I've two reports main and drill through, which I’m trying to get to run via the URL. The report will open in a new tab from the URL, but it doesn't run (with the parameters), the user has to select the parameters and one variable is populated from a a common field on both reports. Both reports use the same parameters and both have the same internal parameter. I have this working with 2 other reports that do not contain an internal parameter but this one will not render correctly. I cannot figure out whats wrong.

This is the code in my Go to URL action:

"javascript:void(window.open('https://myserver/Reportserver?/myfolder/Drill_BoEUGTranscripts_ANON&rs:Command=Render&Acad_Period="+Parameters!Acad_Period.Value+"&Aos_Code="& Parameters!Aos_Code.Value+"&Aos_Period="+Parameters!Aos_Period.Value+"&Stage_code="+Parameters!Stage_code.Value+"&anon="+Fields!anon.Value &"','_blank'))"

This is the URL:

https://myserver/ReportServer/Pages/ReportViewer.aspx?/myfolder/Drill_BoEUGTranscripts_ANON&rs:Command=Render&Acad_Period=17/18&Aos_Code=BMUS&Aos_Period=FT3&Stage_code=%25&anon=15015071

but then the drillthorugh is displayed like this: enter image description here

Upvotes: 0

Views: 631

Answers (0)

Related Questions