cancel
Showing results for 
Search instead for 
Did you mean: 

Display month in the column

Former Member
0 Kudos

hello...i have a report that actually need a layout of displaying the month in the column. the format as below:

last month new loan (09.2008), this month new loan (10.2008), the month here will change based on the user input of the current month and the report will auto display out the month as above. is there any way that we can do this??? do i need to create another variable for this?

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hello,

you have to create a new variable for e.g. 0calmonth. This variable can be used in your keyfigures.

The variable can be filled with actual month. To get the last month data you can use the OFFSET function (-1 last month) in Query Designer.

Regards,

Markus

Former Member
0 Kudos

yeah...i created a variable with the offset 1, and i want to display the month directly like 08.2008 in the coloumn, coz currently i assign like (new loan (last month)...like this...

former_member189638
Active Contributor
0 Kudos

Is that you want to display 08.2008 in the column header???

Then you need to make use of the Text variable in the description.