Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Why a blank record? Post Reply Post New Topic
Author Message
CorwinW
Newbie
Newbie
Avatar

Joined: 10 Jun 2013
Location: Canada
Online Status: Offline
Posts: 3
Quote CorwinW Replybullet Topic: Why a blank record?
    Posted: 11 Jun 2013 at 2:42am
Hello Everyone!

I am new to the forum idea, but I have been a "so so" Crystal Report Writer for about 5 years.

I am creating a report that is creating labels based on the quantity field of the main report.

I created an Excel spreadsheet with one column with numbers 1 through 500. I added the spreadsheet to my OE_Details report with an equal share.
Then I created the Variables to get the Part Number and customer Part Number on the subreport and everything seems to be working well.

There is a small issue with the fact that every time there is a new part number, it starts on a new page. This will ultimately waste many labels.

I do have several questions:
1) Why is there a "blank" page at the beginning of the report?
2) Is it possible to remove it?
3) Is there a way to "join" all of the separate part number pages together?

I hope this isn't too confusing.

Thanking you all in advance,

Corwin
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 11 Jun 2013 at 5:40am
I am guessing that the part number group has checked the option 'New Page Before' in the section expert...all the symptoms are explained by that, so the first thing I would try is Unchecking this option, if it's checked.

If that isn't the case let us know, and we'll see what else we can think of.

HTH
IP IP Logged
CorwinW
Newbie
Newbie
Avatar

Joined: 10 Jun 2013
Location: Canada
Online Status: Offline
Posts: 3
Quote CorwinW Replybullet Posted: 19 Jun 2013 at 5:44am
Okay, I've checked into this and there is no selection for New Page Before or New Page After.

Now what?

Edited by CorwinW - 19 Jun 2013 at 5:44am
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 19 Jun 2013 at 6:05am
in your group set up do you have 'keep group together' marked as true?
IP IP Logged
Sastry
Moderator
Moderator
Avatar

Joined: 16 Jul 2012
Online Status: Offline
Posts: 537
Quote Sastry Replybullet Posted: 19 Jun 2013 at 6:35am
Hi

This is just because of your sub report, do the following :

Right click on sub report -- go in format sub report -common tab--uncheck 'Keep Object Together'
Thanks,
Sastry
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.