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

[Closed] Hard Coded Drilling Parameters

Started by Marcelv, 05 Mar 2006 08:24:14 PM

Previous topic - Next topic

Marcelv

Hi AllÃ,  ;D

I'm having a hard time with some drilling of reports and the passing of parameters between them.

I have a Cross-Tab report containing top-level dashboard information where I am building a drill down on the label contained in the top left cross tab corner label in order to drill to the detail. e.g.

SALESÃ,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  MthÃ,  Ã,  Ã,  Ytd

Target 1
Target 2
Target 3

Will Drill to:

Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã, City 1Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã, City 2Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  City 3
SALESÃ,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã, MthÃ,  Ã,  Ã, Ytd

Target 1
Target 2
Target 3

I'm linking off the SALES title there in the top left corner.Ã,  The sub report requires one parameter which states if you want to see the business by Location or Division. Unfortunately I cannot seem to get this to link correctly.Ã,  I have added City and Division as Data Items in the Source Report, Placed the items into the Dimension of the query and included two different drill down links off the SALES title each referencing a different element so that my user can pick between drill paths to the target report.

Unfortunately the Target report still asks for the Parameter to be entered even with these items included in the query and passed onto the drill-down link.
Is there a way I can just pass a hardcoded parameter value to the sub report (I know exactly what I want to pass and that is fixed in this case and does not rely on the data)?Ã,  Or is there something I havent set up in the query that should allow the data through.

Thanks guys/and girls

Dazed and confused developer.....

Marcelv

Hi, just closing off this one.

Have ended up not using different drill paths at all but merely linked to the sub report and made the parameter be selected at the prompt page of the sub report ratehr than trying to pass it down.