Mansoor Ahmad
Registered User.
- Local time
- Today, 07:30
- Joined
- Jan 20, 2003
- Messages
- 140
Dear All
On one of my reports I have got column charts based on a query. Report is also based on the same query. On the chart there is field ‘Faults’ on x-axis and ‘Qty’ on y-axis. The Qty field in underlying table is set to ‘1’ as default. So in chart it sums up Qty values.
At the moment chart is displaying Fault quantities in Fault ascending order. I want it to display ‘Faults’ (x-axis) columns in descending order of total Qty. I have tried to change sort order in Qty, and Fault fields in query but no effect.
Can somebody advise me where do I need to change the setting.
Thanks
On one of my reports I have got column charts based on a query. Report is also based on the same query. On the chart there is field ‘Faults’ on x-axis and ‘Qty’ on y-axis. The Qty field in underlying table is set to ‘1’ as default. So in chart it sums up Qty values.
At the moment chart is displaying Fault quantities in Fault ascending order. I want it to display ‘Faults’ (x-axis) columns in descending order of total Qty. I have tried to change sort order in Qty, and Fault fields in query but no effect.
Can somebody advise me where do I need to change the setting.
Thanks
