Solved

Print Report Header on bottom of page AFTER detail

Posted on 2004-04-02
7
377 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
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

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

 

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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
cross tab report accumulative amount 9 55
Left and Right Trim a field in Crystal Report 2 166
Dynamic Image won't display if no data is returned 11 65
Crystal Reports 12 41
I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
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…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

828 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