TopN Chart Shows Blank Columns

[carla]

I created a report that contains 2 groups. The first group is based on the date a Technical Support case was entered and the group is printed for each month. The second group is based on the customer name that opened the Technical Support cases and contains all of the cases that the customer opened within that month. A customer can obviously be listed in more than one month (group).

I want to create a bar chart that reports the top 10 users for each month for 12 months, based on the count of support cases opened by the customers. Some customers in each month's list will be the same, but there will be some differences.

This works fine for the first month. For each month after, it reports the top 10 customers, however, it leaves a blank column between bars to account for the customers that were a top 10 user in the previous month, but not the current month.

Does anyone know how I can get rid of those blank columns in the chart?

Any help is appreciated! )

 

[HowardHammerman]

While there may be a Crystal solution, the approach I would take is to export the results to Excel and do the charting in Excel or in Powerpoint. Charting is not one of Crystal's strengths. Howard Hammerman,

Crystal Reports training, consulting, books, training material, software, and support. Scheduled training in 8 cities.
howard@hammerman.com

http://www.hammerman.com

800-783-2269

 

[carla]

I was afraid of that. Thanks for your response Howard.

 

[IdoMillet]

How about creating 12 subreports, each showing a graph for one month (and placing them side by side)?

Cheers,
- Ido

ixm7@psu.edu

 

[carla]

Hi Ido,

Yes I was actually able to do something similar to that. Unfortunately, management wants as much information in one chart as possible.

Thanks for your response!
Carla )

 

[carla]

I just talked to Crystal Decisions Technical Support, and unfortunately, this is a limitation of Crystal Reports' charting abilities.

The good news is that the incident is being tracked for a possible fix in a future release.

Carla

 

[IdoMillet]

Carla,

By placing and formatting the 12 subreports appropriately
you should be able to produce what looks like a single chart.

Cheers,
- Ido

p.s. good to know the issue is on the fix list though I actually hope it is given a low priority. Personally,
I'm surprised at how long certain more important limitations of Crystal are allowed to persist. Crystal is a VERY powerful tool, but the development staff, in my opinion, is ignoring a number of obvious and relatively easy improvements.

ixm7@psu.edu