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

Multiple Text Prompts - Dependent on each other

Started by johnmabe, 28 Sep 2010 12:36:03 PM

Previous topic - Next topic

johnmabe

Hi,

I have two calculated data items on my report "Daily Shipped" and "AVG cases Per Line". Users want to filter the report to only display records that have "Daily Shipped" > "X" AND "AVG Cases Per Line" > "Y".

I created two text box prompts and when I enter values, the "Daily Shipped" will produce the correct results but "AVG cases Per Line" may be a value less than what I am expecting. Is there a way to make 2 text prompts dependent on each other similar to a cascading prompt for a value prompt?

Or is there a better approach to go about this?

Thanks

MFGF

How is/are the filter(s) defined?  I'd guess either an incorrect operator, or incorrect timing (before aggregation vs after aggregation).

Cheers!

MF.
Meep!