Chart and dates

JockeD · Post by **JockeD** » Thu May 10, 2012 5:08 am

Hello,

I have the same problem as described in Chart on date range
Basically I have a list of dates and values like:

Date Value
1/1/2011 10
1/3/2010 15
1/4/2010 33
1/7/2010 29

I would like to dsiplay this in a chart that displays the chart by month in the X-Axis and display all months between 1/1/2011 and 1/7/2011 including the months that don't have data.
The data is coming from a stored procedure from a system that I don't have control over so I don't have any way to prepare the data on the db.

What options do I have?
I noticed in the last pre release build that there is a new property XAxis.DateTimeStep, can that help?

Thank you,

Regards Joakim

Post by **HighAley** » Thu May 10, 2012 9:20 am

Hello, Joakim.

JockeD wrote:I have the same problem as described in Chart on date range
Basically I have a list of dates and values like:

Date Value
1/1/2011 10
1/3/2010 15
1/4/2010 33
1/7/2010 29

I would like to dsiplay this in a chart that displays the chart by month in the X-Axis and display all months between 1/1/2011 and 1/7/2011 including the months that don't have data.
The data is coming from a stored procedure from a system that I don't have control over so I don't have any way to prepare the data on the db.

What options do I have?
I noticed in the last pre release build that there is a new property XAxis.DateTimeStep, can that help?

What Value do you want to display? Sum, Avg or Count of Values?

Thank you.

JockeD · Post by **JockeD** » Thu May 10, 2012 11:48 am

Hello

Aleksey wrote:Hello, Joakim.
What Value do you want to display? Sum, Avg or Count of Values?

In this simple example I just want to display the actual value, my problem is that I can't get the x-axis to show the months not in the list.
I would like the graph to show all months in between not only the months that is represented in the list.

Thank you,

Joakim

Post by **HighAley** » Fri May 11, 2012 9:31 am

Hello.

We are still working on the Date Time Step property. We'll let you know when it will work as you need.

Thank you.

JockeD · Post by **JockeD** » Fri May 11, 2012 12:23 pm

Aleksey wrote:Hello.

We are still working on the Date Time Step property. We'll let you know when it will work as you need.

Thank you.

Great
Regards Joakim

Post by **HighAley** » Mon May 14, 2012 3:58 am

Hello.

Unfortunately, there is no way to show all months even if there is no data. The exists values are shown only.
The DateTimeStep property shows average values in each column and there will be no null value columns.
As workaround you should create a Data Source and set the Show Zeros property of the Series to flase.

Thank you.

JockeD · Post by **JockeD** » Mon May 21, 2012 2:21 am

Aleksey wrote:Hello.

Unfortunately, there is no way to show all months even if there is no data. The exists values are shown only.
The DateTimeStep property shows average values in each column and there will be no null value columns.
As workaround you should create a Data Source and set the Show Zeros property of the Series to flase.

Thank you.

Thank you for your reply,
I'm not sure I fully understand, could you please provide an example?

Regards Joakim

Post by **HighAley** » Tue May 22, 2012 10:14 am

Hello.

Do you have rights to create template table on server?

Thank you.

JockeD · Post by **JockeD** » Wed May 23, 2012 2:04 am

Aleksey wrote:Hello.

Do you have rights to create template table on server?

Thank you.

No, I'm afraid not...
Regards Joakim

Post by **HighAley** » Wed May 23, 2012 2:51 am

Hello, Joakim.

JockeD wrote:
Aleksey wrote:Hello.

Do you have rights to create template table on server?

Thank you.
No, I'm afraid not...

It seems that the one way to create new DataTable, pass the data from stored procedure to it in the necessary view and only then register this DataTable in your report.

Thank you.