Solved

Print Report Header on bottom of page AFTER detail

Posted on 2004-04-02
7
373 Views
Last Modified: 2012-08-14
I've using Crytal Reports 9 and trying to create an invoice with a remittance slip on the bottom of page one.

This solution looks prommising but when I set my report up that way, the group headers and detail don't start printing until page 2.  Has anyone else got this to work or have other ideas?

http://www.experts-exchange.com/Databases/Crystal_Reports/Q_20295506.html
0
Comment
Question by:TogasPoon
  • 4
  • 3
7 Comments
 
LVL 13

Expert Comment

by:EwaldL
ID: 10743861
you cannot have the report header below the detail section, that's by definition so you need to implement some workaround.

you could split the page footer and conditionally suppress these so that on the first page you see the special info, and on the other pages you see the general page footer
0
 

Author Comment

by:TogasPoon
ID: 10743912
Yeah, that is what I am doing now but subsequent pages have large blank sections on the bottom because CR does not return the allocated space for a footer even if it is suppressed.


I was trying this solution because gawilson2000 indicated that he got it working in the link provided above.  Check out the link and you will see that the Page Footer and Group Footers won't work.

I'm beginning to think that there may not be a viable solution to this.
0
 
LVL 13

Expert Comment

by:EwaldL
ID: 10743964
in this case use only one report footer, insert all information in the report footer and conditionally suppress the elements in the report footer. now you shouldn't have any white space on following pages.
0
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 

Author Comment

by:TogasPoon
ID: 10744053
Nope, CR doesn't return the height held reserved by the Footer.

I've tried suppessing the elements and the section and both.  What version are you using, I'm on 9?

0
 
LVL 13

Accepted Solution

by:
EwaldL earned 500 total points
ID: 10744171
i am in cr 9 too. i thought you would use the page footer on following pages for other information. so the above suggestion is no good then if you are not using them at all.

so i have just tried this out and according to how i understand your requirement it does the trick
- increase the height of your report header so that it spans a whole page. insert your token at the bottom of the report header section
- reduce the height of the page footer to zero
- in the section expert, format the report header to "underlay following sections"
- still in the section expert add a conditional formula for the detail section's "new page after". use something like RecordNumber = 30. basically use the number of records you want to have on the first page.

now refresh the report. would this solve the problem?
0
 

Author Comment

by:TogasPoon
ID: 10744624
That gets me close but there are still some issues.

My report layout is as follows

Report Header - Full page w/underlay
Group Header 1A - 1st page only
Group Header 1B - Every page but the 1st
Group Header 1C - Every Page
Detail
Group Footer 1 - Every Page

The problem is that it is not a straight forward tablular report.  The detail has 2 subreports and their lenght will vary.  I can probably come up with something in SQL to figure out when to call the inital page break.

I have a Box that goes from Group Header 1C to Group Footer 1.  Before trying the extended header solution you suggested this was working well.  Now it runs to the bottom of the page instead of ending when the detail does.

Also the detail is now running off the page.  I'm sure this has something to do with the height of the Report header section/margins but I'm not having much luck figuing out the correct settings.

Thanks for you help.



0
 

Author Comment

by:TogasPoon
ID: 10761034
Ok, after some tweaking I'm 95% of the way there.

Is it possible to determine the height of the detail section before printing?  I'm hoping I can set my "Force new page" in the detail section to after record 2 or 3 depending on how much space it will take and at what point in it starts printing (current height + detail height)?
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

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…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

744 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now