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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Lay person needs formating help

Status
Not open for further replies.

Camper66

Technical User
Jul 25, 2008
33
0
0
CA
Hi Everyone and thank you for your help:

I have the following Group formula;

if {cr_invoice;1.ITEM_TYPE} = 1 AND {cr_invoice;1.STOCKCODE} <> "FREE" THEN
Formula="Received"
else
if {cr_invoice;1.ITEM_TYPE} = 2 then
Formula="To Crest"
else
if {cr_invoice;1.ITEM_TYPE} = 3 or {cr_invoice;1.ITEM_TYPE} = 4 then
Formula="Ordered"
else
if {cr_invoice;1.STOCKCODE} = "FREE" then
Formula="You Saved"
else
end if
end if
end if
end if


I wish to use the Format editor to apply a format ( bold or underline for example)if

if {cr_invoice;1.STOCKCODE} = "FREE" then
Formula="You Saved"


I have tried for example

"GroupName ({@Item_type})= You Saved" "

but to no success.

Thank you for your assistance
 
select the field in the report you want.
right click, choose "Format Field..."
click on the Font tab
click ont he X+2 next to the Style dropdown.
enter your conditions here.
ex:
IF GroupName ({@Item_type})= You Saved" then crBold else crRegular

the style formatting you can use are: crRegular, crBold, crItalic, or crBoldItalic
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top