Suppress Report Footer Subtotals if Criteria Not Met

  • Thread starter Thread starter Karl Burrows
  • Start date Start date
K

Karl Burrows

I have a report that includes a footer for subtotals for our HOA for
"villages" in our neighborhood, but some of the homes do not belong to a
specific village, so I get subtotals for village for this group of homes
that is just blank for village name, but still shows totals that are
meaningless, so I would like to be able to hide the subtotal footer for
groups of homes that do not meet this criteria, but keep it for homes that
do in the same report.

Thanks!
 
Actually, if it could hide the entire report grouping, that would be even
better.

I have a report that includes a footer for subtotals for our HOA for
"villages" in our neighborhood, but some of the homes do not belong to a
specific village, so I get subtotals for village for this group of homes
that is just blank for village name, but still shows totals that are
meaningless, so I would like to be able to hide the subtotal footer for
groups of homes that do not meet this criteria, but keep it for homes that
do in the same report.

Thanks!
 
Are we supposed to understand you data and what determines if a home belongs
to a specific village? Could you provide some information that would allow
us to more than guess at an answer? Maybe if we had some sample records and
a note whether or not they would be include and why or why not.
 
Usually a field called village would define a grouping of homes in a village
[ :) ]

There is a field called village that is used to define whether a home
belongs in a village. If not, there is no value there (the management
company will not let us use "None" since they combine our report with other
neighborhood HOA's). The table includes normal home owner stuff including:

OwnerName
StreetAddress
Village
City
State
ZIP
PurchaseDate

There are reports like payment history where the neighborhood is grouped by
villages with monthly, yearly and grand totals. It is grouped by village
because dues can vary depending amenities in the village. Homes not in
villages are then lumped in together at the end of the report.

The problem is the homes not in a village still show grouped as a village
with a village group footer showing totals with a blank village designation.
I would like to have the report just show this as a blank versus showing a
village total, which it is not.

Thanks!

Are we supposed to understand you data and what determines if a home belongs
to a specific village? Could you provide some information that would allow
us to more than guess at an answer? Maybe if we had some sample records and
a note whether or not they would be include and why or why not.
 
You should be able to add code to the On Format event of your group footer
section like:
Cancel = IsNull(Me.txtVillage)

--
Duane Hookom
MS Access MVP


Karl Burrows said:
Usually a field called village would define a grouping of homes in a
village
[ :) ]

There is a field called village that is used to define whether a home
belongs in a village. If not, there is no value there (the management
company will not let us use "None" since they combine our report with
other
neighborhood HOA's). The table includes normal home owner stuff
including:

OwnerName
StreetAddress
Village
City
State
ZIP
PurchaseDate

There are reports like payment history where the neighborhood is grouped
by
villages with monthly, yearly and grand totals. It is grouped by village
because dues can vary depending amenities in the village. Homes not in
villages are then lumped in together at the end of the report.

The problem is the homes not in a village still show grouped as a village
with a village group footer showing totals with a blank village
designation.
I would like to have the report just show this as a blank versus showing a
village total, which it is not.

Thanks!

Are we supposed to understand you data and what determines if a home
belongs
to a specific village? Could you provide some information that would allow
us to more than guess at an answer? Maybe if we had some sample records
and
a note whether or not they would be include and why or why not.

--
Duane Hookom
MS Access MVP
--

Karl Burrows said:
I have a report that includes a footer for subtotals for our HOA for
"villages" in our neighborhood, but some of the homes do not belong to a
specific village, so I get subtotals for village for this group of homes
that is just blank for village name, but still shows totals that are
meaningless, so I would like to be able to hide the subtotal footer for
groups of homes that do not meet this criteria, but keep it for homes
that
do in the same report.

Thanks!
Click to expand...
Click to expand...
 
Says it "can't find the Macro 'Cancel=IsNull(Me.' " when I try to run it.

You should be able to add code to the On Format event of your group footer
section like:
Cancel = IsNull(Me.txtVillage)

--
Duane Hookom
MS Access MVP


Karl Burrows said:
Usually a field called village would define a grouping of homes in a
village
[ :) ]

There is a field called village that is used to define whether a home
belongs in a village. If not, there is no value there (the management
company will not let us use "None" since they combine our report with
other
neighborhood HOA's). The table includes normal home owner stuff
including:

OwnerName
StreetAddress
Village
City
State
ZIP
PurchaseDate

There are reports like payment history where the neighborhood is grouped
by
villages with monthly, yearly and grand totals. It is grouped by village
because dues can vary depending amenities in the village. Homes not in
villages are then lumped in together at the end of the report.

The problem is the homes not in a village still show grouped as a village
with a village group footer showing totals with a blank village
designation.
I would like to have the report just show this as a blank versus showing a
village total, which it is not.

Thanks!

Are we supposed to understand you data and what determines if a home
belongs
to a specific village? Could you provide some information that would allow
us to more than guess at an answer? Maybe if we had some sample records
and
a note whether or not they would be include and why or why not.

--
Duane Hookom
MS Access MVP
--

Karl Burrows said:
I have a report that includes a footer for subtotals for our HOA for
"villages" in our neighborhood, but some of the homes do not belong to a
specific village, so I get subtotals for village for this group of homes
that is just blank for village name, but still shows totals that are
meaningless, so I would like to be able to hide the subtotal footer for
groups of homes that do not meet this criteria, but keep it for homes
that
do in the same report.

Thanks!
Click to expand...
Click to expand...
 
You need to open the Event Procedure and paste the code into the Module, not
the property.

--
Duane Hookom
MS Access MVP


Karl Burrows said:
Says it "can't find the Macro 'Cancel=IsNull(Me.' " when I try to run it.

You should be able to add code to the On Format event of your group footer
section like:
Cancel = IsNull(Me.txtVillage)

--
Duane Hookom
MS Access MVP


Karl Burrows said:
Usually a field called village would define a grouping of homes in a
village
[ :) ]

There is a field called village that is used to define whether a home
belongs in a village. If not, there is no value there (the management
company will not let us use "None" since they combine our report with
other
neighborhood HOA's). The table includes normal home owner stuff
including:

OwnerName
StreetAddress
Village
City
State
ZIP
PurchaseDate

There are reports like payment history where the neighborhood is grouped
by
villages with monthly, yearly and grand totals. It is grouped by village
because dues can vary depending amenities in the village. Homes not in
villages are then lumped in together at the end of the report.

The problem is the homes not in a village still show grouped as a village
with a village group footer showing totals with a blank village
designation.
I would like to have the report just show this as a blank versus showing
a
village total, which it is not.

Thanks!

Are we supposed to understand you data and what determines if a home
belongs
to a specific village? Could you provide some information that would
allow
us to more than guess at an answer? Maybe if we had some sample records
and
a note whether or not they would be include and why or why not.

--
Duane Hookom
MS Access MVP
--

Karl Burrows said:
I have a report that includes a footer for subtotals for our HOA for
"villages" in our neighborhood, but some of the homes do not belong to a
specific village, so I get subtotals for village for this group of homes
that is just blank for village name, but still shows totals that are
meaningless, so I would like to be able to hide the subtotal footer for
groups of homes that do not meet this criteria, but keep it for homes
that
do in the same report.

Thanks!
Click to expand...
Click to expand...
Click to expand...
 
Thanks!

You need to open the Event Procedure and paste the code into the Module, not
the property.

--
Duane Hookom
MS Access MVP


Karl Burrows said:
Says it "can't find the Macro 'Cancel=IsNull(Me.' " when I try to run it.

You should be able to add code to the On Format event of your group footer
section like:
Cancel = IsNull(Me.txtVillage)

--
Duane Hookom
MS Access MVP


Karl Burrows said:
Usually a field called village would define a grouping of homes in a
village
[ :) ]

There is a field called village that is used to define whether a home
belongs in a village. If not, there is no value there (the management
company will not let us use "None" since they combine our report with
other
neighborhood HOA's). The table includes normal home owner stuff
including:

OwnerName
StreetAddress
Village
City
State
ZIP
PurchaseDate

There are reports like payment history where the neighborhood is grouped
by
villages with monthly, yearly and grand totals. It is grouped by village
because dues can vary depending amenities in the village. Homes not in
villages are then lumped in together at the end of the report.

The problem is the homes not in a village still show grouped as a village
with a village group footer showing totals with a blank village
designation.
I would like to have the report just show this as a blank versus showing
a
village total, which it is not.

Thanks!

Are we supposed to understand you data and what determines if a home
belongs
to a specific village? Could you provide some information that would
allow
us to more than guess at an answer? Maybe if we had some sample records
and
a note whether or not they would be include and why or why not.

--
Duane Hookom
MS Access MVP
--

Karl Burrows said:
I have a report that includes a footer for subtotals for our HOA for
"villages" in our neighborhood, but some of the homes do not belong to a
specific village, so I get subtotals for village for this group of homes
that is just blank for village name, but still shows totals that are
meaningless, so I would like to be able to hide the subtotal footer for
groups of homes that do not meet this criteria, but keep it for homes
that
do in the same report.

Thanks!
Click to expand...
Click to expand...
Click to expand...
 
Back
Top