group tree numbers appearing as decimals on web

[hsandwick]

Dear All:

8.0 Crystal, web environment.

The trees have correct numerical format in the actual crystal report, but translate to two decimal points in the web environment.

I have been able to manipulate the data type in the report itself to format correctly on the web; however, I'm not coming up with a solution to translate the group tree to appear as whole numbers on the web.

Has anyone else had this problem? Does anyone have a solution, please?

Thanks so much.

 

[yakko]

i dont know if it will be helpful but in asp you can use

formatnumber(number,-1,0,0,-1 ) and you will have comas and no decimals.

but in crystal and reporting. if you dont specify the format, when you run the report in crystal take the international configutaion of your pc and show it well, but when you run from the server it will take the intarnational configurations of the server. if you have access to it, you can change it, or the better way its forcing the format from crystal even if it shows well in your computer you need to specify a format.

 

[Ngolem]

you could group on the text representation of the number...the only thing you have to be careful of is that

4200 comes before 480 when sorted alphabetically if they are strings

So when I want numbers sorted in a treee properly when alphabetical I left pad with spaces

@group

stringVar temp := totext({table.numVal},0,"","&quot
space(5 - length(temp))+ temp;

this gives a number with 5 spaces to the left of the decimal

Hope this helps
Jim

JimBroadbent@Hotmail.com