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

Pass Parameters to Drill through conditionaly

Started by bhassel, 05 Sep 2007 10:04:38 AM

Previous topic - Next topic

bhassel

I have a series of drill through reports in which I'd like to conditionaly pass a parameter.  For example if [field name] > 0 then pass parameter.  If = 0 then do not.  Does anyone know a way to accompolish this?


COGNOiSe administrator

Not with the wizard, I'm afraid. But if you calculate the drill through URL instead, then yes. Or you could conditionally ignore some passed parameters in the drill-through report, meaning pass all the parameters over, and decide in the target report which ones to use base on their values.

bdybldr

Create two data items in the same field.  One drill-through will contain the parameter, the other won't.  Then, just hide or display each data item, based on the condition (field name] > 0).