COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Report Studio => Topic started by: bhassel on 05 Sep 2007 10:04:38 AM

Title: Pass Parameters to Drill through conditionaly
Post by: bhassel on 05 Sep 2007 10:04:38 AM
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?

Title: Re: Pass Parameters to Drill through conditionaly
Post by: COGNOiSe administrator on 07 Sep 2007 09:37:15 PM
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.
Title: Re: Pass Parameters to Drill through conditionaly
Post by: bdybldr on 19 Sep 2007 02:10:37 PM
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).