on 07-13-2012 9:01 AM
Hi all,
I have a report , when i execute the report it will prompt for year , let say i gave 2009 , so the report output should be on 2007 years like the report output should be based on prompt year - 2 .
Hope u got my questions...
Regards,
RaviChandra
This must be done on universe level: In the business layer create a filter with following where expression:
table.column = @prompt('Year:','A',,,,) - 2
This is old syntax which can be used even in unviverse design tool. IDT provides an easier way to create prompts
Offset can be prompted as well. Then it is:
table.column = @prompt('Year:','N',,,,) + @prompt(Offset:','N',,,,)
but this normally is used only if you replace the first prompt with something calculated like for example the current year.
and @prompt can have a default value which will then be -2.
Please refer to Universe Desing tool or Information Design Tool guide for complete reference of @prompt syntax on http://help.sap.com/boall_en
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 | |
24 | |
12 | |
9 | |
7 | |
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.