filter problem

[gops210]

Hi all,

        I have created a report containing 4 crosstabs from a OLAP cube source,I have a prompt at the top of the report for Quarters

The requirement is that when i run the report should get filtered default for Quarter 4

and when the user selects the propmt say Quarter 3 then it should show Quarter data.
i was not able to put both the filters.

Kindly help me to achieve both the conditions.

[Gopinath]

Hi,

I think you might have solved this issue long back, iam posting this b'coz this might help others.

The filter condition should be

if(?Promptparameter? Is Null) then (Quarter = 4) else (Quarter = ?Promptparameter?)



Thanks

[Venu_Gollapudi]

Hi,

You will be having a Option called Default in Prompt properties, just set it for Quarter 4, this will work out.

[fmtuat]

Hi,

I think you might have solved this issue long back, iam posting this b'coz this might help others.

The filter condition should be

Quarter = if(?Promptparameter? Is Null) then (4) else (?Promptparameter?)



Thanks