reset value of field

[Former Member]

I have a report where i am getting totals from a database.

im trying to wright a formula that will change the price value of

{tvwr_Quotes.DetailTotalSellingPrice} to a 0 if word sniff val is greater than 0.00.

this is what i have so far

if {@word sniff} > 0.00 then {tvwr_Quotes.DetailTotalSellingPrice} = Val ("0")

Cheers

[Former Member · Accepted solution]

It should be more like:

if {@word sniff} > 0.00 then 0 else

field1-field2

[Former Member]

thanks for your answer

so i would be looking at a formula like

if {@word sniff} > 0.00 then {tvwr_Quotes.TotalNetSell} -{tvwr_Quotes.PrintLineItemPrices};

Do you think this would be correct.

the only other thing is i have the totals being made in the subreport and the value of {@word sniff} formula is not there

can i link this in some way?

[Former Member]

You cant change database value. Report connection is read only!

You can create formula to display what you need. In the formula you can have if statement and calculate/display whatever you need.

Cheers