Dynamically displaying graphs 1

[maddyyikes]

I have a graph which gives me the no. of calls logged over a given period of time (No. of problem types encountered v/s each month in 2004 starting from Jan, Feb ......., Dec.) The statistics (report) for the same is being correctly displayed for the current year to date. Even the graphs are being correctly displayed for the same. However, the problem arises when the report automatically runs at the end of a given month(Crystal Enterprise)-(scalability issues). The graphs (bar graphs as well as pie charts) tend to overlap over one another, thus resulting in a messy graphical representation. I am currently using Crystal Reports 8.5 and am using an ODBC driver. The database being used is P4 (proprietary database. In the "Chart Expert" I have used "@date" formula field in the "On change of" option provided in the "Advanced Options" setting of the chart expert. @date formula field uses the following formula:

totext(DTSToDate({incidentsm1.open.time}),"MMM")

I have also used another field in the "On change" options in the advanced options settings of the chart expert - @dept. It is a comprehensive formula with a large no. of select statements which will map a given department no. to a given budget code. For instance,

if {incidentsm1.budget.code}=12000 then "CLIENT SERVICES"
else if {incidentsm1.budget.code}=12780 then "CLIENT SERVICES" else if {incidentsm1.budget.code}=12500 then "RISK MANAGEMENT"
.......and so on.

An equal to condition has been used here as the various departments do not have unique budget code ranges and the range tend to overlap at times.

The value that is being represented graphically is
"count({incidentsm1.problem.type})"

I have also used the following function in the Reports > Edit Selection Formula > Record >

Year(DTSToDate({incidentsm1.open.time}))=2004

(open.time gives the complete timestamp yyyy/mm/dd and hh:mm:ss)

I have the statistics being displayed correctly, from Jan 2004 to July 2004 after which the labels for July and August keep repeating(on the x-axis) thus generating a blank portion in the graph and after a few intervals, I have the statistics being correctly displayed for the month of August. I am unable to understand the reason for this anomaly in behavior of the graph thus being generated. Please help me find a solution for the same. Thanx in advance.

Note: table used: incidentsm1

The sample report that was generated looked something like this:

Dept. Jan Feb Mar Apr May Jun Jul Aug

Client
Services 10 20 5 12 9 11 13 19


I am unable to provide you with a sample copy of the reports as co. policies prevent me from doing so, Sorry about the same!

 

[scottostanek]

You may want to check out the setp where you do this:

In the "Chart Expert" I have used "@date" formula field in the "On change of" option provided in the "Advanced Options" setting of the chart expert. @date formula field uses the following formula:

Note that when you select the date field a button un greys call "order" with two dropdowns. One of those defaults to "for each day" but can also be changed to
"for each month". This is how I do monthly charting,

Using the built in group by month in charting is optimized.
At least it seems to be fro CR8.5

Scotto the Unwise