<p><span style="color:rgb(36,39,41);font-family:Arial, 'Helvetica Neue', Helvetica, sans-serif;font-size:15px;font-style:normal;font-weight:normal;text-align:left;background-color:rgb(255,255,255);">I want different kind of groupings on "the same" data set. (</span>e.g. I want to use one data-set that in the first halve of the report is grouped on organisation.id and in the second halve is grouped on organisation.type).</p>
<p> </p>
<p><span style="color:rgb(36,39,41);font-family:Arial, 'Helvetica Neue', Helvetica, sans-serif;font-size:15px;font-style:normal;font-weight:normal;text-align:left;background-color:rgb(255,255,255);">The way I tried to solve it is with a parameter that determines the grouping statement in the query and by resetting the parameter with JavaScript statements at various points in the rptdesign. </span></p>
<p><span style="color:rgb(36,39,41);font-family:Arial, 'Helvetica Neue', Helvetica, sans-serif;font-size:15px;font-style:normal;font-weight:normal;text-align:left;background-color:rgb(255,255,255);">It feels a it hacky, but it works for tables, It does not however work for cross-tabs/data cubes; there seems to be some kind of caching.</span></p>
<p><span style="color:rgb(36,39,41);font-family:Arial, 'Helvetica Neue', Helvetica, sans-serif;font-size:15px;font-style:normal;font-weight:normal;text-align:left;background-color:rgb(255,255,255);">Is there anyway to recalculate a data cube midway a report? Or is there a better way to solve this problem? </span></p>
<p> </p>
<p><span style="color:rgb(36,39,41);font-family:Arial, 'Helvetica Neue', Helvetica, sans-serif;font-size:15px;font-style:normal;font-weight:normal;text-align:left;background-color:rgb(255,255,255);">N.b. I really don't want to use separate data sets</span></p>
