Help with Charts

[goduke]

*****I originally posted this in the wrong forum, so moved it to this one. *****

I am creating some charts for some data in my report. The problem I am having is that I am trying to do a simple chart, that shows some counts of a particular field, and its evaluated on change of week. The problem I am running into is that if there isnt any data for that week, then it removes that week totally from the chart. I understand that if there isnt any data, then its not going to be evaluated in the chart. What I would like to do is see if there is any way that you can have the chart show a value of 0 where ever there isnt any data, and the week would still show?

For example...the report shows tickets that came in in the LastFullMonth. For each week ending date, there are counts of those tickets. For week ending 12/31 there were 18 tickets, for week ending 1/7 there were 22 tickets, for week ending 1/21 there were 0 tickets, and for week ending 1/28 there were 25 tickets. So when you build the chart, it only shows the 3 weeks that have data, since there wasnt any data that falls into week ending 1/21. Is there any way to have the report show 0, and still display the date? Any help would be great. Thanks.

 

[Madawc]

I assume you are grouping by dates. When there is no data for a date, there will be no group and also no chart entry.

As far as groups go, the best solution is to create a table for each week, and then link it using a left-outer to link to the details. This depends on you being allowed to create a new table, or can easily get one created to your specifications.

I assume that this will then be chartable, though I've not actually done this.

It helps to give your Crystal version - 8, 8.5, 9, 10, 11 or whatever. Methods sometimes change between versions, and higher versions have extra options.

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

 

[LcdCyn]

Madawc,

I have the same issue. How can I create a dynamic table for this?

Goduke,

Were you able to get this to work?

 

[Madawc]

LcdCyn, what I meant was a new table in the database. In Crystal, a dataset is a 'table', and an Array is something user-defined that might be called a table in other contexts.

Best anyway to start a new thread. Give your Crystal version and database.

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