Printing report

[Pavel]

I have built a billing database that lists all services available for our company. The user can tab through and select the service rendered, etc. Now I want to print an invoice, but want only the services used to print. ( for example not every customer uses every service we offer) How can this be done and what would be the best way to set this up. Thanks for the help.

Pavel

[LiveOak]

Nope, clairvoyance still isn't working! Guess you will have to tell us a little about how your files are organized (files, fields, structure). -bd

[pspafford]

I think I see what you are getting at. Instead of putting the actual fields for each service on the report, create calculation fields for each service.

For example: You have fields for Service1, Service2, Service3 dollar amounts. Create two calculation fields for each of these. The first one, called Service1_Description, looks like

If(Service1 > 0, "Service #1", " ").

The second one, called Service1_amount, looks like

If Service1 > 0, Service1, 0).

Then, put all of these fields on your invoice. If there is no amount in Service1, neither the description, nor the dollar amount will show up on the invoice. Make sure to set the Sliding up option, so that the blank space for these fields doesn't show when you print.

Is this what you were looking for?

Paul.

------------------