jmathew
17th November 2004, 10:51
Hi,

I have a report and if all fields have zero value then that particular row is to be darkened. How is this possible? Please help if there is a solution.

This is for printing purposes.

mark_h
17th November 2004, 16:57
I have never tried this, but maybe in the before layout of the report script you could check all the values and use the CF$(1) command to turn bold on. Then in the after layout set cf$(0) to set back to normal. Not really sure if this would work.

What I typically do is add a new field at the end of the line. Then in the report script in the before layout section I check the fields. If all fields are 0 then I set this new field to "*" or something. Then in the after.layout session set it back to a space. Or if you have few enough fields you can put in the print expression something like x = 0 ? "*" : "". Just some options.

Mark

steveauckly
17th November 2004, 17:55
You could have two identical layouts with one printing reversed (this is an option on each field in the layout). You would have to have a print condition to determine which layout gets printed.