Nested Report Summary Problem
Posted: Fri Jan 25, 2013 1:38 am
Hi,
I generated a nested groups report pretty similar to the one you have in the demo (NestedGroups.rtm).
It has Report Title - Grop Header 1 - Group Header 2 - Data - Group Footer 2 - Group Footer 1 - Report Summary
My data is coming from a Business Object.
Data is being grouped correctly with conditions.
First one is the day - and the second one is category.
I am suppose to have a Sub Total after Category Group and Day Total after day group.
So I have {Sum(Data,(MasterDS.UI_Price * MasterDS.Received_Qty))} on Group Footer Band 2 and
{Sum(Data,(MasterDS.UI_Price * MasterDS.Received_Qty))} on Group Footer Band 1.
Data and teh calculations are correct. The data is being grouped correctly.
The problem I have is this:
Sub Total and Day Total repeat after each Data line. they are suppose to show up at the end of the group.
Tried changing the order of Footer 1 and footer 2. Tried many other things. No dice.
Can you help?
Thanks,
I generated a nested groups report pretty similar to the one you have in the demo (NestedGroups.rtm).
It has Report Title - Grop Header 1 - Group Header 2 - Data - Group Footer 2 - Group Footer 1 - Report Summary
My data is coming from a Business Object.
Data is being grouped correctly with conditions.
First one is the day - and the second one is category.
I am suppose to have a Sub Total after Category Group and Day Total after day group.
So I have {Sum(Data,(MasterDS.UI_Price * MasterDS.Received_Qty))} on Group Footer Band 2 and
{Sum(Data,(MasterDS.UI_Price * MasterDS.Received_Qty))} on Group Footer Band 1.
Data and teh calculations are correct. The data is being grouped correctly.
The problem I have is this:
Sub Total and Day Total repeat after each Data line. they are suppose to show up at the end of the group.
Tried changing the order of Footer 1 and footer 2. Tried many other things. No dice.
Can you help?
Thanks,