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: Records are not displayed in the order where actual query displays

sriram nagappan

Cross Tab: Records are not displayed in the order where actual query displays.
Ex. My query displays the records like field1,field2,field3,etc. but in cross tab it is displaying alphabetic wise.
can you pls advice.

Find more posts tagged with

Comments

kclark

Can you attach an example for us to look at? Also, have you tried using the sorting tab on the crosstab in the property editor to force sorting the way you'd like the results to be displayed?

sriram nagappan

Hi Clark,
 
Sorry, i am not supposed to show the actual report here. Anyway i am providing the example in the attachment. I have mentioned the order in which the results are displayed in cross tab and actual query.PFA and kindly advice.

JFreeman

Based on the sample screenshot, these looks like columns from the database as opposed to rows.
 
Can you build a sample report based on classic models or a sample flat file data source with dummy data that we can run? This will allow us to better understand exactly what you are wanting as the request is currently a bit unclear.

sriram nagappan

Hi, 
 
Please find the Birt output attached where the records are displayed in alphabetic order. But the actual query displays the records in different order. You can test by, Take a table which will have Name field and S.No. Write a query which display the Names in the S.No order (ascending). Then create a cross tab to display the names, you will notice the names displayed in alphabetic order, but whereas the actual query displays the names based on S.No. order (ascending). Help in a solution.

JFreeman

In order to sort by S.No instead of Name, you are going to have to include S.No into the cube for the crosstab in order for it to be available to be sorted on.
 
For example, add S.No to the group with Name as the parent of Name and then add both to the crosstab. This will allow you to sort based on S.No. Then you can hide the fields with S.No by Property Editor -> Advanced -> Section -> Display -> set display to "No Display".
 
Take a look at the attached sample report for reference. I have used the above method to sort the Customer Name based on Customer Number.

JFreeman

Here is an alternative method as well. You can add an attribute to the desired dimension and then you can sort based on the attribute in the sorting tab for the crosstab.
 
Take a look at this devshare: <a data-ipb='nomediaparse' href='http://developer.actuate.com/community/forum/index.php?/files/file/451-sorting-a-crosstab-by-a-field-not-in-the-crosstab/'>http://developer.actuate.com/community/forum/index.php?/files/file/451-sorting-a-crosstab-by-a-field-not-in-the-crosstab/</a>