Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Conditional report formatting

Status
Not open for further replies.

ssim78

Technical User
Feb 21, 2006
5
US
Hello all,
I need some help with conditional formatting of my reports. I want to incorporate formatting logic such that :
if the value of field1 = 'abc' then the report should print 'def' in red font else the report should print 'xyz' in blue font.
I have been looking at the conditional formatting help menu, but could not find any tips on how to replace text with some other text and change the color of that text while running a report.
Please help.
 
Create a foirmula of:

if {table.field1} = 'abc' then
"def"
else
"xyz"

Right click the formula and select format field, In the X2 next to the color of the font try something like:

if {table.field1} = 'abc' then
crred
else
crblue

It may be that you mistated the requirements of displaying something OTHER than what is in the table, but this should give you the means to do whatever you need.

-k
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top