Making a report Fit on one Page

[Shiloh917]

How to get all on One Page
I have a report that I have grouped by OrderCode and totals for each order code. My information is correct but my report is putting 1 group on 1 page the next group on another page etc... How can I get it to print all on 1 page? I have tried taking out blank sections and it still doesn't work. I have 4 groupings in my report. ChargeCode, FacilityCode, WorkArea, and OrderCode So the report should look like this:

OrderCode #Pts #Perf ServDays Avg Days
LCBGP 20 10 253 5.9
OXCK 79 2047 664 8.4
OXISC 27 45 116 4.3

instead it is previewing to me 1 ordercode and it's information to a page so it is mostly a blank sheet. What can I do to make it all be on one page??

This is my record selection formula creteria:

{WORKAREA.WORKAREA} in ["VCH3","4NIA","4NIB","4NIC","4NID","4NIE","4NIF","4NIG","4NIH","4NII","4NI1","4NI2","4NI3","4NI4",
"4NI5","5PCU","6A","6B","6C","7A","7B","7C","8A","8B","8C","ADOL","D314","D333","CHLD","ED/P","PEND","DO21","D304","D301",
"D306","D023","J960","D329"] and {PATBILLING.ORDERCODE} in["ACACH","ACATA","AMDIS","AMDIV","COMCK","LABGP","OXCK","SVCPM","THIT"] and
Date({PATBILLING.BILLDATE}) in {?Report Start Date} to
{?Report End Date}

 

[kchaudhry]

You can try the following:

Right click on group header/footer (design view) > Format section > Highlight the group header/footer > Unselect new page after/before options.

This will not put the group on a new page.

Additionally you can also use the "keep together" option.

Hope this helps!

Kchaudhry

 

[Shiloh917]

I've already done that and it still won't change. These are canned reports that I am re-doing for my needs. Do you think that might be the problem?

 

[dgillz]

What if your group has 10,000 records, do you still want it on one page?

I do not believe you can do this in Crystal.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[lbass]

I would also check to make sure there are no conditional formulas in the x+2 areas for new page after or new page before, and that you don't have "Print at the bottom of the page" checked. You could also go to report->change group expert->select the WorkArea group->options and check "Keep group together." In the section expert, you should also have "Suppress blank section" checked for each section.

-LB