Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Add tax to purchase order if Canadian Post Reply Post New Topic
Author Message
HDMiller
Newbie
Newbie


Joined: 30 Nov 2016
Location: United States
Online Status: Offline
Posts: 5
Quote HDMiller Replybullet Topic: Add tax to purchase order if Canadian
    Posted: 06 Dec 2016 at 4:44am
Hey everyone! My first noob post, so please bare with me as I'm learning!
I have a purchase order generated in crystal that I need to add tax if the supplier is in Canada. This is someone else's report, but I think I've figure out what I need to do. Here is what I've done, but when I print the report, it completely ignores what I've entered in the formula workshop.

If {Supplier_1.CurrencyRef} = "Canada" then
{Supplier.ValueAddedTaxValue} + " " + {Supplier.BaseCurrency} else
{Supplier.ValueAddedTaxValue} + "0" + {Supplier.BaseCurrency}

Any suggestions?

Thanks!

Henry
IP IP Logged
kevlray
Admin Group
Admin Group
Avatar

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Quote kevlray Replybullet Posted: 06 Dec 2016 at 6:33am
The first thing to do is drop a test formula on the report to see even if your If is working correctly i.e.,  If {Supplier_1.CurrencyRef} = "Canada" then true else false


IP IP Logged
HDMiller
Newbie
Newbie


Joined: 30 Nov 2016
Location: United States
Online Status: Offline
Posts: 5
Quote HDMiller Replybullet Posted: 07 Dec 2016 at 4:08am
Thanks for the reply! I got it to work, but had to start over with everything. I learned that the software does a lot of internal calculations, and the form just shows them. So I had to change what I displayed and did my own calculations from on the form.
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.