subReports slow

rbuser

I have a master record in my header with line items in the detail. Within
this detail I have set up a subreport. All three utilise queries accessing
an Advantage database.

The problem is that the subreport query seems to be evaluated for each line
in the detail even when it is not being drilled down. It should only be
queried if I do a drill down on any particular line, instead, it is being
opened for each detail line on the page regardless especially as RB seems to
repaginate the whole page again.

Logically this is because the subreport query is in a master-detail
relationship with the detail query as it's master. So the question is how
can I get it to only evaluate if a drill down is opened?

digitalmetaphors

Yes, you can parameterize the detail query so that it only fires when the
subreport is drilled down as shown in this tip:

http://www.digital-metaphors.com/tips/DrillDownManualDetail.zip

Cheers,

Jim Bennett
Digital Metaphors

rbuser

Unfortunately I still have the same problem even taking your example and
transferring the tables to our own. We are using Advantage Database server.
The problem is that the report does not show anything but just sits with
blank output with the status bar showing 'Accessing Data'.

In designtime, I can see the output ( minus the subreport as it is using
the JIT ).

Is this a problem peculiar to Advantage?

digitalmetaphors

There is no known issue with RB 7 and ADvantage. We have many users using RB
with Advantage.

Make sure that the Subreport.Datapipeline is assigned.


Cheers,

Jim Bennett
Digital Metaphors