How do I create a 18 month trend bar chart in Crystal Reports that displays months with no data

I am trying to create a 18 month trending bar chart.  My problem is that if a particular month doesn't have any data, the Month/Year axis label doesn't display.  I need to have all 18 month/year axis labels display even if there's no data for some months.  The bar would just not display any value for those months. Avg closure time chart missing sequential months
djhoganAsked:
Who is Participating?
 
mlmccCommented:
Unfortunately with Crystal if there is no data for the month, it won't display the date in the chart unless you "trick" it into thinking there is data.  Thus the idea of adding a table.

mlmcc
0
 
GJParkerCommented:
start here: http://kenhamady.com/news0208.shtml
scroll down to the 'Reporting on Data that Isn't There" section.
it should get you moving in the right direction.

HTH
0
 
PCIIainCommented:
If you check the chart expert there is a special 'Numeric axis' bar chart (which works with both numeric and date axes). This type of chart does have limitations against a standard bar chart (I'm unsure why).

Alternatively there's the calendar table. Create a table of all the dates in the periods you're working across (last year, this year and next year?) and left outer join from this table to your data. Then you'll have a row in the results for each day, even if there's no other figures. That's generally enough to force the report.
0
Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

 
djhoganAuthor Commented:
The Numeric Axis chart didn't work and Unfortunately, I can't add a table.  I am pulling the data out of a complaint application.
0
 
PCIIainCommented:
In what way does the numeric axis chart not work?

Is the column you are using for the axis actually a date?
0
 
djhoganAuthor Commented:
It gives me the same results when using the bar chart
0
 
PCIIainCommented:
Hmmm, I don't think it would fill  in the dates at the bottom, but it should space them properly. Is the column actually a date?
0
 
djhoganAuthor Commented:
Yes, it is complaint date by month
0
 
djhoganAuthor Commented:
Not a reasonable solution
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.