Record sorting in Cross tab

[former_member309127]

Hi,

I have a cross tab in a group header.

I want to sort cross tab according to the third row.

How to achieve this?

For example, the attached image.

I want to sort the cross tab as per Part 3

I have added Part 3 in rows section of cross tab and I also have a sorting ID for Part 3 in my SQL query.

I am grouping the Cross tab with Engine Names ID.

logbook.jpg

[ido_millet]

Make Part 3 the first element in the CrossTab rows.

[former_member309127]

But I do not want to display the Part 3 element as first. I just want cross tab to be sorted by Part 3.