In my report I ask the user what pay periods data they want in the report. PP for previous pay period and CP for current pay period.

WHERE PAYPERIOD EQ '&PayPeriod'

I have a set of dates in the header that also need to change depending on what the user chooses for the pay period variable.

<80 FROM: <PPSTART  <+0> TO: <PPEND   

Now the header always displays the prevoius pay period dates. I would like these two params to change to CPSTART and CPEND if the users chooses CP as the variable.

So... Can I use the response to one variable to set 2 others?

Greg

This message has been edited. Last edited by: Kerry,

This should do it:

-SET &START=IF &PayPeriod EQ 'PP' THEN 'PPSTART' ELSE 'CPSTART';

-SET &END=IF &PayPeriod EQ 'PP' THEN 'PPEND' ELSE 'CPEND';

...

<80 FROM: <&START  <+0> TO: <&END

That did it!

Thanks Danny.

You could probably even specify:

<80 FROM: <&PayPeriod..START  <+0> TO: <&PayPeriod..END