Jump to content

if then statements on reports


This topic is 5661 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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.

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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!

Link to comment
Share on other sites

This topic is 5661 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.