By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,998 Members | 2,825 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,998 IT Pros & Developers. It's quick & easy.

Eliminating Blank Rows In Reports

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: n/a
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

P: n/a
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.