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

drilldown on single dataset

edited January 2007 in Subreports
I have a query result set that is grouped. What I want is to use this in a
sub report where initially I only see the sum or count of some field values
according to the grouped fields (i.e. a summary view). Then I want the user
to be able to click on a hot link on one of the summary fields so that it
will drill down to the line detail. But Setting a group on the report and
using a dbcalc I can get the summary view of totals in the group heading
section. however I cannot get a drilldown in the detail as I can't link a
subreport to a drilldowncomponent in the group section.

Is there any way of doing this using the same dataset ( summary total with
optional drilldown to all the records ) or do I need to provide two
datasetd, a master report with a summary query reuslt and link the detail
result set in the drilldown where the master totals can be placed in the
report detail band?

All I want to do is show only the group totals for the dataset in summary
form but allow a drilldown to the actual records with only a single dataset.

Comments

  • edited January 2007

    You need a master/detail setup. Try creating a summary query that can
    display the summary amount in the detail band. As you describe, the
    limitation is that the clickable link needs to be in the same band as the
    drill down subreport.


    --
    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
  • edited January 2007
    In the end up that is what I did.

This discussion has been closed.