cancel
Showing results for 
Search instead for 
Did you mean: 

Formatting the Group Tree?

Former Member
0 Kudos

Post Author: paulold

CA Forum: General

I create grouped reports in Crystal all the time. (I am now using CRXI.) One little pet peeve I have is how Crystal presents the Group Tree when I am using a number field for my grouping. For example, we have order numbers like 10128276 and if I want to group my report on the order number, the group tree will do so, but the order numbers will look like this: 10,128,276.00. This looks like a mistake to my endusers. Sure, I can live with it, but I would love to hear of a way to format what appears in the Group Tree. Why doesn't the formatting of the group header get carried over into the group tree? Thanks! PaulOld@aol.com

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Post Author: SKodidine

CA Forum: General

Checkout this KBase article. If you do not want commas then change the suggested formula to totext(,0,"",""). Pay particular attention to the drawback mentioned at the end of the article.

Formatting the group tree to display numeric values without decimals