| Author |
Message |
Msarvepalli
Newbie
Joined: 21 Apr 2009
Online Status: Offline
Posts: 7
|
   Topic: Format in Group Tree
Posted: 21 Apr 2009 at 12:50pm |
I grouped my report based on the Client Numbers. Client number is a String, but was converted to number format. I could remove the decimals on Group name, but I still see them on the Toggle Group Tree. I am not sure how to change that format.
Any thoughts on how I should remove them.
Thanks in advance!
|
 IP Logged |
|
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 21 Apr 2009 at 1:49pm |
Under File > Options > Fields Tab
Click on Number
Select NUmber Tab.
Change the default here to to what you want it to look like.
|
|
IP Logged |
|
Msarvepalli
Newbie
Joined: 21 Apr 2009
Online Status: Offline
Posts: 7
|
Posted: 22 Apr 2009 at 5:59am |
That works!!  . Thank you!
|
|
IP Logged |
|
Msarvepalli
Newbie
Joined: 21 Apr 2009
Online Status: Offline
Posts: 7
|
Posted: 22 Apr 2009 at 9:55am |
Dblank, your suggestion works when I preview the report on crystal, but I could still see the decimals on group tree when I preview the report from Crystal viewer. Not sure how to get those go away!!
|
|
IP Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 22 Apr 2009 at 9:59am |
You may be stuck with having to use them as a string with the viewer...
Why did you convert from a string to numeric to begin with? Any reason that precludes the use of a string?
|
|
IP Logged |
|
Msarvepalli
Newbie
Joined: 21 Apr 2009
Online Status: Offline
Posts: 7
|
Posted: 22 Apr 2009 at 10:09am |
Well, the client numbers that we use are not always numeric. Like, they could be 10.0001 or AAA.0003.
In my report, I am grouping only client numbers with numeric values though!
|
|
IP Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 22 Apr 2009 at 10:13am |
|
How are you excluding the non numeric ones?
|
|
IP Logged |
|
Msarvepalli
Newbie
Joined: 21 Apr 2009
Online Status: Offline
Posts: 7
|
Posted: 22 Apr 2009 at 10:20am |
|
I have the files divided into two categories on all reports. Numeric falls under cat1, and non-numberic under cat2. So, I group these numeric files based on formula Int(Val(tablename.filenumber)) and when user chooses cat1 files, they only see this grouping. Hope I am clear!
|
|
IP Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 22 Apr 2009 at 10:22am |
Gotcha.
In that case your select statement is independent of the conversion of string to an int so why not just leave it as a string and group on it. This will elminate the trailing .00...
|
|
IP Logged |
|
Msarvepalli
Newbie
Joined: 21 Apr 2009
Online Status: Offline
Posts: 7
|
Posted: 23 Apr 2009 at 7:02am |
|
I tried doing that, and now I see each file under its own group. Thanks for your continued support!
|
|
IP Logged |
|
|
|
