I will try using the case statement.

I have a report parameter for the querter which is chosen before the report is displayed.

Would I need to cater for each quarter (Q1 - Q4) with case statements or can I use a reference to the report parameter in one case statement?

Thanks