Crystal Reports select currency

Technical Questions

Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions

Topic: select currency

Author	Message
Louzemac Newbie Joined: 11 Apr 2011 Location: Belgium Online Status: Offline Posts: 5	Topic: select currency Posted: 11 Apr 2011 at 5:46am
	Hello All, I"m a new crystal user.Here's my question. I've made a sum by group: here are the groups AMA SAB TVP....and i want to know if it"s possible to put AMA in euro and the others in Usd dollar. Thaks in advance. Louze
	IP Logged


Keikoku Senior Member Joined: 01 Dec 2010 Online Status: Offline Posts: 386	Posted: 11 Apr 2011 at 6:11am
	Right click on the particular field --> format field --> number tab (or something similar) then click customize --> currency tab and you should be able to specify the currency.
	IP Logged

Louzemac Newbie Joined: 11 Apr 2011 Location: Belgium Online Status: Offline Posts: 5	Posted: 11 Apr 2011 at 6:17am
	Thanks for the reply, but if i select euro for ex., i've euro for the AMA, SAB & TVP, and i want to know if it's possible to select euro only for AMA and Usd for SAB & TVP THKS ....Louze
	IP Logged

Keikoku Senior Member Joined: 01 Dec 2010 Online Status: Offline Posts: 386	Posted: 11 Apr 2011 at 6:28am
	Use a conditional formula. Click on the X-2 beside it and specify when it should show euro and when to show $ etc. Perhaps something like if (group_name} = "ABC" then "$" where {group_name} is the crystal field. Edited by Keikoku - 11 Apr 2011 at 6:30am
	IP Logged

Louzemac Newbie Joined: 11 Apr 2011 Location: Belgium Online Status: Offline Posts: 5	Posted: 11 Apr 2011 at 7:25am
	Thanks a lot for the info Everithing ok now A plus.. Louze
	IP Logged

Louzemac Newbie Joined: 11 Apr 2011 Location: Belgium Online Status: Offline Posts: 5	Posted: 12 Apr 2011 at 7:38am
	This solution doesn't match if i create a cross table and i don't understand why. Thanks if somebody has a solution Louze
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 12 Apr 2011 at 7:58am
	you can not use the group name as the cue but rather the gridrowcolumnvalue if gridrowcolumnvalue("table.field") = "ABC" then "$" else ...
	IP Logged

Louzemac Newbie Joined: 11 Apr 2011 Location: Belgium Online Status: Offline Posts: 5	Posted: 12 Apr 2011 at 10:12am
	Many thanks for your help ..... Have a very nice enving or day depends on ...... Louze
	IP Logged

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