Topic: Comments in crystal reports Posted: 23 Feb 2011 at 5:03am
I am looking to add a comment in to an invoice that will automatically say "Please pay in USD" when the amount owing is in USD. How do I do this? I need this information ASAP.
Joined: 22 May 2009
Online Status: Offline
Posts: 347
Posted: 23 Feb 2011 at 5:18am
do you have a field that distinguishes when an amount is owed in USD? If so, just create a formula that is the text based of the currency type field. So something like:
if {table.currencytype}='USD'
then 'Please pay in USD'
else ""
Place the field where it needs to display and it will only show if the currency type is USD.
Joined: 20 Jan 2008
Online Status: Offline
Posts: 92
Posted: 24 Feb 2011 at 10:43am
If you were looking at your data, how would know if something needed to be paid in USD ? The field to distinguish when an amount is owed in USD must be part of your data already. Otherwise how would you know ? Create a formula as suggested by FrnhtGLI and use the condition to determine if it should be paid in USD as the first part of the formula. Does that make sense ?
It does make sense; however, there is no field to distinguish when an amount is owed in USD, at least i cannot see one. We are trying to figure out how to create a field to let our customer know we require them to pay in USD.
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
IP Logged
