Methods to join Master-Sub-Report with Conditions

Mario1710

Hello!

In another Thread i asked how to join master-Sub-Reports with conditions.
Now i have a result. This is it:

Join Nr. 1:
{
if
(row._outer["FUNDSTRUCTTYPE"] != 4)
{
row["FUND_07_HB"] == row._outer["FUND_07_NB"] && row["ACCIK"] == 1
}
else
row["FUND"] == row._outer["FUND"] && row["ACCIK"] == 2
}



Join Nr. 2:
{
if
(row._outer["FUNDSTRUCTTYPE"] == 2)
{
row["GLACCREPFC7"] != 'BR_HN_FONDSZE' && row["GLACCREPFC7"] != 'BR_HB_FONDSZE'
}
else
true
}


The performance of this join is very bad.

Which other methods i can use to speed-up the performance of the report?

Maybe with scripting (i.e. onfetch)?
Maybe with different sql-statements, whcih were selected by the condition?

Regards,
Mario