Drill Down Report Questions

rbuser

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.

digitalmetaphors

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

digitalmetaphors

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

rbuser

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?

digitalmetaphors

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