Parameter asking for Year and Quarter? 2

[loveyoursite]

CRV10 - Is there a way to have a parameter in a report prompt the user to select a year and quarter 1, 2, 3 or 4?

I have a simple report of new hires and the user will be prompted to enter which quarter they want the report for. For example, if next January they select Q4, they would also have to select the year 2005.

I know I can use a date range, but would prefer not to if possible.


Thanks!

 

[TheBlondOne]

I believe that you will have to do this manually to be honest. If you create a parameter which just list numbers 1 to 4 (these will be your quarter periods) then create a formula based on this parameter i.e

if {?Param} = 1 then month({Field}) in [1 to 3] else
if {?Param} = 2 then month({Field}) in [4 to 5] etc...

You can then use that formula in your select expert along with the year parameter.

Hope that is of some use

 

[Madawc]

You can have a parameter for years and another parameter for quarter. Compair them to date parts, Year({your.date) and DatePart("q", {your.date) The "q" specifies quarter and will return 1 to 4.

Madawc Williams (East Anglia, UK)