X-axis data value sorting on stacked bar chart graph not fully working
Posted 03 April 2012 - 09:08 PM
I am using BIRT version 2.5.0 coupled with Troux version 9.0. Due to the coupling I am therefore unable to upgrade to the latest version of BIRT.
I have a report with a data set that is ordered by Column D, in a descending fashion. I wish to display Column A's contents in the order ordered by Column D.
Example: SELECT name, city, pc_count, visit_count FROM tableA ORDER BY DESC visit_count
Data set returns the information as expected ordered by visit_count.
I have linked this data set to a stacked bar chart.
The x-axis of the bar chart displays Column A's (name) contents. As mentioned before, I wish this ordered in the order set by Column D (visit_count) of the data set.
The y-axis of the bar chart displays Column B's (city) contents.
And the optional Y series grouping is linked to Column C's (pc_count) contents.
My colleague and I was attemping to sort the x-axis information according to the sort order of the data set, as ordered by Column D of the data set.
We couldn't achieve this result, but in the process, we discovered the following:
1. If I remove the optional Y series grouping, the GUI then allows us to set the sort order for the X Series to the field wanted (visit_count), then the x-axis is properly sorted the way we want. But obviously the chart doesn't show the optional Y series grouping, which we want as well.
2. Adding the optional Y Grouping back in, greys out the ability to set the sort order for the X Series, and the X Series reverts back to be sorted by Column A (name).
The Help screen indicates that if no sort order is selected then the fields would be displayed in the order returned by the query. This unfortunately does not seem to be the case if the Optional Y grouping is selected.
Neither 1 or 2 is exactly what my colleague and I want.
Is there a way to have the graph sorted in the way we want and also have the optional Y series grouping in place as well?
Is ths a known bug? Is it fixed in a later verison of BIRT?
Posted 05 April 2012 - 11:38 AM
Posted 09 April 2012 - 05:17 PM
Please see the 2 picture attachments.
Please note the filenames on both files too. They have useful descriptions on them that describe what the bar chart currently is like.
Basically, what my team and I want is "sorted and has optional Y series in the bar graph".
Is this possible?
Posted 10 April 2012 - 10:06 AM
Posted 10 April 2012 - 03:08 PM
I find it easier to understand with an example, as most people do I believe.
Could you please make an example?
Posted 09 May 2012 - 08:12 AM
Number of downloads: 21
Posted 14 May 2012 - 05:19 PM
Thanks for this Michael. I am getting 90% of it at the moment.
I just need to learn what the script does.
Can you please point me to a good BIRT scripting API documentation? I have the following, but it doesn't help much:
Posted 17 May 2012 - 07:17 AM