nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Sort by subreport aggregation

ovis

Hi, How can i sort master report by aggregation which is contained in subreport?

Find more posts tagged with

Comments

micajblock

You can't (at least not easily). Is there a reason why the master and sub-reports are not using the same data set? That way all the bindings can be done in a single data set. If it is not possible have a data set that is just the aggregation and use a joined data set to join to the master report data set, then you can sot on the aggregation.

ovis

The main reason is that SQL query is very complex and JDBC driver gives me errors like "Request Too Large". Another reason Subjob1 and Subjob2 has completely different(in rows count and data context) datasets. So my solution is to split SQL query for Subjob1 and Subjob2. Any suggestions on "not easily" way? I am comfortable with programming and other stuf

micajblock

<blockquote class="ipsBlockquote" data-author="ovis" data-cid="127566" data-time="1398347833"><div>Any suggestions on "not easily" way? I am comfortable with programming and other stuf</div></blockquote>What is wrong with my joined data set suggestion? As far as other ways go I have not put a lot of thought to it, but bottom line is that the master data set needs to have the aggregation bound to it in order to sort. So you can have an additional query put the rows in a hash map then then when the data set is being used you can use the hash map to create an additional binding.