Problems with Month name in chart
-
- Posts: 4
- Joined: Tue Oct 10, 2017 12:44 pm
Problems with Month name in chart
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.
=> Problems with Month name in chart
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