on 08-14-2008 12:44 PM
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?
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.