Not Getting Sequence order when use 'Y' Optional Grouping [message #805097] |
Thu, 23 February 2012 10:27 |
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 166 times)
[Updated on: Thu, 23 February 2012 12: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 21:37 |
|
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
|
|
|
Powered by
FUDForum. Page generated in 0.02983 seconds