Skip to Content
author's profile photo Former Member
Former Member

How to pass offset variables to Crystal Enterprise

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.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    Posted on May 30, 2013 at 02:13 PM

    Hello Madhavi,

    in case BW is your source your would use the offset in the BEx query

    regards

    Ingo Hilgefort

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 30, 2013 at 02:00 PM

    Hi Madhavi,

    I don't know what offset variables are, but if you have data for both the years in rows, you can use a Crosstab object to achieve this.

    The column of the crosstab will be the Year/Date field and the Measure object will be the Summarize field.

    -Abhilash

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Abhilash,

      Thank you for the reply. For ex: When you set the offset variable in bex for "-1", if you prompt for 2013, it will bring 2013 and 2012 data in seperate rows.. Please see below.

      In Crystal report, it is passing the values but aggregating the 2012 and 2013 values and showing as one value (please see below). Can I use the 'max' and 'min' functionality in CR and seperate the values (write a formula) and show as current in one column and previous in another. If so, could you tell me how?as I am trying to use maximum and it is not working. I appreciate your time.

      Thanks,

      Madhavi.

      data.PNG (3.7 kB)
      Regular Pay.PNG (23.2 kB)

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.