August 27, 2014 at 10:22 pm
I have to Create 2 Reports (Parent,Child) applying drillthrough report .Child Report level creating single value parameter,When i am passing parent to child report parameneter value is not passing using MDX.
Can u pls help me on this.
August 28, 2014 at 12:34 am
How do you do the drillthrough? With a drillthrough action on an object?
Can you post a screenshot of the configuration?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 28, 2014 at 3:08 am
I'm going to assume you are using SSRS here....if so you have to be careful when passing parameters from one report to the other using mdx (for a number of reasons including how the sub report expects to consume the parameter) - try changing the expression of the value you are passing to be fields!whateveryouarepassing.UniqueName as a starter for ten.
If you are passing through the value of a parameter already selected and it is multi-value, SSRS will default to the first item in the array (0). Remove this to pass them all.
We need more detail really
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy