Reporting

[Zara Henessy]

Sorry my last post wasn't very clear.

I am creating a report from a single table of address and
contact information.

For some records a few fields are empty. Is there a way
to supress the empty fields in the report, so that it
doesn't leave a blank space / row, thereby looking neater
and saving paper when I have to print the report out.

I am not using field labels, just the output of the
fields in the reports.

i.e. as in the below example the report skips the third
field (city) for record two as it did not contain any
data.


record 1

Mr A Smith
100 Lakeside Drive
London
555 - 15555
777 - 17777

record 2

Mr J Jones
44 Riverdale Street
444 - 1444
888 - 1888

I really appreciate your help.

Zara

 

[fredg]

Sorry my last post wasn't very clear.

I am creating a report from a single table of address and
contact information.

For some records a few fields are empty. Is there a way
to supress the empty fields in the report, so that it
doesn't leave a blank space / row, thereby looking neater
and saving paper when I have to print the report out.

I am not using field labels, just the output of the
fields in the reports.

i.e. as in the below example the report skips the third
field (city) for record two as it did not contain any
data.

record 1

Mr A Smith
100 Lakeside Drive
London
555 - 15555
777 - 17777

record 2

Mr J Jones
44 Riverdale Street
444 - 1444
888 - 1888

I really appreciate your help.

Zara

Set each Controls CanShrink property to Yes.
Also set the Detail Format CanShrink to Yes.

There can be no other control on that same line.