Hello,
Thanks all for the help... it's starting to make sense and I'm picking up a few books this weekend as well. I have one more question. Crystal 9 with SQL. I've created a crosstab report and need to decrease the extended price by 50% for certain items, the rest to remain at 100%.
example:
Item Extended Price
K0040009 $140.00
M1370013 $376.00
I tried adding this line to the extened price formula {co_ship.qty_shipped}*{coitem.price}... but it didn't work
if {coitem.item}='K0040009' then (({coitem.price}*{co_ship.qty_shipped})/2) else
Any help would be appreciated.
Thanks-
Lauri
Thanks all for the help... it's starting to make sense and I'm picking up a few books this weekend as well. I have one more question. Crystal 9 with SQL. I've created a crosstab report and need to decrease the extended price by 50% for certain items, the rest to remain at 100%.
example:
Item Extended Price
K0040009 $140.00
M1370013 $376.00
I tried adding this line to the extened price formula {co_ship.qty_shipped}*{coitem.price}... but it didn't work
if {coitem.item}='K0040009' then (({coitem.price}*{co_ship.qty_shipped})/2) else
Any help would be appreciated.
Thanks-
Lauri