nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Cross Tab sorting issues

AJax

Hi there.

I'm busy putting together a report with a number of different elements but the one thats giving me issues at the moment is the Cross Tab.

I'm populating a Cross Tab from a Data Cube based off a MySQL query.
The query works correctly and returns all data as the correct types and sorted as I require.

The Data Cube is correctly aggregating all Measures but when I populate the Cross Tab with the Measures they're being sorted into a weird order.

I've added a sort on the Date Grouping and yet it does not change the sort order.

I'm designing this report in the Eclipse BIRT Report Designer.

Can anyone provide any help with a potential cause for this?

I've attached a stripped down version of the report with just the Cross Tab.

If you need me to post some example data I can do that too.

Find more posts tagged with

Comments

kclark

Can you provide a screenshot please?

AJax

Here's a screenshot of the result and the sort config. 
 
<img src='http://i.imgur.com/w4AbzrE.jpg' alt='Posted Image' class='bbc_img' /> 
 
<img src='http://i.imgur.com/6baLHG9.jpg' alt='Posted Image' class='bbc_img' /> 
 
The Field is configured as a Date everywhere in the report.