asked on

Getting Error: The Page size was not large enough to format the contents of an object in the report.

Crystal Report v9

I have a subreport that needs to be printed on the first page (but below a header that is on every page). The subreport, at times, has MANY rows in it and spans more than one page. I get this error when this happens.

Any suggestions?

Current Setup
Report Header (Blank)
Page Header a (Displayed on every page)
Page Header b (Subreport, with Supress expression set to: If PageNumber > 1 Then True)
Group Header #1
Details
Group Footer #1
Page Footer
Report Footer

Marcus Aurelius

What happens when you REMOVE the Supress expression set to: If PageNumber > 1 Then True ?

MikeV

ast2550

How about trying to restrict the size of the subreport instead of trying to suppress it once it is on page 2.

Can you count the number of records that will fit on the page and then set your subreport to return no more than that number of records?

Marcus Aurelius

Also, what section is your SUBREPORT

Marcus Aurelius

Let me try again...what section is your SUBREPORT displaying within itself?

In other words, I know you are placing the Sub in the header of your main,...but within the Sub itself...what sections are being displayed for the sub../.?

MikeV

MarkWThompson

ASKER

CRXIuser2005: 1) same error occurs when you remove the Supress Expression. 2) the subreport is in the Page Header c section.

ast2550: Only showing some of the rows is not an option. The user needs to see all of them.

Marcus Aurelius

Oh wait..put your sub in the REPORT HEADER...not the page header...duh..

MikeV

ast2550

Yes, CRXIuser2005 is right. duh.

I thought you could suppress it because of:
Page Header b (Subreport, with Supress expression set to: If PageNumber > 1 Then True)

MarkWThompson

ASKER

I need this subreport to print AFTER another item that is printed in the page header of every page. So, unfortunately, putting it in the Page Header would not do that, correct?

I need:

--------------------------------------------------------
User Name / Page N of N (Top of every page)

Subreport (but only on page 1)

Group Header
Detail
Group Footer
--------------------------------------------------------

In that order.

ASKER CERTIFIED SOLUTION

ast2550

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Marcus Aurelius

I would suggest using the Page FOOTER for the Page numbers...might be a minor concession to live with...

MikeV

MarkWThompson

ASKER

ast2550: It took me a couple seconds to figure out exactly what you were saying, but that worked! There is another small problem (any text before the subreport get's separated (left at the top of the page while the subreport itself prints on the 2nd page). But at least it prints (looks bad, but prints w/ the all the data). Thanks!

CRXIuser2005, you may have meant the same thing, but ast2550 spelled it out for me first (sometimes I'm a little slow to catch on).

Marcus Aurelius

No problem.....I'll make my GURU level yet..........!

One....more.....solution..and I'm in.....ahhh

: )

MikeV

ss44

Was having the same problem. Your solution worked for me as well !!
You guys rock.

Business Objects should consider a rewrite of this product. One work around after another. Its starting to get ridiculous.