The shortest report

[Guest]

Sorry if this is very basic:

I have a table of names and contact details (address, phone no, e-mail) and
I want to print it out in a report, in as compact a form as possible.

Many of the entries in the table have blank fields, some only have a name
and one telephone number. How can I set up the report so that it doesn't
print blank fields?

Grateful for any assistance.

 

[David Lloyd]

One approach would be to create a query behind the report to filter out any
unwanted data using the WHERE clause.

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


Sorry if this is very basic:

I have a table of names and contact details (address, phone no, e-mail) and
I want to print it out in a report, in as compact a form as possible.

Many of the entries in the table have blank fields, some only have a name
and one telephone number. How can I set up the report so that it doesn't
print blank fields?

Grateful for any assistance.

 

[Marshall Barton]

I have a table of names and contact details (address, phone no, e-mail) and
I want to print it out in a report, in as compact a form as possible.

Many of the entries in the table have blank fields, some only have a name
and one telephone number. How can I set up the report so that it doesn't
print blank fields?

If the items are on a line by themselves, you can just set
both the text boxes' and their section's CanShrink property
to Yes.

If that doesn't take care of it for you, please provide more
details about how the data is layed out on the report.