dynamic report

[dome]

Hi,

I'm trying to get my report to print
only the fields in a record that have a
value (<>0) and then move to the next record
and do the same so that the final report will
print like this

eg
6" PVC (record 1)
0-8 ft - 100
8-10 ft - 200
14-16ft - 100

8" PVC (next record)
0-8 ft - 10

10"PVC (next record)

and so on

Any ideas

I can't seem to get the query to do want I want it to.

Thanks for any ideas

Dome

 

[dome]

anyone?

Bueller?

 

[dcorey]

You can put all your fields in the Detail section, and set their Can Shrink properties to Yes. That way, if the field is null, it will disappear. However, if the value is actually 0, that won't work. At any rate, the Detail section will repeat for all records.

Hope that helps!
dcorey