Reporting from Stored Procedure displays year as 1,999

[chandhureddy]

Hi Friends,

I am generating a report from SQL Server 2000 stored procedure. It looks perfectly fine in designer preview tab.
I am presenting the year and no of customers as Bar chart.
year shows as 1999, 2000 in the desinger preview. But
when i display over the web it displays as 1,999 and 2,000
etc.
I am using segate supplied files

smartviwerActivex.asp
rptserver.asp

etc..
I think i am able to present the problem.

Thanks a lot
chandhureddy@yahoo.com

 

[Sieb]

What you are displaying is not a date but something else. Try the right click on the object and "Format object". Uncheck the "Thousands separator".

Should work

 

[turtlemaster]

if you are using this in a formula you may need to look into the Cstr funtion. you feed it a number and it feeds you a string. you also can specify by the cstr(x,y,z ... what shoul separate thousands and stuff -- check out the help on cstr

 

[kenhamady]

It might be picking up the default format for a numeric from the client PC. If you go into the formatting window for this field and specify a custom format does that help? Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/

 

[chandhureddy]

Hi friends,

Thank you very much for all you help. Here is what
i did....
1. Coverted the int data to string using ToText()
2. Used the Repalce function



Thanks
chandhureddy