Allow subquery joins on non-output columns
At present the join key between the master query and the subquery(ies) needs to be in the output columns, however we are finding many situations whereby the join key should not be in the output.
A simple example is that a date in the master query needs to be joined to a calendar. The output should be grouping by the week or month, however this is not possible because the date needs to be in the rows or columns field of the master query. Hence the output is grouped by the date and week/month as opposed to the week/month.
Essentially the join columns (ON CLAUSE fields) should not be enforced to be included in the output. When constructing the SQL statement in free-hand SQL this is possible but not via the ReportBuilder.
Could this be included in future releases or placed on the roadmap?