Bug 327253 - Sorting the x-axis in chart when using the optional y-series grouping.
Summary: Sorting the x-axis in chart when using the optional y-series grouping.
Status: NEW
Alias: None
Product: z_Archived
Classification: Eclipse Foundation
Component: BIRT (show other bugs)
Version: unspecified   Edit
Hardware: All All
: P3 enhancement with 7 votes (vote)
Target Milestone: ---   Edit
Assignee: Birt-Chart-inbox@eclipse.org CLA
QA Contact: Xiaoying Gu CLA
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-10-07 11:39 EDT by vaishali.shah CLA
Modified: 2015-02-22 21:19 EST (History)
5 users (show)

See Also:


Attachments
Contains the data file, report design file, some screenshots (1.02 MB, application/gzip)
2012-06-20 06:46 EDT, Ajit Tirumalasetti CLA
no flags Details

Note You need to log in before you can comment on or make changes to this bug.
Description vaishali.shah CLA 2010-10-07 11:39:29 EDT
Build Identifier: M20090211-1700

In any chart when you use an optional y-series grouping, you cant sort the x-axis.
The sorting on x-axis is grayed out - and it just lets you select the asc/dec order on the field used for x-axis.

I would like to sort the x-axis using a different field - when I am using y-series grouping.

Reproducible: Always
Comment 1 Ajit Tirumalasetti CLA 2012-06-20 06:42:33 EDT
Chart: XSeries (String) Sort greyed when YSeries Grouping is available

Using: Eclipse BIRT Version 4.2
This is related to an Xaxis (String) Sorting Issue (with Y-Series grouping).

Say we have the following data: 
- XAxisTitle:   Xaxis data represented as String 
- XAxisSort :   Order to display XAxisTitle 
- Total :       Some values for YAxis
- Category :    Y-Series Grouping


Requirement: 
        Items on Xaxis which are Strings (XAxisTitle), need to be sorted in a given order (XAxisSort). 

Issue: 
        When "Y-Series Grouping" is applied, the option to sort Xaxis is greyed out and not possible to provide XAxisSort in X-Series Sorting. This option should not be greyed.

P.S: Using MySQL data, for the ease of using.
- Please find the sample data in MySQl_data.txt
- Please use Test_sort.rptdesign file, modify your local MySql DB details
- SS01_noCat.png: Displays options without Y-Series Grouping (fine)
- SS02_Default.png: Displays greyed out Sort option when Y-Series Grouping is applied.
- SS03_ScriptModified.png: Displays when manually modifying the source file, as chart option is disabled (expected behaviour).
- SS_Output.png: Contains the output for all 3 chart types. Third one as expected, but only achieved when manually modified in the Source file "XML Source".


Please let me know if anything else is required.
Comment 2 Ajit Tirumalasetti CLA 2012-06-20 06:46:04 EDT
Created attachment 217618 [details]
Contains the data file, report design file, some screenshots

Contains mysql data file (1), report design file (1), some screenshots png files (4)
Comment 3 Debbie Massyn CLA 2015-02-22 21:19:10 EST
Hi Birt-Chart-inbox@eclipse.org team

Are you able to give any indication of where this sits in terms of your current priorities?  It really would solve so many headaches for us if we could use the sort when we use optional y-series groupings.  It would be good to know if we should rather look at implementing something else as we keep telling our users "it is a know BIRT bug" and they're not accepting that so readily anymore :)
Any news or update would be most useful for us.
Thank you and kind regards, Debbie.