Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » 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 Go to next message
pravin gate is currently offline pravin gate
Messages: 4
Registered: January 2012
Junior Member
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 87 times)

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

Report message to a 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 Go to previous message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

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:
  


Current Time: Thu Jul 31 11:51:29 EDT 2014

Powered by FUDForum. Page generated in 0.01842 seconds