if then statements on reports

[agtjazz]

I have created a report that prints and need help with some calculations. The fields are in the database, but should only print out on the report if a certain condition is met.

For instance, if employee status = FERP, then print Date of Birth. (I don't want the dob printed for all employees- just those with FERP status).

I don't want a button to do this, this logic needs to be on the report somewhere. I don't know where to start.

Any assistance is greatly appreciated.

[Razumovsky]

Hi Agtjazz,

I think you could do this easier with a calculation field:

Case(employee status = "FERP"; DateofBirth)

You can place this field on your layout, and it will be blank for all employees except for FERP's, which will show what is in your field called DateofBirth.

Look at the help menu under the case function - it is pretty easy to modify and very handy.

HTH

-Raz

[agtjazz]

Works perfectly..... Thank you very much!!!

I would have never thought to make another field...I was looking for parameters or something for the report as I would in Crystal or so.

Thanks bunches again!