[Migrated content. Thread originally posted on 11 January 2006]

Hello,
When you use Acubench Report Writer to create a report (graphical or text), is it possible to suppress the printing of a line when the field contained in that line is spaces?
For example:

Name
Address1
Address2
City State Zip

Is it possible for the City-State-Zip line to print right underneath the Address1 line if Address2 is spaces?

There is no automatic way to tell the Report Composer to do it. But you can accomplish what you want by using a BeforePrint event.

In the Report Composer select the Address2 field, click on the Event tab in the property window, click in the BeforePrint field, then click the button with the ... Click OK to accept the paragraph name or give it a new one. Now enter the code to do what you want.

It will be something like:
If Address2 = spaces string City, State and Zip into Address2 and then move spaces to City, State, and Zip.

---