How can I make a group not to show/display in a report if no data is under that group?

Hello,

I have this big report that summary a lot of data. Sometimes a group
need to be shown if that group has data on it otherwire I dont want to
show the group in the report. So, is there an option to not show the
group if no data is under a group?

Any ideas?

Thank You

erick-flores wrote:
I have this big report that summary a lot of data. Sometimes a group
need to be shown if that group has data on it otherwire I dont want to
show the group in the report. So, is there an option to not show the
group if no data is under a group?


Add a text box with the expression =Coount(*) to the group
header section. Then use each section's Format event to
check the text box and cancel the section:

Cancel = (thetextbox = 0)

--
Marsh
MVP [MS Access]

Marshall Barton wrote:
erick-flores wrote:
I have this big report that summary a lot of data. Sometimes a group
need to be shown if that group has data on it otherwire I dont want to
show the group in the report. So, is there an option to not show the
group if no data is under a group?


Add a text box with the expression =Coount(*) to the group
header section. Then use each section's Format event to
check the text box and cancel the section:

Cancel = (thetextbox = 0)

--
Marsh
MVP [MS Access]

Because I am grouping by different IDs I cant add another
field/expression to my grouping, can I?
I read you reply this to anoher person, and I already check for this
option

Any others suggestions?

erick-flores wrote:


Marshall Barton wrote:
erick-flores wrote:
I have this big report that summary a lot of data. Sometimes a group
need to be shown if that group has data on it otherwire I dont want to
show the group in the report. So, is there an option to not show the
group if no data is under a group?


Add a text box with the expression =Count(*) to the group
header section. Then use each section's Format event to
check the text box and cancel the section:

Cancel = (thetextbox = 0)


Because I am grouping by different IDs I cant add another
field/expression to my grouping, can I?
I read you reply this to anoher person, and I already check for this
option

Any others suggestions?


If it's not a report group, then I think you need to explain
what you mean by "group".

Another thought, how can there be data for the report when a
"group" has no data?

--
Marsh
MVP [MS Access]

Ok, let me explain you. Compressors, Stages, Cylinders, Comp. Valve,
Comp. Parts, Gaskets, Piston, Comp. Rod, Nuts and Piston Rings

Compressor has Stage(s) (always)
Stage(s) has Cylinder(s) (always)
Cylinder can have Comp. Valve, Gaskets or Piston
Comp. Valve can have Comp. Parts
Cylinder can has Gasket
Piston can have Comp. Rod or Nuts
Nuts can have Piston Rings

So this si kind of the idea. I want to see my report first. group by:
1. Compressor (cmp_id)
2. Stages (stg_id)
3. Cylinders (cyl_id)
4. and then all the other components from the cylinders.

What I am doing:
1st group cmp_id
2nd group stg_id
3rd group cyl_id
4th group Comp Valve
5th group Comp. Parts
..
..
..
So I was thinking if a Cylinder only has a Gasket then only display the
gasket group.

I think there should be a better way of doing this, but I dont know

Also when there is no data under a group, the others groups will not
work. So the hold report will display no data. It will only show the
group headers. How can I fix this? any ideas?

erick-flores wrote:

Ok, let me explain you. Compressors, Stages, Cylinders, Comp. Valve,
Comp. Parts, Gaskets, Piston, Comp. Rod, Nuts and Piston Rings

Compressor has Stage(s) (always)
Stage(s) has Cylinder(s) (always)
Cylinder can have Comp. Valve, Gaskets or Piston
Comp. Valve can have Comp. Parts
Cylinder can has Gasket
Piston can have Comp. Rod or Nuts
Nuts can have Piston Rings

So this si kind of the idea. I want to see my report first. group by:
1. Compressor (cmp_id)
2. Stages (stg_id)
3. Cylinders (cyl_id)
4. and then all the other components from the cylinders.

What I am doing:
1st group cmp_id
2nd group stg_id
3rd group cyl_id
4th group Comp Valve
5th group Comp. Parts
.
.
.
So I was thinking if a Cylinder only has a Gasket then only display the
gasket group.

I think there should be a better way of doing this, but I dont know


That seems like a good way to do it.

As far as I can tell from your description, I still think
you can use a text box named txtValveCount in the Valve
group's header section with the expression =Count(*)
Then the section can be suppressed by adding a line of code
to its Format event:
Cancel = (Me.txtValveCount = 0)
Repeat the same kind of thing in each group header.

If I am still misunderstanding what you are saying, please
post a Copy/Paste of the report's record source query along
with some explanation of how the fields are used in the
report.

--
Marsh
MVP [MS Access]