Printing a record in a report programatically

[argsemapp]

I have a form feeding 60-field records to a report. I now need to display these records in a cleaned up way (ie skipping some fields entirely, skipping other fields if they have a value that equals 0, displaying "x" if value is below 1). They will need to be in a grid that hopefully will not be too big for the page.

What is the best way of doing something to this effect e.g. "Drawing" a formatted table onto a report depending on your recordset?

Thanks in advance

FYI each record will be different so different fields will have to be excluded/included.

[June7]

Really doesn't make sense. Sounds like a non-normalized data structure.

Provide examples of raw data and the desired output.

[argsemapp]

The database has chemical compositions so there is a field for each element. For example:

RAW DATA:
Alloy1: [Au]=95 [Pt]=0 [Pd]=0.5 [Ag]=4.5
Alloy2: [Au]=0 [Pt]=100 [Pd]=0 [Ag]=0

FORMATTED (printed in automatically generated grid):
Alloy1: "Au" = 95 "Pd"=<1.0 "Ag"=4.5 (The report skips [Pt], and prints [Pd] as <1.0%)
Alloy2: "Pt" = 100 (report skips all other elements)

I hope that makes sense. Basically I just want to print the fields that have a value, and skip the ones that don't.

This is for a report that will be sent to customers so the aesthetic aspect is important. I can't have empty entries for elements in the report.

[June7]

That structure will probably require code.

Options:

1. programmatically build report

2. programmatically write data to a 'temp' table

3. concatenate the data into a single string, ignoring all the 0 values - How many element fields are there?

4. normalize the data and use CROSSTAB query