About report:
I have a parent report which is cross tab report and a child report which is List report. My reporting need is to click on fact/cells in parent report and it should take me to Child report. Parent report have 4 prompts/ parameters.
My Parent report Have 2 data items in rows section of cross tab ( Business Unit and Activity Type, Activity type is nested under Business Unit), 1 data item in Columns Section (IOT Region).
Child report is just a list report which shows the details accounting for the selected fact cell.
Problem:
Child report have 6 parameters. I am passing values for all 6 parameters from parent report. I am passing 3 values as "Pass parameter Value" and remaining 3 as "Pass data Item Value".
3 Values which I am passing as "Parameter Value" are passing correct Values..
Coming to remaining 3 values which I am passing as "Pass Data item Value" one (Business Unit) is passing right Value(Sending the name of Business unit corresponding to the fact cell I an selecting). The remaining two are not passing any values at all.
Is the parent report built from the same package as the child report? If not, is the parent from a dimensional package and the child from a relational package? I could hazard a wild guess that you are passing a businesskey expecting it to be the caption, but without knowing more about how your reports are built it's impossible to say.
MF.