here is the ordeal. I have a subreport that I pull a total of invoices from and place that into my group footer and use the formula:
=IIf([rpt_invo_bkup_lbr_sub].[Report].[HasData]=-1,[rpt_invo_bkup_lbr_sub].[Report]![lbr_csh_ttl],0)
to attain this total. This works swimmingly until I do what I need to do with this. What I need to do is to create another text box that refers back that total and create a running sum over the group.
When I do this however the function isn't reliable. It works for some records but not all. For the ones that it does not work for it only pulls the value for the first invoice and does not pull the total value of all of the invoices. Please let me know if you can help.
Thank you in advance!
=IIf([rpt_invo_bkup_lbr_sub].[Report].[HasData]=-1,[rpt_invo_bkup_lbr_sub].[Report]![lbr_csh_ttl],0)
to attain this total. This works swimmingly until I do what I need to do with this. What I need to do is to create another text box that refers back that total and create a running sum over the group.
When I do this however the function isn't reliable. It works for some records but not all. For the ones that it does not work for it only pulls the value for the first invoice and does not pull the total value of all of the invoices. Please let me know if you can help.
Thank you in advance!
