AspWebSolution Forums » Products » ASP Report Wizard v2 » Formatting of decimal/float values

index | search | no replies | posting guidelines | help

login | register

» »

:: Formatting of decimal/float values :: (18)

Post a New Message | Post a Reply

Feb 22 2005, 6:45 AM

Formatting of decimal/float values

PAULELLISON

since: Jan 1, 2004
from: somewhere Hi
When exporting float/decimal values to Excel, everything looks OK in the Excel file. However, when I then try to summarise a column, only non-decimal values are included in the summary:
Ex:
YTVIKT_POP_RIKTVARDE
86,25
80
80
80
80
80
80
92,5
105
105
105
105
900 (SUMMARY OF COLUMN)
Help !!!!!
//Paul

Feb 22 2005, 11:10 AM

Re: Formatting of decimal/float values

ghost

from: Washington, DC Does this happen while you are within excel or in the report wizard?
If in the report wizard, can you please send me a screen shot?

-------------------------
Ghost

Feb 23 2005, 4:16 AM

Re: Formatting of decimal/float values

PAULELLISON

since: Jan 1, 2004
from: somewhere It's in Excel that this happens

Feb 25 2005, 3:27 AM

Re: Formatting of decimal/float values

PAULELLISON

since: Jan 1, 2004
from: somewhere Ghost
Can you not help ?

Feb 25 2005, 5:30 AM

Re: Formatting of decimal/float values

ghost

from: Washington, DC This has to do with your computer's localization.
MS Excel thinks that 86,25 and 92,5 are text values.
Change them to 86.25 and 92.5 and see if it makes any difference.

You can however change your computer settings from the control panel as shown below:

Goto: Start ->Settings->Control Panel->Regional Options
Select: Numbers tab and set your Decimal Symbol to "." or ","

-------------------------
Ghost

Feb 28 2005, 1:09 AM

Re: Formatting of decimal/float values

pellison2668

since: Feb 21, 2005
from: Sweden Thanks Ghost
I agree that this is probably a formatting problem, but the comma is the standard decimal devider here in Sweden. Changing in Windows or Excel doesn't make any differnece.
What supprised me though was that if I replaced all commas with commas (yes you read correctly) then Excel formatted everything as decimals. Thats why I suspect that the problem is in tha API and not in Excel itself.
Back at you :-)
//Paul

Feb 28 2005, 8:18 AM

Re: Formatting of decimal/float values

pellison2668

since: Feb 21, 2005
from: Sweden Ghost
I've now installed the latest version and I have checked the national settings on the sql server, the IIS server and my client. All are running with 1.000.000,00 as standard format for decimals.
When I look att the formatting possibility in websolution, I see that the format is 1,000,000.00 I think this is what is causing the problem.
As 1.000.000,00 is the standard swedish format, I cannot accept anything else. Is there any way to fix this (in which case I will buy an upgrade for 2 servers!)
//Paul

Feb 28 2005, 9:21 AM

Re: Formatting of decimal/float values

ghost

from: Washington, DC It depends on your computer settings not IIS or SQL Server.
Make sure your localization is set to Swedish.

Below is a screen shot from one of our servers I just changed to Swedish to test and works just fine.

To change control settings on Win2000
Goto: Start ->Settings->Control Panel->Regional Options
Select: General tab and set your location to Swedish as shown below:

Let me know if this helps

-------------------------
Ghost

Mar 3 2005, 12:05 AM

Re: Formatting of decimal/float values

pellison2668

since: Feb 21, 2005
from: Sweden Ghost
The report in html format looks like this:
1 11,03 13,10 14,08
2 13,67 18,29 19,22
3 14,03 17,57 17,57
4 PM13 6100 7,25 9,84 11,29
5 PM13 6100 17,59 18,98 20,43
6 PM13 6100 17,92 19,31 20,76
7 PM13 7500 17,73 19,12 20,57
8 PM13 6100 17,59 18,98 20,43
9 PM13 6110 20,76 22,15 23,60
10 PM13 6100 17,59 18,98 20,43
Page 1 of 236 (2365 recs) [1] 2 3 4 � ... Last � Reset Page Size: Reload
Summary:
SUM jWebbKalkyler.SR1 27 053,93
SUM jWebbKalkyler.SR2 35 069,00
SUM jWebbKalkyler.SR3 36 906,61

The excel reort looks like this
PM ProdGrupp SR1 SR2 SR3
11,03 13,1 14,08
13,67 18,29 19,22
14,03 17,57 17,57
PM13 6100 7,25 9,84 11,29
PM13 6100 17,59 18,98 20,43
PM13 6100 17,92 19,31 20,76
PM13 7500 17,73 19,12 20,57
PM13 6100 17,59 18,98 20,43
PM13 6110 20,76 22,15 23,6
0 0 0
I can mail over the excel file - I think this is the only way for you to appreciate the problem
//Paul

Mar 3 2005, 12:24 PM

Re: Formatting of decimal/float values

ghost

from: Washington, DC Please do send me the excel spreadsheet.
If you do have a url link I could access to check out this report please send it also so that we can quickly get this problem resolved.

thanx!

-------------------------
Ghost

May 23 2005, 1:19 AM

Re: Formatting of decimal/float values

PAULELLISON

since: Jan 1, 2004
from: somewhere Ghost
I have e-mailed you details
This is causing REAL problems....please give this immediate attention
//Paul

May 29 2005, 8:16 AM

Re: Formatting of decimal/float values

PAULELLISON

since: Jan 1, 2004
from: somewhere Ghost
I maile dthe details
Are you not able to provide a solution?
//Paul

Jun 1 2005, 9:13 AM

Re: Formatting of decimal/float values

ghost

from: Washington, DC What you have to do is change the regional settings to apply for all users as follows:

Changing the settings in WinXP
Open the "Regional and Language Options" control panel. On the "Regional Options" tab set the locale you wish to use. Then, click on the Advanced tab and check the box at the bottom that it labelled "Apply all settings to the current user account and to the default user profile"

Changing the settings in Win2k
Open the Regional Options control panel. On the general tab, press the "Set Default" button. Select the appropriate locale, and clck "OK" twice to exit the control panel. Windows will advise you that the changes will take effect after the next reboot.

Click here to view my screen shot

Let me know if this helps..

-------------------------
Ghost

Jun 23 2005, 6:05 AM

Re: Formatting of decimal/float values

ansareo

from: Barcelona Ghost,
I have a similar problem here in Spain. The Average and Totals are wrong in my reports wen I use decimal values.
The server Regional configuration is in Spain and numbers are in 123.123.123,12/0,5 notation.
Example:
1 Canarias 346 0,01 1,00
2 Centro 1.261 0,11 16,00
3 Este 646 0,03 2,50
4 Levante 362 0,93 78,00
5 Norte 179 0,01 0,33
6 Sur 829 0,06 6,75

Average 604 *2,17* 17,17
Total 3.623 *13,00* 103,00

The report data columns are in decimal: 1.000,00
Thanks for your help,
Jesus.

Jun 23 2005, 6:13 AM

Re: Formatting of decimal/float values

PAULELLISON

since: Jan 1, 2004
from: somewhere Ansareo
What happens to your data when you export to Excel - are you able to sum the decimal figures and get correct values?
//Paul

Jun 23 2005, 11:22 AM

Re: Formatting of decimal/float values

ghost

from: Washington, DC Do you have a link to this report which I can check?

-------------------------
Ghost

Jun 27 2005, 1:18 AM

Re: Formatting of decimal/float values

ansareo

from: Barcelona Sorry,
The server is in intranet.
here is a report without formating data in average column.
Territorio Anexos anexos anexos
(Sum) (Avg) (Max)
1 Canarias 347 1,01781170483461E-02 1
2 Centro 1.276 0,109986504723347 16
3 Este 646 2,82051282051282E-02 2,5
4 Levante 362 0,930035128805621 78
5 Norte 179 5,64971751412429E-03 0,333333333333333
6 Sur 843 5,54113523545838E-02 6,75

Average 609 2,17 17,17
Total 3.653 13 103

I send you a mail.

Jul 29 2005, 5:02 AM

Re: Formatting of decimal/float values

ansareo

from: Barcelona Hi,
any changes about this?

Pages: (1) [1]