Hi All,
I have a report based upon a query, which returns data based upon a financial year. I have, in the query, included a month ranking from 1 to 12 to allow it to display July to June correctly in order, however, I have created a Chart Report and I am unable to get it to sort by the month ranking? Is there a way to sort these style of reports? My query sorts nicely, however, I don't seem to have the option within the 'Chart' report?
Any help or other suggestions are greatly appreciated.
From the Land of the New Prime Minister (Australia)
Cheers & Beers
Rat.
I have a report based upon a query, which returns data based upon a financial year. I have, in the query, included a month ranking from 1 to 12 to allow it to display July to June correctly in order, however, I have created a Chart Report and I am unable to get it to sort by the month ranking? Is there a way to sort these style of reports? My query sorts nicely, however, I don't seem to have the option within the 'Chart' report?
Any help or other suggestions are greatly appreciated.
From the Land of the New Prime Minister (Australia)
Cheers & Beers
Rat.