Reports

[Angelique]

It's me again!

The application allows for four (4) courses to be run for one (1) client.

The report will produce the start and finish times for four (4) courses. The user doesn't want the 2nd, 3rd or 4th fields displayed on the report if they are "blank" - null or empty.

I have considered checking whether the fields for 2nd, 3rd & 4th are null and produce a report with only the 1st being displayed. This would mean that I have two formats of the same report.

Question:

Can I use the syntax:
If isnothing(2nd field etc) then
print Report X
Else
print Report Y
End if

And where should I put this code given many of the reports first asks through a parameter Start & End Date.

I am sure there is a thread there that is similar but I haven't found it.

Thanks


Angelique

 

[JimRich]

Try testing for a blank or null field in the ON Open or ON Format event and setting the Visible property to "NO" for the empty fields if there is no data available.