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

mwilliams

Hi Mario,

We were using filters to do so, correct? Since you are using an SQL dataSet for your subreport, I believe, you should be able to create essentially these same statements in a where statement with dataSet parameters, then, in the binding tab for your subreport table, you can click on the "dataSet parameter binding" button and set your dataSet parameter bindings to the outer table from there. This way, the query is run for each subreport, but it only fetches the necessary data rather than all of the data and filtering it down each time to display the correct data.