Drill Down Reports

  • Thread starter Thread starter ricky
  • Start date Start date
R

ricky

Hi

Is it possible to create Drill-Down reports? Whereby the reports are
Grouped to show summary values, but can see the data behind those summarised
lines.

Kind Regards

Ricky
 
You cannot do stuff like clicking on a plus-sign on the report to open up
the details. However, you can simulate by toggling the Visible property of
the Detail section.

Typically you use a form to open the report.
On the form, place a check box with these properties:
Name: chkShowDetail
Default value: No
Save the form as (say) frmReport.

In the Open event of the report:

Private Sub Report_Open(Cancel As Integer)
Dim bShow As Boolean
If CurrentProject.AllForms("frmReport")
bShow = Nz(Forms("frmReport")!chkShowDetail.Value, False)
End If
Me.Sections(acDetail).Visible = bShow
End Sub
 
Back
Top