Method:Classic General Q&A

Re: Calculated Fields in Report Designer?

SpaScapes — Fri, 01 Apr 2011 01:43:24 GMT

Thanks for the help, I finally figured it out!!!

If anyone else wants to do this, enter this script into a Before Print script window:

If xrItemAmount.Text = "$0.00" Then xrItemAmount.Text = "included"

Keep in mind, this example is for the ItemAmount field. Also, the script will not work if you actually put it into the ItemAmount field script itself. It has to be in another field. It seems that fields won't edit themselves, but will edit others.

Re: Calculated Fields in Report Designer?

Method_Michael — Thu, 31 Mar 2011 14:11:07 GMT

Hi SpaScapes,

Take a look at the Print Before scripts on the Qty and Cost fields on the Estimate (Custom) template. This should give you a better idea of what you need to do.

-Michael

Calculated Fields in Report Designer?

SpaScapes — Wed, 30 Mar 2011 18:57:31 GMT

I can't find any relevant posts or webinars on calculated fields. I've been struggling with the syntax.

Some of the items in my quotation are not chargeable, but I want them included on the estimate. Instead of $0.00 I want the report to display 'Included'.

I've been playing with this for over an hour. The expression I have is:

if([Estimate.EstimateLine.Estimate.TotalAmount] is null,'included',[Estimate.EstimateLine.Estimate.TotalAmount])

It doesn't work. Anyone have any ideas?