Oracle Database Express Edition (XE)

Hi,

1. For year: add in one dummy report year column go to column properties --> data format check overide default -> modify as you need and save (a button in left bottom) -> and select "system wide defaul for that column"...
2. For sorting month: in prompt on show section select "sql results" there you type

 select "Time - dim".Month from "Subject Area" order by "Time - dim"."Month code "

or

 select "Time - dim".Month from "Subject Area" order by "Time - dim".Year, "Time - dim"."Month Number"

Regards
Nicolae

Hi

I recommend to use first answers provided by Nicolas for your first question. So, that it'll effect through out the Answers whenever you are using that column

and, for your second question,. You can use the sql by nicolas. But everywhere you have to take care of this when using Month column

It;s better that you make this sort order change in rpd itself.

if you have yyyymm formatted column then okay, if not create it using extract functions.
Now, go to your month name column and double-click. Now in general tab, select sort order then select the above yyyymm format related column.

By doing this, whenever you use the Month column it'll be in sorting order.

But if you just select month without year column filtered out, you'll be getting repeated month values, for each year.