Suppress Lines in a Report

by Bill Warner

Many of you Alpha Four users might remember how easy it was to suppress a line in a report. This was great for a report with many columns, where you didn't want the line if one value was zero.

Well, here's a way to do it in Alpha Five. Create a conditional object that is as wide as all your fields. Define a condition that says FIELD1<>0, where FIELD1 is the field that determines if the row will appear or not, and then place all your fields inside this object. Make sure you select Object can shrink in the properties. Also, right-click the region in which you placed the object, click on Properties, Region, and select Shrink contents of band.

When FIELD1 is equal to zero, none of the fields will show, and the object and region will shrink. Result: the row has been supressed, with no blank space.