Datawindows... PB 9

[Iceman709]

Hi..

I have a question regarding datawindows in version PB9.

I am creating a report which will print off employee information.

Example.. I am running a report wide open and it returns 25 employees.

For each employee, I would like to have a section on the report for Employee Notes, but only if notes exist for that employee.

When the report is generated, is there a way I can tell a column, if your value = '' or NUll for this employee, set the visibility to false, otherwise, visibility to true?

Any suggestions.

Thanks!

 

[mbalent]

Use an expression on the visible property of the column in the datawindow which makes up the report. Something like:

 If(IsNull(mycol),0,mycol = '',0,1))

Matt

"Nature forges everything on the anvil of time"

http://www.anvil-of-time.com

 

[Iceman709]

mbalent.. Excellent!
Works great.

Thanks so much for your help.

Cheers!