First Page is blank for first group

Hello,
I have a crystal report which has 2 groups(Facility(top) and Nursing Station(bottom))
I have the following condition on the 'New Page Before'  formula box :
NOT OnFirstRecord
 and the keep together is checked on both the groups.
The problem is the Facility group is putting a new page on the first page of each facility which is blank.
Iam using Crystal XI
Please help.
Star79Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mlmccCommented:
Which group has the new page before?

If it is the nursing station I would change it to NEW PAGE AFTER on the group footer

mlmcc
0
Star79Author Commented:
the top group facility has a blank page
0
mlmccCommented:
DO you get a NEW page before the first group (blank page 1)

Which group together is checked?
In the section expert or on the group change popup?

mlmcc
0
Fundamentals of JavaScript

Learn the fundamentals of the popular programming language JavaScript so that you can explore the realm of web development.

mlmccCommented:
After a little more thought, I suspect the issue is the KEEP TOGETHER on the Facility group.

The report does the new page and prints the page header then checks will the group fit on what is left on this page  and determines it won't so it does another new page then prints the group.

I suspect it doesn't realize it is on a blank (new) page already.  
Turn the KEEP TOGETHER off the for the Facility group.
The NEW PAGE BEFORE has already put it at the top of a page and it will either fit on the page or it won't but it won't do another NEW PAGE

mlmcc
0
Star79Author Commented:
the report allows multiple facility to be selected. So the first facility doesnt have a blank page.
The second and so on following facility has blank page first.
Both the section expert and the change group has keep together checked.
Tahnks.
0
Star79Author Commented:
Iam sorry MLMCC Iam a little confused .Let me explain how the report is when previewd and the settings

The report has 2 groups facility top and nursingstation bottom.
The user can select multiple facility.
The report has to page break on each facility and also page break on each nursing station within the facility.

All the above is happening except that for lets say the user selected 2 facilities.
The second fac is having a blank page first and then displaying the data.

The settings in the report are:
1) the keep together on both groups under the Change group option is checked
2)the keep together on both groups under the section exprt is unchecked
3)The NEW PAGE BEFORE on GH2 has the formula  NOT OnFirstRecord inside the X+2 box.

Thanks for your time.
0
mlmccCommented:
Uncheck the KEEP TOGETHER on the first group.

mlmcc
0
James0628Commented:
Just to make sure ...

 OnFirstRecord is only true for the very first record in the report, so it will only be true in the very first group headers in the report.  I think you may be thinking that it's referring to the first record in the group, but it's not.  It's the first record in the entire report.

 If you already knew that, then nevermind.  :-)  I just got the impression that you might be thinking that it was for groups.

 James
0
Star79Author Commented:
mlmcc, the keep together unchecking under the section expert or under the change group
did not help me to remove the blank page
0
mlmccCommented:
Can you upload the report file?

mlmcc
0
Star79Author Commented:
hello mlmcc,
I've uploaded the report file
MedicalRecordsCensus.rpt
0
mlmccCommented:
I made a few changes.  Without data it is difficult to know what will happen.

If that doesn't help could you save the report with data
Since this report has sensitive data, modify the report to show only the RecordNumber in the detail section. or you could even leave the detail section blank.  You can even take the counts out of the summary lines

mlmcc
MedicalRecordsCensus.rpt
0
Star79Author Commented:
Hello mlmcc,
I have saved the data.As you can see there is a blank page for Astoria park and then it shows the data
MedicalRecordsCensus-2-.rpt
0
mlmccCommented:
No data is saved.

There is an option to save it with data.  In the full versions it is under FILE

mlmcc
0
Star79Author Commented:
0
mlmccCommented:
Take the KEEP TOGETHER off group 2.  That is causing group to try to fit on a single page.

Right click the group header in the left margin
Click CHANGE GROUP
On tab 2 uncheck KEEP TOGETHER

mlmcc
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Star79Author Commented:
perfectly working
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.