Eclipse Community Forums: BIRT » Not Getting Sequence order when use 'Y' Optional Grouping

Home » Archived » BIRT » Not Getting Sequence order when use 'Y' Optional Grouping

Not Getting Sequence order when use 'Y' Optional Grouping [message #805097]

Thu, 23 February 2012 05:27

Eclipse User

I am creating one report in which I am displaying month-wise report.

I want to display report in month-wise sequence means First Jan12 then Dec 11 then Nov 11 and so on. or either way i.e First show Nov11, then Dec11 and then Jan12

I have written a query to get this desired output and output of my query shows me month in Descending order which is right,

But when I go to use Optional 'Y' grouping In birt I am not able to get that sequence

I am adding images for your reference which I am getting it, which is not in Descending order .

What should I need to do in birt to achieve i correct month sequence order ?
Or Birt Month is being sorted by BIRT in alphabetical order, which suggests that the Month field is alphanumeric rather than date

Any suggestion will helpful

Attachment: Month.png
(Size: 11.82KB, Downloaded 183 times)

[Updated on: Thu, 23 February 2012 07:10] by Moderator

Re: Not Getting Sequence order when use 'Y' Optional Grouping [message #805525 is a reply to message #805097]

Thu, 23 February 2012 16:37

Eclipse User

Can you post the design?

Jason

On 2/23/2012 5:27 AM, pravin gate wrote:
> I am creating one report in which I am displaying month-wise report.
>
> I want to display report in month-wise sequence means First Jan12 then Dec 11 then Nov 11 and so on.
>
> I have written a query to get this desired output and output of my query shows me month in Descending order which is right,
>
> But when I go to use Optional 'Y' grouping In birt I am not able to get that sequence
>
> I am adding images for your reference which I am getting it, which is not in Descending order .
>
>
> What should I need to do in birt to achieve i correct month sequence order ?
> Or Birt Month is being sorted by BIRT in alphabetical order, which suggests that the Month field is alphanumeric rather than date
>
>
> Any suggestion will helpful

Previous Topic:	[solved] NullPointerException Platform.getOS( ) in Standalone App
Next Topic:	Dynamic Parameter with Scripted Data Set

Goto Forum:

-=] Back to Top [=-

Current Time: Fri Jul 25 01:47:42 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter