on 05-30-2013 2:04 PM
Hi,
I have a requirement to show the Annual Pay for this year (current year) and the last year (Previous Pay) in two different columns. In Bex, I can do this by using offset variable (Current Calendar year -1) which brings two rows (one for the current year and one for the previous year. How do I pass this parameter to crystal report and show it in two different columns. Or is there any other way to achieve this functionality? Please let me know.
Thank You,
Madhavi.
Hello Madhavi,
in case BW is your source your would use the offset in the BEx query
regards
Ingo Hilgefort
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Yes Ingo. I have the offset variable which is a SAP exit variable (Current calendar year-1). When I execute the report (CR enterprise), it is summing two year rows and giving me the aggregated value where as I want values seperately for each year (if you look at the screen shot above). In Bex, it runs fine.
Thanks,
Madhavi.
User | Count |
---|---|
78 | |
10 | |
9 | |
7 | |
6 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.