2 Test2 User1 103 2.34 1.23
104 3.14 3.7
The solution iseasy if everything is grouped, but the details at the cover(Cover ID, Cover Name etc..) are specific to each Cover not grouped. This is where its getting tricky.
I have created a sub report on Subcase, joining it with the History to compute the average time. But when I add this sub report in the Cover main report, the cover details are getting displayed duplicately for each of the sub case instance as shown below.
I'm not quite following your example. For CoverID 2, CoverName Test2, there is both a User1 value and a User2 value, but you want to display both as User1 in your target display at the top?
Assuming this is a typo, what you seem to be saying is that you have several Group By fields that can only have one value when you expand them, and so you do not want to display them with the expansion icon and subtotals at the subsidiary levels, nor do you want to display them without any expansion icons, where the values are repeated in each Group By column. Then the best I can suggest is in our custom Main report to display group headings with those Group By columns.