I am using Windows Server 2008 R2 Standard,iReport-4.8,
I have field which is dynamically filed with month names in crosstab,I tried with "data presorted" option in crosstab, ON as well as OFF.There is not effect on output. But months names are sorting alphabetically.
see highlighted square as in figure. How can I do it by Regular months sorting ?(jan,feb,march,april,may...so on)
Also I want to remore columns lines & make it single row ,without lines interfering (see 1st row with 1 number), so I removes all padding & borders of columns ,even though it shows below.(Indiacated by arrow)
Add an integer identifier like month in year from the query (like 1 for january,2 for february etc) to the column group of the cross tab and make the order "ascending" and make the group height to zero if you dont want to dispaly the field .Also move the group up accordingly..I hope this will help you...