Hiding Group Levels by Criteria

[JonW]

I have a table set up as follows

A1 B1
A1 B1 C1
A1 B1 C2 D1
A1 B1 C2 D1 E1
A1 B2 C1
A1 B3
A2 B1
A2 B1 C2 D1
A2 B1 C2 D1 E2
A2 B2 C1
A2 B3

And would like to report it as

A1
B1
C1
D1
E1
B2
C1
B3
A2
B1
C1
D1
E1
B2
C1
B3

I've created a report with each of these fields as levels it prints out the
report fine except I get large gaps in the report where nothing is within a
field. How can I stop a level printing if nothing it is blank.

Tia

Jon

 

[Ofer]

I'm not sure it will work but you can try
For A create a header in sorting and grouping, put A field in it, put the
rest of the fields in the detail section, and put for each of the fields the
following
can shrink = true
hide duplicate = true

good luck

 

[Marshall Barton]

I have a table set up as follows

A1 B1
A1 B1 C1
A1 B1 C2 D1
A1 B1 C2 D1 E1
A1 B2 C1
A1 B3
A2 B1
A2 B1 C2 D1
A2 B1 C2 D1 E2
A2 B2 C1
A2 B3

And would like to report it as

A1
B1
C1
D1
E1
B2
C1
B3
A2
B1
C1
D1
E1
B2
C1
B3

I've created a report with each of these fields as levels it prints out the
report fine except I get large gaps in the report where nothing is within a
field. How can I stop a level printing if nothing it is blank.

I think all you need is to set each of the text boxes and
their section CanShrink to Yes.

 

[JonW]

I'd already set the headers to be able to shrink, and this isn't working.
I've done the same now on the text boxes and get the same.

 

[Ofer]

did you try what I suggested?

I'd already set the headers to be able to shrink, and this isn't working.
I've done the same now on the text boxes and get the same.

 

[Marshall Barton]

Do you have anything else in the sections? Any labels,
lines, or any blank space above or below the text boxes?

**Exactly** what is in the fields when they don't display
anything? Are they Null, ZLS (""), or could they have one
or more space characters??

 

[JonW]

I did try, and all it did was display 'A' with no other information.

 

[JonW]

I've tried this again by creating a new report to try ofers suggestion and
got it working but alas it prints in the identical format as I've currently
got through groups.

There are no Labels only the relevant text boxes there are no spaces between
the text boxes. The fields that don't display are empty I believe they are
ZLS ("").

Do you have anything else in the sections? Any labels,
lines, or any blank space above or below the text boxes?

**Exactly** what is in the fields when they don't display
anything? Are they Null, ZLS (""), or could they have one
or more space characters??
--
Marsh
MVP [MS Access]

I'd already set the headers to be able to shrink, and this isn't working.
I've done the same now on the text boxes and get the same.

 

[Marshall Barton]

Text boxes?? I thought there was only one text box per
section.

If there are two or more text boxes in a section, try an
experiment by separating them so that they are not quite
touching and make sure all of them have their CanShrink
property set to Yes.

If that's not it, then I guess I'm stumped. This is such a
simple situation that I just can't think of what else could
be getting in the way.

 

[JonW]

Thanks Guys,

I started it all again taking note of everything thats been said above and
its cracked the problem.

Jon

Text boxes?? I thought there was only one text box per
section.

If there are two or more text boxes in a section, try an
experiment by separating them so that they are not quite
touching and make sure all of them have their CanShrink
property set to Yes.

If that's not it, then I guess I'm stumped. This is such a
simple situation that I just can't think of what else could
be getting in the way.
--
Marsh
MVP [MS Access]

I've tried this again by creating a new report to try ofers suggestion and
got it working but alas it prints in the identical format as I've currently
got through groups.

There are no Labels only the relevant text boxes there are no spaces between
the text boxes. The fields that don't display are empty I believe they are
ZLS ("").

 

[Marshall Barton]

Thanks Guys,

I started it all again taking note of everything thats been said above and
its cracked the problem.

Jon

That's good to hear Jon. Thanks for closing this thread so
I can stop wondering what might be preventing it from
working.