Page 1 of 1
Problems with Month name in chart
Posted: Fri May 16, 2003 10:52 am
by David_Howard_(Guest)
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
Posted: Fri May 16, 2003 12:36 pm
by kfleming
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