Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Page header and footer

Posted on 2010-09-24
14
Medium Priority
?
833 Views
Last Modified: 2012-05-10
When a report is run i get this error shown on the enclosed jpg

Page header and footer longer than page

The length of the report will vary depending upon the amount of information is picks up. In other words sometimes it works and sometimes it doesn't. How do I can the page header and footer to adjust itself so it works all the time and not being dependant upon the amount of information in the report
error.jpg
0
Comment
Question by:Stevepaget
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 3
  • 2
  • +3
14 Comments
 
LVL 12

Expert Comment

by:JayConverse
ID: 33752538
You need to control the "can grow" fields or subreports that you're placed on the header or footer, they're getting too large.  
0
 
LVL 6

Accepted Solution

by:
kswathi earned 2000 total points
ID: 33752566
0
 
LVL 19

Expert Comment

by:GJParker
ID: 33753882
What objects have you got in these sections ?
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 

Author Comment

by:Stevepaget
ID: 33754027
When I go to format subreport the number of lines is disabled or greyed out
can-grow.jpg
0
 
LVL 12

Expert Comment

by:JayConverse
ID: 33754111
Uncheck "Can Grow"
0
 
LVL 19

Expert Comment

by:GJParker
ID: 33754259
Why do you have a subreport in the page header section ?

What would you like to happen if the information in tne subreport is too big to fit on a page?
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 33758300
Since a page must have a page header and footer, they have to fit on the page otherwise it is trying to go to the next page which means the page header starts again but the page header and footer aren't done fromthe previous page.

The only way to do this would be to limit the number of records the subreport through suppression or filter.

mlmcc
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 33758302
Are you sure you want the subreport in the page header/footer?  Does it need to be on each page or can you put it in the report header/footer

mlmcc
0
 
LVL 1

Expert Comment

by:louisgh
ID: 33759820
I think that if you try to put a subreport in a page footer or in a page header , you are restricted to one page for this section and no more..
maybe you should try to build a group that contains all the data ( like company no if exists ) and put your subreport in the group footer section.
0
 

Author Comment

by:Stevepaget
ID: 33761289
I dont have any sub reports in the page header or the page footer. They are all contained in a group header or group footer
However it still gives me this error when I run reports over a certain length
Delivery-Ticket---Copy.rpt
0
 

Author Comment

by:Stevepaget
ID: 33761295
BTW unchecking can grow doesn't activate the maximum number of records
Uncheck-can-grow.jpg
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 33761566
That is for TEXT fields to limit them to a number of lines.

I don't see anything in the report that should be doing that.

One thing you might do is uncheck the SUPPRESS option when you use a formula.

Is it a specific number of records that causes the problem?

mlmcc
0
 

Author Comment

by:Stevepaget
ID: 33762125
I think it's the number of records on a page. The record can vary in depth depeneding on the information contained in it. I think sometimes it just goes over the length of the page and causes this error. I don't know how to tell it if it gets to a certain point to move the information to the next page. I have tried the obvious, ie keep together etc
0
 

Author Closing Comment

by:Stevepaget
ID: 33888482
Solution Found
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Video by: ITPro.TV
In this episode Don builds upon the troubleshooting techniques by demonstrating how to properly monitor a vSphere deployment to detect problems before they occur. He begins the show using tools found within the vSphere suite as ends the show demonst…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…

604 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question