I have a report with a number of subreports. Each subreport has in its report footer a text box with a sum such as "Total=Sum([UnitPrice]*[Quantity])".
On the main report, under each subreport I have a text box like "Total1=[SubReport1].[Report].[Total]".
I want to create a pie chart on the report with all the totals (i.e. Total1, Total2, Total3...). How would I go about doing that? :(
On the main report, under each subreport I have a text box like "Total1=[SubReport1].[Report].[Total]".
I want to create a pie chart on the report with all the totals (i.e. Total1, Total2, Total3...). How would I go about doing that? :(