EliseFreedman
Programmer
Hi There
I have a report which as well as containing its own data with its own total also contains a subreport with its own total. I would like to have a text box on the main report which basically is a grand total and sums up the two totals. However, when I try to do it, all I am getting for the result is #name.
the total on the main report(text27) is =Sum([SumOfexpr1])
the total on the subreport is =Sum([order_value]). This is contained within text39.
How do I display the grand total on the main report. I have tried
=[Reports]![orders_not_invoiced_by_JM]![Text39]+(Sum([order_value)) but the result is #name.
Any ideas?
I have a report which as well as containing its own data with its own total also contains a subreport with its own total. I would like to have a text box on the main report which basically is a grand total and sums up the two totals. However, when I try to do it, all I am getting for the result is #name.
the total on the main report(text27) is =Sum([SumOfexpr1])
the total on the subreport is =Sum([order_value]). This is contained within text39.
How do I display the grand total on the main report. I have tried
=[Reports]![orders_not_invoiced_by_JM]![Text39]+(Sum([order_value)) but the result is #name.
Any ideas?