Problems with Month name in chart

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
David_Howard_(Guest)
Posts: 4
Joined: Tue Oct 10, 2017 12:44 pm

Problems with Month name in chart

Post by David_Howard_(Guest) » Fri May 16, 2003 10:52 am

I created a report that displays the number of claims incurred per month. All the totals are correct, but there are two problems:__1. The month label is off by one, i.e. the May totals appear over a June label__2. The label for the last month is the same as the prior month, i.e.__If the last month of data is for April, it displays over a label that says March, which is the same label as for the prior month^s data - I have two "March" columns, even though one is for March and one is for April.

kfleming
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

=> Problems with Month name in chart

Post by kfleming » Fri May 16, 2003 12:36 pm

I just did a report against an order file. I am sorting by orderdate and grouping by mth(orderdate). I have a total field that is a count of orderno reset by mth. I also have a calc field that takes the CMONTH(orderdate)____I placed a chart in the summary band. It is a bar chart where the selected field is the total field, the label field is the cmonth and the sort field is group field ascending with combine duplicates unchecked.____When I print the report, the chart in the summary has the correct totals for each month. ____So in this simple case, everything works correctly for me.____Kathleen__R&R Support

Post Reply