Hi,

I would like to use the sub-report functionality, to be able to go from one report to another one, but on a table with a different granularity, and this without using joins.

For instance, I have a report on orders, it displays all orders lines. Whenever hoovering on the order number, I would like to be able to go to the subreport displaying all invoice lines related to that order. But as an order line could be split into multiple invoice lines (because of a delivery split, or a credit note, or a proforma line, ...).

With the current situation, if I want this subreport link to work, I need to define the join between both tables, but in that case, the join is also active (even if not selected in the Join Preferences of the model) on the source report. Causing the orders report to be wrong, because of the link to all invoice lines... 1 order line linked to 2 invoice lines, the measure in the order report is then reflecting the number of invoice lines...

Is it an error in the Join preferences because of the subreport? or is it possible to use a subreport without join (but then how?)

Thanks !
Thomas

I think so, but I am trying a different combination I guess, as both report are NOT based on the same table.

Orders and Order details in NorthWind are based on the same table : Orders.