Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Feb 29, 2008 02:56 PM|LINK
It's very simple what I achieve from the chart.
I have a table like this:
02-Jul-07 08:43 3D
02-Jul-07 08:50 3D
03-Jul-07 08:50 3D
04-Jul-07 08:50 3D
these 2 columns are VARCHAR type in my DB Oracle (Are these kind of types wrong for my chart?)
I just want to obtain a chart like this
on x axes I just want to put TIME_APPL data and on y axes number of item "3D" in range of date
for example the data that must be on my chart should be the following
02-Jul-07 3D (2 times)
03-Jul-07 3D (2 times)
04-Jul-07 3D (1 time)
What I want to know is if the query must be execute in .cs file, like this "SELECT SUM(APPL) FROM ecc..."
or if can I delegate the count in chart properties (=Sum(Fields!APPL.Value)).
At the moment in .cs file I execute a query like this "SELECT * FROM ecc.."....
and on chart properties I assing this value on y axes (=Sum(Fields!APPL.Value)). and this value (=Fields!TIME_APPL.Value) on x axes....... but the chart is always empty!