Formula \ Supressing problem

[ThomasBrown]

Hi,

Im using CR 9.0 with a SQL Db

A B

Stand Stand Setup
Table Stand Setup
Chair Stand Setup
Juice Stand Setup
Tea
Coffee

Basically all i want to do is ... Im drawing info out of Column A if a column B has text in it must be suppressed. If column B is blank it must display the info in Column A.

Many Thanks

 

[pgtek]

hi

right click on your field in section b
select suppress x2
Not IsNull({your.field})

cheers



pgtek