Field Display Problem

[viperbyte]

Hello everyone. With CR8.5 I need to be able to allow a user to enter a Quarter when prompted, such as 1, 2, 3, or 4. Our tables don't store quarters. We store months as integers which we call periods. A valid period could be any integer value from one to twelve. I know how to create a parameter for grabbing the quarter value but how do get the report to just show me the periods (months) that pertain to the desired quarter? Can someone super please give me a hand with this?

[jggtz]

You could use a RecordSelectionFormula in your rpt
Let's say that your parameter is named @quarter, then the formula could be like this:

( {@quarter}=1 And {Tablex.Month}>=1 And {Tablex.Month}<=3) ) Or
( {@quarter}=2 And {Tablex.Month}>=4 And {Tablex.Month}<=6) ) Or
( {@quarter}=3 And {Tablex.Month}>=7 And {Tablex.Month}<=9) ) Or
( {@quarter}=4 And {Tablex.Month}>=10 And {Tablex.Month}<=12) )