Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Parameter asking for Year and Quarter? 2

Status
Not open for further replies.

loveyoursite

Technical User
Apr 14, 2005
100
US
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!
 
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
 
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.

[yinyang] Madawc Williams (East Anglia, UK) [yinyang]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top