index | search | no replies | posting guidelines | help login | register
Index » Products » ASP Report Wizard v2
search this forum:
:: Error displaying decimals :: (7)Post a New Message | Post a Reply
Aug 24 2005, 2:02 PM
 Error displaying decimalsPost a Reply
 scott69

View this author's profile Send this author a private message

from: UK

Hi,

I have a field with some decimal values....if a whole number is in the record it is displayed, no problem. If it is say for example 2.5 it displays as a date as shown below. It makes no difference if the database field is text or decimal....Any ideas?



Aug 25 2005, 6:09 AM
 Re: Error displaying decimalsPost a Reply
 ghost

View this author's profile Send this author a private message Visit author's homepage

from: Washington, DC

I can't seem to reproduce this error. Did you add any data formatting to this field? can you walk me thru?


-------------------------
Ghost
Aug 30 2005, 12:39 PM
 Re: Error displaying decimalsPost a Reply
 scott69

View this author's profile Send this author a private message

from: UK

I used no formatting for this at all within the tool itself.
Within the database I tried formatting the field as text and then as decimal, with the same result unfortunately.

Regards,


Scott.


Aug 31 2005, 6:08 AM
 Re: Error displaying decimalsPost a Reply
 scott69

View this author's profile Send this author a private message

from: UK

Me again ..:-(

I have this same problem with the decimals not displaying correctly.
The values are displayed correctly in both the Access table and the query that I use for the underlying report. As you can see from the attached image, which shows the same records in both the Access query and the AspWebsolution tool, side by side - the values in the red boxes are what is different - a date is shown instead of the decimal value.....notice that "10.0" displays as "10" which is OK I guess, but the "12.50" displays as "30/12/1899"....I'm old but not that old!

Any ideas?



Aug 31 2005, 7:22 AM
 Re: Error displaying decimalsPost a Reply
 ghost

View this author's profile Send this author a private message Visit author's homepage

from: Washington, DC

Can you please send me a sample of your database (if possible a sample of your reports file) so that I can test it !
Email to support@aspwebsolution.com



-------------------------
Ghost
Aug 31 2005, 10:39 AM
 Re: Error displaying decimalsPost a Reply
 scott69

View this author's profile Send this author a private message

from: UK

Just sent it - thanks!



Sep 2 2005, 10:57 AM
 Re: Error displaying decimalsPost a Reply
 scott69

View this author's profile Send this author a private message

from: UK

It works great now!!!

Many thanks!!!

Scott.

Pages: (1)   [1]

search this forum: