Drill Downs won't open

rbuser

I have several reports with drill-down subreports within them. They drill
down as expected when previewed from the designer. However, when I access
the report using a trsClientReport and RBServer they don't drill down. The
cursor changes on the drill-down field but the subreport refuses to open.

I'm using RB 7.01, "stock" built in viewer and have recompiled everything.
This was working great at one point and now it's not. I'm clueless where to
start looking since they work fine when previewed and I've rebuilt the
server to insure all the latest components.

Any ideas where I should look?

Thanks!

rbuser

I should add I'm using DADE linked queries in a classic master / detail
setup for the main / subreport.

digitalmetaphors

It is not natively supported. I have a demo which is almost ready to go to
show how to do this. If I have time today, I'll also show how to print to
report emulation text file using the server edition for a client windows
application. Both of these features require some coding to work within the
context of the server edition. Thanks for your patience.

Cheers,

Jim Bennett
Digital Metaphors

digitalmetaphors

Sorry, a true client server drilldown isn't going to be possible without at
least building on top of the next release of the Server Edition which will
support "Custom Parameters." The problem is that the subreport expansion key
must be set on the server side, and the report must be reset from the page
number. The the server side report uses the expansion key to generate the
subreport which should be expanded. The client also has to clear its page
cache from the same page number forward. Then the page must be rerequested
by the client and regenerated on the server. Custom parameters are going to
be needed. This is going to be a possibility after custom parameters are
supported. Drill down is on the ToDo list after custom parameters.

The drill down demo I was thinking of was simply client side only and was
basically a mini report engine that rearranged draw commands and pages to
support "client side drill downs." This really isn't a good solution, since
parameters are really the only way for this to work well without the client
needing a draw command rearranger engine.

Cheers,

Jim Bennett
Digital Metaphors

rbuser

That's unfortunate but I do appreciate your efforts. I'm hoping your
drill-down demo will closely follow the custom parameter release... :-)

Just a thought too - How about a viewer button in the server based demo to
manually Expand/Collapse all?

Thanks again, you guys are doing a great job! Great product. Even better
support...

Jon Gray

- - - - -