March 12, 2010 at 9:20 am
I'm using SSRS 2005. To set up the drill through action, on the main report, I right cliciked on the textbox (that will have the link) and went to the navigation tab.
I clicked on Jump to Report, selected the drillthrough report and specified the parameters. The parameter names (specified in the navigation tab) match the drillthrough report 'report parameter' names exactly.
When I run the report (from the Report Manager) and I click the link (to open the child report) my parameter values are not being passed correctly because no matter what row I click, I always get the same result (from the child report). If I run the child report manually from the Report Manager, it works.
The weird thing is that I had this working initially (with both the Jump to Report and the Jump to URL options)!! Then I modified the child report to add more columns and I can't get it to work anymore. What happened??????
Could the IE settings have anything to do with this? I had asked my boss to view the report (that was previously working) and he could not get to the child report. I am wondering if he may have changed some IE settings.
I looked at the ExecutionLog and the parameters are being passed incorrectly:
Period=2010001&AccntCode:isnull=true&AnalT0:isnull=true&ConvCode=GBP
Not sure why the AccntCode parameter name has a colon!!
When the report used to work, the parameters were passed like this:
Period=2010001&AccntCode=1-AA-01-A&AnalT0=AC-01-A&ConvCode=USD
March 16, 2010 at 2:30 pm
Hi,
You should also be looking at the child report. Make sure you are passing Field.<FiledName>.Value from Main report. In Child Report, make sure these parameters are non queried, if Its queried then you would have this problem.
Hope this helps.
March 20, 2010 at 10:07 pm
Your suggestion were very helpful. Thank you!!
December 10, 2014 at 11:44 am
Thanks that help me too:-)
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply