G
Guest
I have an existing report that gives me a total by month per item and a total
by region at the end of each different region. I am trying to add a
subreport to the beginning of this report that shows just the total for each
region(9 total). I put the subreport in the Report Header of the existing
report and have the region total in the Region Footer of the subreport and
the Grand Total of all the regions in the Report Footer of the subreport.
When I run this report, only the first region from the list(is first
alphabetically) appears and the Grand Total is only for that region as well.
When in the design mode of this report, I right clicked the subreport and
selected "Subreport in New Window" and viewed the subreport in this new
window and it appears with all 9 regions and the correct Grand Totals. It's
as if when I run the report that I added this subreport to, it is only
picking the first region from the list and not the rest.
by region at the end of each different region. I am trying to add a
subreport to the beginning of this report that shows just the total for each
region(9 total). I put the subreport in the Report Header of the existing
report and have the region total in the Region Footer of the subreport and
the Grand Total of all the regions in the Report Footer of the subreport.
When I run this report, only the first region from the list(is first
alphabetically) appears and the Grand Total is only for that region as well.
When in the design mode of this report, I right clicked the subreport and
selected "Subreport in New Window" and viewed the subreport in this new
window and it appears with all 9 regions and the correct Grand Totals. It's
as if when I run the report that I added this subreport to, it is only
picking the first region from the list and not the rest.