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..
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')
the 'OR' works, but then it also shows those orders with 'Yes'.
we just want to see those orders with 'No'
Any other solution?
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?
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..