PC Review


Reply
Thread Tools Rate Thread

2nd page on Report

 
 
=?Utf-8?B?TGFtYXI=?=
Guest
Posts: n/a
 
      2nd Mar 2005
Get me started in the right direction. In my report I have a page header
with certain information. But on the 2 page I want to keep some page header
info but not other information.

Using VB can I somehow have certain information show on 1st page but not in
the following page in the page header section.

I can use the report header. Thank you.
 
Reply With Quote
 
 
 
 
fredg
Guest
Posts: n/a
 
      2nd Mar 2005
On Wed, 2 Mar 2005 12:19:05 -0800, Lamar wrote:

> Get me started in the right direction. In my report I have a page header
> with certain information. But on the 2 page I want to keep some page header
> info but not other information.
>
> Using VB can I somehow have certain information show on 1st page but not in
> the following page in the page header section.
>
> I can use the report header. Thank you.


Several ways to do this.
1) Place all your Page Header controls in the Page Header.
Code the Page Header Format event:
[ControlA].Visible = Me.[Page] >1
[ControlB].Visible = Me.[Page] = 1
etc.
or...
2) Place the controls you wish to display on the first page in the
Report Header. Place only the controls you want to show on the second
and later pages in the Page Header.
Set the Report's PageHeader property to "Not with Rpt Hdr".
It's on the Report property sheet's Format tab.
The Page header will not show on page 1, but will on succeeding pages.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
 
Reply With Quote
 
=?Utf-8?B?TWF0dA==?=
Guest
Posts: n/a
 
      2nd Mar 2005
I agree with fredg if you what more control over what the reports dose go
with solution 1 it is good practise to use code to edit such information as
you can do nice tricks like pulling other data out of the database to be
displayed as part of the headers.

"fredg" wrote:

> On Wed, 2 Mar 2005 12:19:05 -0800, Lamar wrote:
>
> > Get me started in the right direction. In my report I have a page header
> > with certain information. But on the 2 page I want to keep some page header
> > info but not other information.
> >
> > Using VB can I somehow have certain information show on 1st page but not in
> > the following page in the page header section.
> >
> > I can use the report header. Thank you.

>
> Several ways to do this.
> 1) Place all your Page Header controls in the Page Header.
> Code the Page Header Format event:
> [ControlA].Visible = Me.[Page] >1
> [ControlB].Visible = Me.[Page] = 1
> etc.
> or...
> 2) Place the controls you wish to display on the first page in the
> Report Header. Place only the controls you want to show on the second
> and later pages in the Page Header.
> Set the Report's PageHeader property to "Not with Rpt Hdr".
> It's on the Report property sheet's Format tab.
> The Page header will not show on page 1, but will on succeeding pages.
> --
> Fred
> Please only reply to this newsgroup.
> I do not reply to personal email.
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Report Footer Grand TL not appearing on one page report with colum Chiz Microsoft Access Reports 4 16th Mar 2010 03:31 PM
Can sub-report parameters vary by main report values per page? Dean Slindee Microsoft Access Reports 3 19th Sep 2008 08:26 PM
subreport in report footer has no data, showing blank page at the end of the report FA Microsoft Access Reports 1 16th May 2006 09:16 PM
Print report or page header on each page of a sub-report? =?Utf-8?B?Q2hyaXM=?= Microsoft Access Reports 1 4th Nov 2005 03:32 PM
Report footer on separate page; optionally hide it, reduce total page count by 1, and don't print last (blank) page L Mehl Microsoft Access Reports 2 18th Sep 2003 01:49 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:06 PM.