Null data will be shrinks to nothing on each detail row

[Luong]

I'm writing a report based on a table with too many fields
(about 80). But each record has only about ten fields
with. How do I create a report to print only fields with
data (null fields will be shrinked to nothing) for each
record so that they can fit in a row. Each detail will be
separated with a comma. I also want each field with its
corresponding field name ahead of it to identify the
information.

For example:

1. John Don, title: manager, DOB: 01/01/1975, dept:
Shipping, benefit code: 203B
2. Mary Sam, title: office assistant, dept: Finance,
salary code: 115C, review date: 5/25/2004
3. Veronica Kim: dept: Warehouse, DOB: 01/02/1959,
Location: Renton

Your help is greatly appreciated!
Luong

 

[Fons Ponsioen]

You could do something like:
("Name: " + [Address Line 2])&(", Title:"+[Title])&(",
DOB:"+[DOB])
etc - etc - etc
Hope this helps.
Fons