Charting with date values using OWC11

[Sonia]

Hi,

I am using Visual studio 2003.I want to draw a chart with x-axis values as
project names and Y-axis values as dates. I am getting all the valeus froma
database tables. I can see chart in my webpage.

My problem is , on Y-axis it is taking date values as 2/1/1899 to 2/1/1900.
But my projects haas dates from 2/1/2004 to 4/1/2009.

How can I make my chart to display correct date values on Y-axis?

I would really appreicate any kind of help!!!!

 

[Alvin Bruney [MVP]]

you will most likely need to do some conversions with your date so that they
are recognized. If they aren't recognized (in the wrong format when compared
to your culture) the date will display junk.

--
________________________
Warm regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
Professional VSTO.NET - Wrox/Wiley
The O.W.C. Black Book with .NET
www.lulu.com/owc, Amazon
Blog: http://www.msmvps.com/blogs/alvin

 

[Sonia]

Thanks for your response.
Could you tell me how can I check what is culture on my webserver and how to
change it ?

you will most likely need to do some conversions with your date so that they
are recognized. If they aren't recognized (in the wrong format when compared
to your culture) the date will display junk.

--
________________________
Warm regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
Professional VSTO.NET - Wrox/Wiley
The O.W.C. Black Book with .NET
www.lulu.com/owc, Amazon
Blog: http://www.msmvps.com/blogs/alvin
-------------------------------------------------------

Hi,

I am using Visual studio 2003.I want to draw a chart with x-axis values as
project names and Y-axis values as dates. I am getting all the valeus
froma
database tables. I can see chart in my webpage.

My problem is , on Y-axis it is taking date values as 2/1/1899 to
2/1/1900.
But my projects haas dates from 2/1/2004 to 4/1/2009.

How can I make my chart to display correct date values on Y-axis?

I would really appreicate any kind of help!!!!

 

[Alvin Bruney [MVP]]

the owc runs on the client, so each client would potentially render
differently. check control panel | regional and language settings. owc
behaves funny with dates when bound to a datasource because it depends on
excel and excel has known issues with that sort of thing.

--
________________________
Warm regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
Professional VSTO.NET - Wrox/Wiley
The O.W.C. Black Book with .NET
www.lulu.com/owc, Amazon
Blog: http://www.msmvps.com/blogs/alvin
-------------------------------------------------------

Thanks for your response.
Could you tell me how can I check what is culture on my webserver and how
to
change it ?

you will most likely need to do some conversions with your date so that
they
are recognized. If they aren't recognized (in the wrong format when
compared
to your culture) the date will display junk.

--
________________________
Warm regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
Professional VSTO.NET - Wrox/Wiley
The O.W.C. Black Book with .NET
www.lulu.com/owc, Amazon
Blog: http://www.msmvps.com/blogs/alvin
-------------------------------------------------------

Hi,

I am using Visual studio 2003.I want to draw a chart with x-axis values
as
project names and Y-axis values as dates. I am getting all the valeus
froma
database tables. I can see chart in my webpage.

My problem is , on Y-axis it is taking date values as 2/1/1899 to
2/1/1900.
But my projects haas dates from 2/1/2004 to 4/1/2009.

How can I make my chart to display correct date values on Y-axis?

I would really appreicate any kind of help!!!!