Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: format column of numbers Post Reply Post New Topic
Author Message
kimt
Newbie
Newbie
Avatar

Joined: 06 Oct 2009
Online Status: Offline
Posts: 39
Quote kimt Replybullet Topic: format column of numbers
    Posted: 23 Mar 2016 at 8:10am
Is it possible to format the first row of a column of numbers to $100,000.00 and each and every other row to be formatted without the $ sign?

Thank you.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 23 Mar 2016 at 8:26am
first row in a group? in the report? in a crosstab? something else?
IP IP Logged
kimt
Newbie
Newbie
Avatar

Joined: 06 Oct 2009
Online Status: Offline
Posts: 39
Quote kimt Replybullet Posted: 23 Mar 2016 at 8:46am
in report.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 23 Mar 2016 at 9:11am
right click on the field
select format field
select number tab
select customize
select currency symbol
use a formula for 'enable currency symbol'

if recordnumber = 1 then crFloatingCurrencySymbol else crNoCurrencySymbol

set up the rest of your preferences on the Number tab
IP IP Logged
kimt
Newbie
Newbie
Avatar

Joined: 06 Oct 2009
Online Status: Offline
Posts: 39
Quote kimt Replybullet Posted: 23 Mar 2016 at 12:22pm
Thank you. That will work for many pages. However, it might be easier to check 'Enable Currency Symbol and then check One Symbol Per Page'.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 24 Mar 2016 at 2:40am
Absolutely. That was not what I had read as your request but it is much simpler if it meets your report specs.
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.018 seconds.