Joined: 22 Aug 2011
Location: United States
Online Status: Offline
Posts: 51
Topic: subtotal within a group Posted: 13 Mar 2014 at 4:39am
My report contains Acct# which is grouped, ID# which is grouped then a Charge Amt which is summed on the amt of associated with the ID#. I have the data populating in group footer 2 but cannot get the tot field to do what I need it to do.
Joined: 22 Aug 2011
Location: United States
Online Status: Offline
Posts: 51
Posted: 13 Mar 2014 at 3:53pm
This is not resulting correctly when and acct number appears mor than once.
It is giving me..
Acct ID Charge Amt Tot
111 2000 120.00 120.00
111 9999 10.00 130.00
777 3000 400.00 400.00
888 1234 100.00 100.00
888 9999 10.00 10.00
When the account number is appearing more than once it should give the the total charge in on all the lines associated with the account number like this...
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Posted: 14 Mar 2014 at 3:42am
to get what you want you would have to use sub reports or do the calculations before you pull them into the report (like using a stored procedure as your data source).
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
