Exclude item from a Report

[Box666]

I have a Report and within the "detail" area I have a field called
"Report Name". As you would expect it details all of the reports
captured from the underlying query. However there is one report named
"dummy" that i do not want to show in the report.

Can i do some sort of query or "IIf" statement to exclude it from the
report - i do not want to exclude it at the query stage as the dummy
line brings with it a full set of criteria for the report and if i
exclude it by query then the Report does not open (message "does not
recognise "X" as a valid field name.)

 

[Brendan Reynolds]

I have a Report and within the "detail" area I have a field called
"Report Name". As you would expect it details all of the reports
captured from the underlying query. However there is one report named
"dummy" that i do not want to show in the report.

Can i do some sort of query or "IIf" statement to exclude it from the
report - i do not want to exclude it at the query stage as the dummy
line brings with it a full set of criteria for the report and if i
exclude it by query then the Report does not open (message "does not
recognise "X" as a valid field name.)

You could change the control source property of the text box to an
expression such as ...

=IIf([Report Name] = "dummy", "", [Report Name])

 

[Ken Sheridan]

I don't really follow what you mean by "the dummy line brings with it a full
set of criteria for the report", but if you simply don't want that line to
show in the report put the following in the detail section's Format event
procedure:

Cancel = (Me.[Report Name] = "Dummy")

Ken Sheridan
Stafford, England