Maine Posted August 15, 2014 Share Posted August 15, 2014 Can you help me with this one please?I have a table on my report that has 2 groups.The query feeding this table is returning 8 records like this: money-type, volume1, volume2, rate1, volume3, volume4, rate2, percentageThe first and relevant (for my Q) group should help me calculate the sum of volume1 of all the records of the same money-type (USD or EUR or...) so I created a group "val_grp" in the dataset that is feeding this table with the group expression $F{valsrt} This should be very simple. However the variable that should calculate the sum (defined with Calculation: Sum, Reset type: Group, Reset group: val_grp, Increment type: None, Variable expression: $F{volume1}) does NOT calculate anything. It just returns the latest value of volume1.I have previoulsy built this report not using a table and this same way of crouping and calculating worked just fine. In this version, using a table, though..........it WILL NOT WORK!! Does anybody have a brilliant idea for me?? This is my first time using a table in ireport. Does grouping in tables work differently?Thanks in advance. Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now