473,840 Members | 1,577 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Printing Page Heaer of a sub report



Dear reader,

In case a report is a sub report the Report Header of the sub report is
printed in the report but the Page Header of the sub report will not be
printed. This is the same for Page Footer of the sub report.

Is there a possibility to force printing Page Header and Page Footer of a
sub report.

The Page Header and Footer of the master report is not the problem it is the
sub report.

Thanks for any help.

Kind regards,

Simon
Dec 11 '07 #1
2 2914
Simon wrote:
Dear reader,

In case a report is a sub report the Report Header of the sub report is
printed in the report but the Page Header of the sub report will not be
printed. This is the same for Page Footer of the sub report.

Is there a possibility to force printing Page Header and Page Footer of a
sub report.

The Page Header and Footer of the master report is not the problem it is the
sub report.
I'm sure others have some methods different than mine. The report
header only prints once in a subform. Page headers/footers not at all.
My method also works great when you want to print a multicolumn reports.

First, I go into the Recordsource of the report and if not a query, make
it one by clicking on the triple-dot. I then add a column. I call it
Master. To create this column in the query builder I enter
Master : "M"

Save the recordsource. Now every record will have a column called
Master. I now go to Sorting&Groupin g in the Reports menu. I now add a
new sort field, Master, drag it to the top of the sort list usually, and
create a header and if need be a footer.

You'll now see a band for Master. Double click on the band to pull up
it's property sheet. Under the Format tab look for RepeatSection. Set
it to Yes if you anticipate the subreport may print on multiple pages.

Now move your Page/Footer header stuff into Master's respective bands.

That's it.

Hick
http://www.youtube.com/watch?v=XJMJmiRqR60
>
Thanks for any help.

Kind regards,

Simon

Dec 11 '07 #2
On Tue, 11 Dec 2007 21:37:34 +0100, "Simon" <Sv********@Ver satel.nlwrote:
>

Dear reader,

In case a report is a sub report the Report Header of the sub report is
printed in the report but the Page Header of the sub report will not be
printed. This is the same for Page Footer of the sub report.

Is there a possibility to force printing Page Header and Page Footer of a
sub report.

The Page Header and Footer of the master report is not the problem it is the
sub report.

Thanks for any help.

Kind regards,

Simon
You can use a Group Header/Footer instead of the Page Header/Footer.

In the recordsource of the subreport include a calculated field which returns a
common value for every record. eg PgHead:0
This ensures every record in the recordsource is included under a single group.

In the design of the subreport add a Group Header/Footer for the field PgHead.
Cut all the controls out of your Page Header/Footer and paste them into the
Group Header/Footer.
Set the Repeat Section property of the Group Header to True.
Remove the Page Header/Footer.

The Group Header/Footer should display in the subreport as a Page Header/Footer
would normally display.


Wayne Gillespie
Gosford NSW Australia
Dec 11 '07 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
5876
by: Jamey Shuemaker | last post by:
I've been looking for a way to do a duplex print job without a duplex printer. I reviewed some old posts about printing odd pages and found that most of them led to KB article 101075 or an export of the document to Word for duplexing there. I was looking for a VBA method for doing this, so the KB article is right out and when you export to Word, some of the report's text boxes wind up truncated because of some sort of sizing difficulty...
0
1843
by: Nigel | last post by:
I successfully create a .NET Component (Visual Basic .NET) that would print, unfortunately when used within a web browser it appears that .NET security doesn't allow you to run code that interacts with the file system (including printing) from the web browser. How do I disabled this so I can get my windows form control to work within IE? Also, do any have any printing code or know how I can implement multipage printing using the...
6
4095
by: Siv | last post by:
Hi, I am getting into printing with VB.NET 2005 and want to implement the usual capability that a user can select a selection of pages. I have a report that is generated by my application that if the user wants all pages will produce 3 pages. I want to offer the user the ability to select via the print dialog that only pages 1 and 2 of it are printed or possibly pages 1 and 3 but not 2. At the moment I can produce all three pages...
4
5904
by: Lucas Ponzo | last post by:
Hi All, I have an ASP.NET 2.0 app. The users access the pages, uniquely via pocket pc ... I need to print a page. But I need that the page print on a printer installed on the web server hosting my application. Step 1) The user clicks the Print icon in the web page
0
5781
by: John Smith | last post by:
Hello, I have 7 different crystal reports that need to be collated. Since I want to end up with a page of each (which all together make a single report), I created a blank main report and then added the 7 as subreports so they can print one after the other. I'm supposed to be printing them from a VB.Net 2003 application and I will be passing 2 parameters (start and end dates). These reports are huge (over 1000+ pages each). My original...
2
9989
by: Brad Pears | last post by:
I have a vb.net 2005 application and am using the print preview screen. This screen has a printer icon on it that the user can use to print the document currently being viewed. It uses the default printer settings to print. I wanted the print preview to appear the same for all users (i.e. a default page size of 8.5x14 (legal) and portrait mode). Many users have different printers as their default (plotters etc..) and I found that various...
1
3358
by: adolph | last post by:
I have a problem with pages being printed out of order. An example is a 15 page duplexed report. Title page fine back of title page blank. (As it should be) SEcond page front, bottom says Page 1 of 15. Second page back says Page 10 of 15. Third page front says Page 3 of 15. Third page back says Page 4 of 15. Special not Page 10 of 15 is the correct page IE it duplicated page 10 and placed it in place of page 2. The real page two is...
18
11327
by: Brett | last post by:
I have an ASP.NET page that displays work orders in a GridView. In that GridView is a checkbox column. When the user clicks a "Print" button, I create a report, using the .NET Framework printing classes, for each of the checked rows in the GridView. This works fine in the Visual Studio 2005 development environment on localhost. But, when I move the page to the web server, I get the error "Settings to access printer...
0
2856
it0ny
by: it0ny | last post by:
Hi guys, thanks I am fairly new to this forum so I hope I chose the right place to post this question. I try to make my program printout a deposit's report. I created a class to store the printing printing data and the actual database data in a recordset. the class looks like this: Public Class BRPDD 'Balance Report PrintingDocument Data Public totalReceiptsNum As Integer Public totalLicFee As Double
0
9699
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10922
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10603
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
9440
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7838
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
7023
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5685
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
4498
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
3
3138
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.