1245204 - Date range in Chart for Crystal for all dates not just those dates with data

SAP Knowledge Base Article - Public

1245204 - Date range in Chart for Crystal for all dates not just those dates with data

Symptom

How do I get every date, including those with no data to show on a stacked bar chart.

Reproducing the Issue

Create a report and insert a stacked bar chart with data that doesn't include all dates.

Cause

Charts will initially include only dates for which there is data.

Resolution

Determine the missing dates and force those dates into the chart (see the two attached sample reports).

Keywords

"all dates", chart, range, "date range", bar chart , KBA , BI-OD-CR , CrystalReports.com , Problem

Product

SAP Crystal Reports XI

Attachments

All_Dates.zip