Jump to content

Recommended Posts

I have a report using many variables to calculate a rolling inventory over 16 months.  The users are requesting some difficult calculations in the rolling (or carryover) such as only carryover amounts > 0, but only for some categories(groups), and then add the carryover from one category to the carryover in another category.  I have most of the issues worked out, but I need to set a variable for the carryover ONLY when the group ="XXX", and maintain that variable value even when the group changes.  I can easily set the variable to change over categories (groups) $F{group1}=="XXX"?QTY_ON_HAND - QTY_ORDERED:0.0, but  when the group changes to "YYY" and then to "ZZZ" the value of the variable changes to 0.  I need to use the value of the varialble when it is in the "XXX" group as part of the calculation when it gets to group "ZZZ", but if it resets to 0 at that time, it is useless.

I have the Calculation set to "No Calculation", Increment and Reset types set to "None"

I am using Studio 5.5, but the same would apply to IReport Designer.

Thank you for your assistance.

Marlin Snyder


I have tried setting the Calculation Type to "First" and various settings on the Reset Type.  Group will set the value to 0.  None sets the value correctly, but it still changes with each group change.

Link to comment
Share on other sites

  • Replies 2
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...