I have been given a MSQL Database Table that has been populated with 3 columns.
Column 1 has a Date, this has been set as a MSQL “Date” datatype.
Column 2 has a Time, this has been set as a MSQL “Time” datatype
Column 3 has intergers
I have tried to display the Data (Col 1 and col 3 only) in a Chart component but the Date as the X plot errors as an unknown value for X plot.
I tried to cast the “Date” to a datetime in the Data query which stops the error but fails to draw anything. The Dataset date column shows as 01/04/2012 00:00:00
If I remove the binding and manually manipulate the dataset Date to have an actual time eg. 01/04/2012 01:00:00 the chart works.
So getting to the question…
Is there a way to combine columns 1 and 2 to make a proper Datetime for the chart in a query or can I format just the Date (col 1) in a way that the chart likes?
Cheers for any help.