Hidden values

[potts]

I have a report that lists the charges to one of two fields - customer or athlete. Therefore, one or other field in any given row in the dataset will be blank

I want the list to be continuous as this is to be sent as an invoice. If I place the customer field on top of the athlete field on the report, the athlete field remains hidden, whether there is information in it or not.

does anyone know how I might get the report to show whichever field holds the information while both occupy the same space in the report design??

 

[Fizzio]

You could in the format event of the section your field is in

eg.

If isnull(AthleteControl) then me.athletecontol.visible = false
me.customercontrol.visible = true
Elseif isnull(CustomerControl) then me.athletecontol.visible = true
me.customercontrol.visible = false
end if

or something similar.