Maine Posted August 15, 2014 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.
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