Grouping Date Range Formulas to Chart

[belltunes]

I am using Crystal 8.5. I am attempting to create a work order workload report where I have created formulas to show various stages of aging: <=30, 31 to 60, 61 to 90, and over 90 days based off a due date field. I'm having no problem grouping, summarizing,and and displaying the data correctly, but when I go to create a chart to display the summary 'count' for each date range group I haven't been able to bring a bar in to represent each of the counts. Is there something I'm missing or a simpler way to do this? I'm using the 'Group' function in the Layout section of the Chart Expert,

Thanks much!

 

[lbass]

The chart should be placed in the report header or footer if you want to see a bar for each group.

-LB

 

[belltunes]

I've got the Chart in the Header and I'm using the 'Group' function in Layout. The formulas I've grouped are for 4 date ranges (<= 30 days, 31 to 60 days, 61 to 90 days and > 90) I'm getting at least 3 of the 4 date range groups on the chart but can't get all 4 to show up. also, since the groups are boolean formulas: True or False, it is only providing a blue or red color on the bars even though there are currently 3 bars showing. I'm trying to have the summary fields for each of these groups to show up as bars on the graph.
I appreciate you getting back to me. Any light you can shed would be helpful or if you think there's a better way to do this.

 

[lbass]

Your grouping formula should look something like this:

if datediff("d",{table.date1},{table.date2}) >= 90 then "90+" else
if datediff("d",{table.date1},{table.date2}) >= 60 then "60 to 89" else
if datediff("d",{table.date1},{table.date2}) >= 30 then "30 to 59" else
"0 to 29"

-LB