Home Subreports
New Blog Posts: Merging Reports - Part 1 and Part 2

Drill Downs won't open

edited January 2003 in Subreports
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!

Comments

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



  • edited January 2003
    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


  • edited January 2003
    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


  • edited January 2003
    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

    - - - - -

This discussion has been closed.