Graphs - date range issue

[lissa1974]

Hi there, CR2008 using SQL.

I'm reporting from a Helpdesk call logging system. When you log a call it enters a record into a table, stamps it with the creation date, and has an action.....

call No id Action Create date Modify Date

16919 23 Create 01/01/2009 01/01/2009
16919 43 Edit 01/01/2009 07/01/2009
16919 58 Close 01/01/2009 12/01/2009

So for a start date I take any CREATE line and use the create date. For calls closed in a given period I filter on action=close and use the modify date, as there is no closure date. I have created an open report, and I have created a closed report, all fine.

However, what I want to see is a graph show a date range of Jan-April this year, and then a line to show open calls, and a line to show closed calls.

The fact a call could have been opened in 2008 but closed in 2009 means I can't use the start date as one of the axis for the graph, and using the closure date would only show where the tickets have closed, and some might still be open. So I am looking for a graph that looks like...




Closed 345-----------302---------407


Open 301...........247.........325


Jan 09 Feb 09 Mar 09

*Obviously the lines above would wave up and down dependant on numbers!


I basically get problems using the start or the end date in displaying the counts I want. Any ideas???

Thanks

 

[Madawc]

What you could do is write a formula field that checks maximum and minimum dates etc. First get the grouping working in the main report and then graph on it.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[lissa1974]

The problem is graphing on the date, as one ticket could have a start and end date being in the same month, so that ticket should appear under the created section, and the closed section, so grouping would mean one or the other.

There must be a way to do this somehow.