Sort by month in cross tab

Hi,

I have a cross tab report whereby the column header is the name of the month. By default this is sorting alphabetically (april, august....september). If I add one more column on top which is month number (1..12), then it sorts fine but then I have an extra header. So want help in either solving this in another way or hiding the extra column header.

I am generating the .rptdesign through DEAPI and if the solution uses DEAPI, it will be great.

I can tweak the DEAPI through java code too..

Regards,

Mitul

Find more posts tagged with

Comments

mwilliams

Hi Mitul,

The best way to do this will be to use the numerical value for the month and then using mapping to replace the number with the month string.

Hope this helps.

mitul

Thanks a lot for the prompt reply. Can mapping be achieved through DEAPI? Any examples?

mwilliams

Mitul,<br />
<br />
This should at least help get you started with setting a map rule with the DE API:<br />
<br />
<a class='bbc_url' href='http://wiki.eclipse.org/Add_Map_Rule_in_beforeFactory_(BIRT)'>Add Map Rule in beforeFactory (BIRT - Eclipsepedia)</a>

mitul

Thanks again.

The link does not have any content. But that is OK. I solved the problem by inserting a "display:none" css style to that element.

mwilliams

Mitul,

Weird, I now see the same thing on that link. I copied the link straight from the browser. I'll try to find the page again and update the link.

Update: The link now works. There was a problem with the way the forum handled the perentheses.