Hello everyone.  This is my first post.  I hope to be able to contribute in the future but for now I'm asking for help. 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? 

I'm missing something.  I fail to see how the correct records are going to show up.  If quarter 2 is enterd then that would mean that i need only records with value 4,5 or 6 in the period column.  How do I get his bit of code to hookup with either SQL or a forumula?  I'm a newbie sorry for my ingnorance.

I think I would do it slightly different.

Start by making you parameter where users can choose which quarter they want to use. Set this as a number parameter. Name this Quarter

I would then create a formula like

If {table.month} = 1 then 1 else
if {table.month} = 2 then 1 else
if {table.month} = 3 then 1 else
if {table.month} = 4 then 2 else
if {table.month} = 5 then 2 else
etc.
Name this Quarter as well. (formula's will start with a @, parameters with ?, so that won't give a problem)

If you then group on this formula, you will get 4 groups. One for every quarter.

In your section expert, conditionally suppress your group with the following formula

{@Quarter} <> {?Quarter}

This will suppress your group when it is different from the value you enter in your parameter.

from a data select perspective I would alter this a bit unless you do want to pull all the data and then suppress it.

Thanks everyone and a special thanks to Gurbs.  With a little help from you guys I hope to make a good enough impression to pass my 90 day probation.