I have a report that will be placed as a sub report. The main report has two group levels, project id and work item.
I placed a further calculated total value got from a calculation from sub reports in the work item group footer.Then I placed this report under the
second group footer of the work item and linked it to the project id and work item since it needs value from the main report per work item.
But after displaying the main reports detail, it automatically displays the sub reports details. The way I wanted was after displaying all the details of the main report then goes to the sub report to display the details.
I tried placing the sub report under the project group footer and the format that I needed works well. This is done by linking only to the project id but it doesn't share the value for a specific work item.
How is the formatting accomplished?
This is the result that's displayed right after a single group from the main report is printed.