<p>Hello,</p>
<p> </p>
<p>I'm currently working on a report where I have to present some data in a table, but I'm currently restricted to hide the detail row and use the last grouping as a replacement detail row. That is, I have to sum the details and present them in the grouping header. This is confusing so let me provide an example:</p>
<p> </p>
<p>My example data set:</p>
<pre class="_prettyXprint">
Vehicle type, Liters
Car, 100
Car, 150
Bus, 300
Bus, 500
</pre>
<p>
My table would then look like the following (sorry for the bad quality - I couldn't find a table tool in the editor):</p>
<pre class="_prettyXprint">
Vehicle type | Liters |
________________|_____________|
[ Vehicle type ]| SUM[Liters] | <-- Group header (Vehicle Type)
________________|_____________|
(detail row - | |
hidden) | [Liters] | <-- Detail row (hidden)
________________|_____________|
</pre>
<p>With this set-up I will get an extra hidden data sheet in my Excel output. I suspect it has to do with the "missing" [Liters] in the table. I have even tried adding the Liters to the bindings.</p>
<p> </p>
<p>I have attached a .rptdesign as a real example.</p>
<p> </p>
<p>Is it possible to somehow avoid the extra data sheet with this restricted set-up?</p>
