filter based on prompt value

[rajusus111]

Friends ,

I have a report , which has one prompt (country). Values are USA , CANADA .
first case :

If user selects country prompt as USA then report should pick the filter
price > 100

second case : If user selects country prompt value as CANADA then report should pick another filter
which is
price > 50

how can we achieve this in one report ??

currently i created two saparate reports without prompt .
Now i need to merge the report by creating country prompt .

Thanks in advance ..

rajusus

 

[Nuffsaid]

Product would be ?????

Assuming Report Studio....

Filter;

(
?Prompt? = 'Canada'
and
[Price]>50
)
OR
(
?Prompt? = 'USA'
and
[Price]>100
)




Nuffsaid.