Cross tab month names and dates [message #1705383] |
Fri, 14 August 2015 12:45 |
Jeroen Bosch Messages: 2 Registered: August 2015 |
Junior Member |
|
|
Hi,
I'm building a report that has a date on the columns. Now the report shows the interger value of the month, day of the week and so on. I like to use the localized names for these. I hope you can help
I used a date group for de column dimension in the data cube.
In that date group I selected Month, Week of the year, Day of the week and day of the year.
The report shows the data how I like it:
I like to change the number 8 into 'august'
and also the weekdays into their short names 'mon' , 'tue', 'wed' etc...
and instead of the day in the year, I want the day of the month
So that it will actualy be deductable that the column represents monday 17th in week 38 in august.
Is this something that can be done in the crosstab or do I need to fix this in the query so the names are readily available (and just use the numbers so the order is correct and then use the additional fields as labels?
-
Attachment: date.png
(Size: 10.34KB, Downloaded 1540 times) -
Attachment: report.png
(Size: 7.55KB, Downloaded 1581 times)
|
|
|
Powered by
FUDForum. Page generated in 0.02989 seconds