Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Need help on Number Format Post Reply Post New Topic
Author Message
keywest
Newbie
Newbie


Joined: 02 Apr 2009
Online Status: Offline
Posts: 2
Quote keywest Replybullet Topic: Need help on Number Format
     Posted: 07 Apr 2009 at 8:54pm
i would like to know what is the equivalent SQL command in oracle for the Number format in Crystal
 
-1123 (Decimal -- 1,rounding --1, Negatives  -123)
 
(1123) (Decimal -- 1,rounding --1, Negatives  123)
 
I mean to achieve the same output of crystal format in oracle, what should be the command used in oracle?
 
 
Please let me know
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4374
Quote lockwelle Replybullet Posted: 08 Apr 2009 at 7:36am
Isn't this just formatting?  I don't know that there is a SQL command.  Crystal just allows you display numbers differently.  .NET has some standard formats, but I don't think that SQL does.
IP IP Logged
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