Rabu, 23 November 2016

RE: [MS_AccessPros] Page Header in a report

 

Hi Robin

Something is making the report formatter think that there is still part of the Zone 1 detail to be printed when you get to the first page of Zone 2.

Does the previous page print all the way to the bottom? Is your Detail section higher than it needs to be?

Perhaps you could upload a cut-down version of the database (with sanitised data if necessary) that exhibits the problem.

Cheers,
Graham

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Wednesday, 23 November 2016 12:20
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] Page Header in a report

 

 

G'day Graham,

The ForceNewPage property is set to "None".

To explain the use of the word the grouping is on "Zones".

The Zone 1 header shows together with Zone 2 header on the first page on the Zone 2 pages. The second page is correct. This fault continues on the second page of each Zone.

Cheers,

Robin

At 18/11/2016 01:45 PM, you wrote:

Hi Robin

Does your Zone Header section have the ForceNewPage property set?  If so, what is its setting?

Graham

From: MS_Access_Professionals@yahoogroups.com [ mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Friday, 18 November 2016 15:42
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] Page Header in a report

 

 


G'day Graham,

Yes I quoted that so that I was able better to ex[plain the problem

Robin

At 18/11/2016 11:13 AM, you wrote:

 

Hi Robin

 

I’m not sur e what you mean by “zones”.  Is [Zone] the grouping field to which the header applies?

 

Graham

 

From: MS_Access_Professionals@yahoogroups.com [ mailto:MS_Access_Professionals@yahoogroups.com]

Sent: Friday, 18 November 2016 13:03

To: MS_Access_Professionals@yahoogroups.com

Subject: RE: [MS_AccessPros] Page Header in a report

 

 

OOOPS!!! I counted chickens too soon! The headers are for various zones and  the header for Zone 2 also has a Zone 1 header. This continues through all zones. It only happens on the first page of each zone.

H E L P !!!

Robin Chapple

At 18/11/2016 09:56 AM, you wrote:

 

G'day Graham,

That worked as you described. Many thanks,

Robin Chapple

At 17/11/2016 02:28 PM, you wrote:

 

Hi Robin

 

Set the Repeat Sectio n property of the header section (in the Format tab) to Yes.

 

Best wishes,

Graham [Access MVP 1996 – 2016]

 

 

From: MS_Access_Professionals@yahoogroups.com [ mailto:MS_Access_Professionals@yahoogroups.com]

Sent: Thursday, 17 November 2016 16:01

To: MS Access Professionals-yahoogroups.com < MS_Access_Professionals@yahoogroups.com< /a>>

Subject: [MS_AccessPros] Page Header in a report

 

 

I am using Access 2013. I have a report that produces data in groups.

I use a group header. Some groups spill over to a second page. How do

I get the group header on the second page?

Many thanks,

Robin Chapple

__._,_.___

Posted by: "Graham Mandeno" <graham@mandeno.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (10)

Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.


.

__,_._,___

Tidak ada komentar:

Poskan Komentar