Joined: 07 Mar 2011
Online Status: Offline
Posts: 7
Topic: Subtraction of data from different group footer Posted: 17 Jun 2011 at 5:22am
Hi,
I am using 3 groups in my report and in that one of the group i.e. the 3 rd group have a value that is calculated and in the 2nd group I want to subtract the 3rd group value from the field that is present in the 2nd group.
Eg:- the value of A=20 is in group footer 3 and
value of B=10 in group footer 2 and now i want the value of C i.e. C=B-A and the value of C should be in group footer 2.
Joined: 22 May 2009
Online Status: Offline
Posts: 347
Posted: 20 Jun 2011 at 2:13am
the only way I can see this working is for you to create a sub report that contains the Group 3 information that will produce your A value (20) and you will have to place it so it runs before group 2 group footer. You will then need to create a shared variable to pass that value from the sub report to the main report, where you will be able to display it in Group Footer 2.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
