how to set order by exp in crosstab?

[shivareddyk]

hi prof's,

 

how we can set order by exp in crosstab?

 

note:my report data  displaying alphabetical order,i want to custmize that order,help us any one?

 

Regards

[shivareddyk]

any idea to fix the above issue?

[brooneyx1]

For my case I have a list of names that I wanted odered in my own way. The way I got this to work was to add a coulumn called sort order to my table. The crosstab still sorted on name, so I pre-pended the sort order string to my sorted row in the query. My name now looks like "1-PartnerName", 4-PartnerName", etc.

In the query I used: 

        concat(concat(cast(c.display_order as char), '-'), c.name)  As PartnerName,

Now once I go to the crosstab element and change the expression to get rid of the starting int:

        $V{PartnerName}.substring($V{PartnerName}.indexOf("-")+1)

This gives me back the name in the order I decided on. If anyone has an easier way to do this I would love to hear about it.

[wichogg]

 Hi!!!

 

I have try your trick with the numbers but when i substring the parameter, my order got lost again, have anyone already solved this?

The query i made from my data base is in the order i desire, my problem is that the croostab re-order the data

[jrodri]

I have the same  issue

 

Please let me know if somebody have a fix for it case

 

 

Thanks

[wichogg]

 The problem for me was to get months in the right order, not alphabetic order, to solve this i got the number and name for each month, sort the crosstab by number and delete the display field from report.

If you can manage to set the right order in an additional field form your Data base query and then delete the display field you will solve your problem.

Hop this help you

[brooneyx1]

Did you try setting "Data is pre-sorted" in the crosstab data window ?

[jrodri]

I'm using ireport 3.7.6 and i can't see where is possible to set "Data is pre-sorted"

 

 

Do you know how can i to set it property for it version?

 

 

Thanks

 

[wichogg]

 Right click in your crosstab and select "crosstab Data" to select/deselect "data is presorted"

the problem with this option may be that your data will not look like matrix style.

[jrodri]

Gracias Luis ahora funciona bien gracias a tu ayuda

 

Un saludo

[marcelorauldiaz]

Muy buena solución.