drilldown on single dataset

rbuser

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.

nardmoseley

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

rbuser

In the end up that is what I did.