469,649 Members | 1,301 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,649 developers. It's quick & easy.

Eliminating Blank Rows In Reports

I've been trying to look this up in Help but I've had no luck because
I don't know what to call it. (That's not phrased very well but I
think you get what I mean.)

I have a report that is working fine except for this format issue that
I can't figure out how to fix.

In my detail section, I have two lines for each item in my report.
The first line's fields always have data. Sometimes, the fields in
the second line are all NULL and the report just shows an empty line.

How can I get rid of the empty line when a line has no data?

Thanks.

Nov 13 '05 #1
2 2219
On Sun, 17 Jul 2005 03:22:50 GMT, New Guy wrote:
I've been trying to look this up in Help but I've had no luck because
I don't know what to call it. (That's not phrased very well but I
think you get what I mean.)

I have a report that is working fine except for this format issue that
I can't figure out how to fix.

In my detail section, I have two lines for each item in my report.
The first line's fields always have data. Sometimes, the fields in
the second line are all NULL and the report just shows an empty line.

How can I get rid of the empty line when a line has no data?

Thanks.


Set the CanShrink property of that control to Yes.
As long as there is no other control on that line, the next record
will move up. Also set the Detail CanShrink property to Yes.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
Nov 13 '05 #2
On Sun, 17 Jul 2005 03:22:50 GMT, New Guy wrote:
I've been trying to look this up in Help but I've had no luck because
I don't know what to call it. (That's not phrased very well but I
think you get what I mean.)

I have a report that is working fine except for this format issue that
I can't figure out how to fix.

In my detail section, I have two lines for each item in my report.
The first line's fields always have data. Sometimes, the fields in
the second line are all NULL and the report just shows an empty line.

How can I get rid of the empty line when a line has no data?

Thanks.


Set the CanShrink property of that control to Yes.
As long as there is no other control on that line, the next record
will move up. Also set the Detail CanShrink property to Yes.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

7 posts views Thread by Richard Yardley | last post: by
reply views Thread by New Guy | last post: by
3 posts views Thread by ShaeMills via AccessMonster.com | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.