showing/hiding detail in reports

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

The query on which my report runs has two groupings: the top twenty five
vendors and all other vendors. I want to show the detail for the first tier
but only the summary level information for the other vendors. Is there a way
to do this?
 
The query that the report is based on assigns an "A" value to those above a
certain threshold amount and a "B" value to those below the threshold. The
threshold is entered by the user.
 
Bind the A or B value field to a control in the detail section of your
report.
Add code to the detail section On Format like
Cancel = Me.txtYourABControlName ="B"
 
When I tried that, I got the following error message:

"Compile error: Method or data member not found"

I received this error message when I typed both:
Cancel = Me.txtReportType = "B" and
Cancel = Me.ReportType = "B"

What did I mess up?
 
Do you have a field in your report's record source that is either A or B? If
so, add a text box to your detail section and set its name to txtReportType.
 
Back
Top