Eclipse Community Forums: BIRT

Home » Archived » BIRT » (no subject)

Mon, 01 August 2011 05:55

Eclipse User

Hi All,

I am trying to generate a report in month wise,
But MONTH IS NOT IN PROPER ORDER IN CROSS TAB,

Its coming Alphabetical order by default,
How to order.

Plz help me on this,

Regards,
Jeyinul.

Re: MONTH IS NOT IN PROPER ORDER IN CROSS TAB [message #707396 is a reply to message #707161]

Mon, 01 August 2011 11:32

Eclipse User

I assume your month is not a date field. If it is a string, add a sort
expression to the crosstab with an expression similar to:

if( data["month"] == "Jan" ){
1;
}else if ( data["month"] == "Feb"){
2;
}else if ( data["month"] == "Mar"){
3;
}

Jason

On 8/1/2011 5:55 AM, jeyinul wrote:
> Hi All,
>
> I am trying to generate a report in month wise,
> But MONTH IS NOT IN PROPER ORDER IN CROSS TAB,
>
> Its coming Alphabetical order by default,
> How to order.
>
> Plz help me on this,
>
> Regards,
> Jeyinul.

Re: MONTH IS NOT IN PROPER ORDER IN CROSS TAB [message #707885 is a reply to message #707396]

Tue, 02 August 2011 03:22

Eclipse User

Hi Jason,

Its not working.

I added in Binding.

Field name is lookupcode. It has month names

I added

if(dimension["Group3"]["LOOKUP_2_Data Set4::LOOKUPCODE"] == "Jan" ){
1;
}

But its not working.

Please help me on this,

Thanks,
Jeyinul.

Re: MONTH IS NOT IN PROPER ORDER IN CROSS TAB [message #708017 is a reply to message #707396]

Tue, 02 August 2011 06:40

Eclipse User

Hi Jason,

Its a cross tab. Where i have to add the expression in cross tab.

Please give details and what time will come to online,.

Plz let me know.

Regards,
Jeyinul.

Re: MONTH IS NOT IN PROPER ORDER IN CROSS TAB [message #708210 is a reply to message #707885]

Tue, 02 August 2011 11:17

Eclipse User

You do not add a binding. Select the crosstab and in the properties
view click on the sorting tab and add it there. Take a look at the
attached example.

Jason

On 8/2/2011 3:22 AM, jeyinul wrote:
> Hi Jason,
>
> Its not working.
>
> I added in Binding.
>
> Field name is lookupcode. It has month names
>
> I added
>
> if(dimension["Group3"]["LOOKUP_2_Data Set4::LOOKUPCODE"] == "Jan" ){
> 1;
> }
>
> But its not working.
>
> Please help me on this,
>
> Thanks,
> Jeyinul.

Attachment: staticdim.zip
(Size: 2.13KB, Downloaded 189 times)

Re: MONTH IS NOT IN PROPER ORDER IN CROSS TAB [message #708705 is a reply to message #707396]

Wed, 03 August 2011 01:20

Eclipse User

This also not working.

Re: MONTH IS NOT IN PROPER ORDER IN CROSS TAB [message #708795 is a reply to message #708210]

Wed, 03 August 2011 03:20

Eclipse User

I checked your attached file. Its not in proper order.

Output is,

Feb 42
Jan 32
Mar 52

Plz help

Re: MONTH IS NOT IN PROPER ORDER IN CROSS TAB [message #709163 is a reply to message #708795]

Wed, 03 August 2011 11:15

Eclipse User

I am running this in 2.6.1 and it displays in the proper order.
I have added the running sum you asked for in the other thread and my
output looks like:

Jan 32
Feb 74
Mar 126

I have attached the report.
What version of BIRT are you using? I do not believe the sort will work
in 2.5.0 if that is what you are using. You will need to sort it on the
dataset instead of the crosstab.

Jason

On 8/3/2011 3:20 AM, jeyinul wrote:
> I checked your attached file. Its not in proper order.
>
>
> Output is,
>
> Feb 42
> Jan 32
> Mar 52
>
> Plz help

Attachment: staticdimwithrunningsum.zip
(Size: 2.27KB, Downloaded 199 times)

Previous Topic:	Parameter that decides wich table show
Next Topic:	Enabling study layout in JavaScript generated axes

Goto Forum:

-=] Back to Top [=-

Current Time: Wed Jul 23 11:54:25 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter