Reports/Layouts Scripting Question

[johnnyreno]

Hey there,

Is it possible to generate a report that will ignore lines that contain blank fields? I have a DB with records that contain a project number and 4 different fields of billing codes. I'm trying to generate a report grouped by project # => date => billing codes 1-4. The way FM does this now is by grouping down to date and then laying out billing codes 1-4 across horizontally. I'm trying to get Billing codes itemized vertically under date,which is easy enough but these fields aren't always populated which causes a high amount of white space on my reports. What I'd like to do is have FM ignore any lines with fields that are empty and then shift the rest of the lines up.

Any input on this will be appreciated. Thank You.

[Razumovsky]

Check out "Sliding Objects" in FM help menu- describes how to let blank fields slide up when printing.

HTH

-Raz

[BobWeaver]

You can also combine the fields into one merge field.

[johnnyreno]

Thanks guys, Sliding Objects worked great!