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 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply