Layout issue in access reports

[Jeroen Verdrengh]

Hi,

I have a report showing all visits in my DB and for each visit I have a
group of reletad VAT tariffs that are shown below each visit. The problem
is that not all visits are related to one or more VAT tariffs. Here is,
simplified, the querytable I use for the report:

[Visit Object ID] [VAT Tariff (%)][Info related to VAT Tariff]
1 0.20 blahblah
2 NULL NULL

Is it possible to ignore header/detail/footer of a grouping attribute (VAT
Tariff in this case) if the attribute is null? Now the labels are shown and
that's far from clear. With IIf(..) I can hide the labels when VAT Tariff
is null, but then there is blank space left...

thanks!

Une-V

 

[Jeroen Verdrengh]

problem solved