April 5, 2011 at 7:00 am
Hi there
I am working on a drill-through report. One my source matrix report, I have a parameter called Region (for example). This displays as a column in my matrix as well. I also have another column on my matrix called Contact. This is not a paramater, but when a user clicks on the metric associated with Region and Contact, I want to send both the Region value AND the Contact value to my target report, as Region and Contact are BOTH parameters on my target report. How do i do that?
I have managed to send the Region parameter value to my target report without problems, but I do not know how to refer to the Contact value...
Any assistance greatly appreciated!
Thanks
Doodles
April 5, 2011 at 9:24 am
In the Textbox properties dialog for the source report. Go to the Action tab, hit the Go To Report radio button. Specify the name of the report you want to go to. Click the Add button and Select the name of the input parameter on destination report, then select the value. The value in your case would be the name of the field (or parameter) that holds the data you want to pass to the new report. To add another parameter and value, click Add again and repeat.
April 5, 2011 at 10:42 am
Thanks for your response.
I managed to get it working with the field name rather than a parameter name, but as I am using an SSAS cube as my data source, I needed to use Fields!Name.UniqueName instead of Fields!Name.Value
However, I can only get the first parameter to work - any subsequent parameters I add don't get passed to the target report, despite being configured in exactly the same way!!!
Any ideas?
Doodles
April 5, 2011 at 10:49 am
Does the destination report work properly with both parameters when you run it standalone?
First I would check the spelling of the parameter in both the source and destination. Also try switching the order of the parameters at the source, does it then pass the parameter that was not being passed before, but not the parameter that was working?
April 5, 2011 at 11:12 am
Yes, the destination report works properly with both parameters when running stand alone. The spellings between both parameters are the same as well.
I have tried switching the parameters and it's always the second paramater that doesn't work... don't understand why though.
April 6, 2011 at 5:33 am
Quite annoying, but managed to solve it! In case someone is trying to do the same thing, i will explain the problem & solution:
For my report I wanted to pass a report paramater and a field value for a specific column, to my target report. As my data source is a cube, I needed to use Field!Name.UniqueName as opposed to Field!Name.Value, because SSAS was expecting this:
[Dim KPI].[Measure].&[Gross Margin]
as opposed to
Gross Margin
However, even when using teh uniquename, the parameter was not being passed for me. SO, I created a dummy text box on my report to write out the Field!Name.UniqueName so i could see what was actually getting passed. And sure enough i found the problem. Because the Measure attribute is part of a hierarchy, mapped to a parent attribute called Strategy, this is what was being written out was something like:
[Dim KPI].[KPI Hierarchy].[Strategy].&[Sustainable Profit].&[Gross Margin]
which show the hirearchical chain but which my target report obviously didn't like.
So back in my report query, i had to remove the hierarchy and add the individual members separately (Strategy & Measure). After that my drill through report worked!!!
Moral of story: always use dummy text fields, etc to write out parameters, fields etc so you know what is actually being passed around - instead of assuming you know!!
🙂
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply