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

Drill Down Report Questions

edited September 2003 in Subreports
Is there a way to set a drill down report to expand all details as the
default setting, and still allow end-user to collapse individual master? I
notice that RB will not generate the outline tree structure for a drill
down report, so I am trying to find another way to show the report outline
for my drill down report. I am using RB7.03.

Thanks.

Comments

  • edited September 2003
    Hi,

    Drill down is not supported in the outline preview at this time. Here is an
    example of expand all with collapsing support. You'll have to code a little
    to adapt this example to work in your project, but it is possible to
    manipulate the expansions in code. I created a helper class, a key master,
    to manage some of this for you. The main form pulls the kep masters out as
    they are a one to one relationship with each subreport because I wanted to
    show that you can control this on a subreport by subreport level in code if
    you wanted to instead of just expanding every single subreport in the entire
    report. Notice there are a few extra lines of code in this example because
    the previewer adds a drop down so you can pick which subreport you want to
    drill down or collapse for all. Notice the page count changes for the new
    drill down action you take. This example should work for RB 7.01 and higher.
    Enjoy:)

    http://www.digital-metaphors.com/ttips/DrillDownExpandAllRB7.zip


    Cheers,

    Jim Bennett
    Digital Metaphors


  • edited September 2003
    I updated the demo to go to the first page after expanding all since the
    previous pages get expanded too and all the pagination changes. Perhaps the
    demo could be expanded to use the text search engine to find the OrderNo for
    the first record on the current page when the expand all button is clicked
    and then go to that page.


    Cheers,

    Jim Bennett
    Digital Metaphors


  • edited September 2003
    Thank you for the tip, it is very useful. Will this "expand all with
    collapsing support" function going to be packaged into RB as a standard
    feature? When I set CachePages to True, the drill down report will not
    work properly. Is there any work around way to solve this?
  • edited September 2003
    Hi,

    CachePages being true is not supported when using drill down, because the
    current and subsequent pages have to be regenerated and not pulled from the
    cache. Having a page cache doesn't make too much sense if you are going to
    rerequest all the pages when you drill down a subreport using this demo
    which generates a different number of pages with very different pagination.

    I can't say for sure if this can be made into a feature in RB in the next
    release. It has been asked for before a number of times by other customers
    in the past. Thankyou for the suggestion.

    Cheers,

    Jim Bennett
    Digital Metaphors


This discussion has been closed.