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

Report Studio Report with Multiple Conditions(Filters)

Started by dwsupport, 16 Jun 2008 03:06:10 PM

Previous topic - Next topic

dwsupport

I have a report where there are items from several tables
one of the table has 100 items with Yes or No Indicator.
If i run a Report A with Flood Indicator as 'No', it returns 50 records
If i run a Report B with Flood Indicator as 'No', and Earthquake Indicator as 'No', than it returns 12 records.
This happens because i put a filter on the report for both those indicators.

Is there anyway in report studio to display both the indicators as No and still display all the orders where those indicators are 'No', but not necesarily for the same order..

blom0344

How about using an 'OR' operator instead of 2 seperate filters (that will be treated like 'AND')

like:


([Flood Indicator] = 'No' or [Earthquake Indicator] = 'No')


dwsupport

the 'OR' works, but then it also shows those orders with 'Yes'.
we just want to see those orders with 'No'
Any other solution?

rockytopmark

You need to clarify then... do you want " = No" only?  Then why is the original setup with the AND not acceptable?

Can you include a sample of the data and also a sample of the desired output?

blom0344

Baffling   :D

Other funky ideas:

create an item :


[Flood Indicator]||[Earthquake Indicator]


assuming that both fields are not nullable.

Now, at most you get 4 combinations:

YesNo
YesYes
NoNo
NoYes

Now apply filter on this object..