If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Parent Report(Cross tab) Not Passing Data Item to Child Report (List Report)

Started by Venkata_Avula, 22 Jan 2012 06:18:21 PM

Previous topic - Next topic

Venkata_Avula

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.

MFGF

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.
Meep!