Master-detail reports and selections

[gordonf]

I've a master-detail report which runs very slowly.

Teh master report has a selection criterion (basically table1.primarykey in a list of values). The list of values for the selection is found in a report variable.

I cannot see how to pass the report variable to the detail reports, in order to perform the same selection. Therefore the three detail reports each have to read a huge table (1.5M records) to find the handful of records (maybe 20) that are relevant.

I've managed to pass the master-report variable as a derived field to the detail reports, but that doesn't help as you can't write a selection on a derived field.

Any thoughts?

 

[ainkca]

Basically, the master and detail section don't 'talk' to each other.

Try adding the table rptsel(Report Selection) to both the master and detail reports.(Select all fields in the table)

Then you can link using the ids. I remember it taking me months to figure that out, and I didn't get a whole lot of help from Support.

Hope this helps, I know this was posted more than a year ago so probably you already got your solution.

Regards, ainkca