By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,124 Members | 2,054 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,124 IT Pros & Developers. It's quick & easy.

Double heading problem

P: n/a
Jim
I've created a database for tracking wine inventory and printing wine
lists for our resaurant.

The list is grouped by catagory then alphabetically by winery.

I.E.:

Chardonnay
abc winery
bcd winery

Cabernet
abc winery
bcd winery

The catagory is printerd as a header each time a new one starts.
It's also printed as a page header so the person viewng the new page
can tell what they're looking at.

When a new catagory starts at the top of a new page, I end up with a
double header like this:

Cabernet
Cabernet
abc winery
bcd winery

I frequently force the report to start a catigory on a new page, for
instance when I got from white wines to red. As a result I end up with
many double headers

I'd like to eliminate the double header.

Any ideas?

Jim Lamb
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On 3 Mar 2004 12:33:23 -0800, Jim wrote:
I've created a database for tracking wine inventory and printing wine
lists for our resaurant.

The list is grouped by catagory then alphabetically by winery.

I.E.:

Chardonnay
abc winery
bcd winery

Cabernet
abc winery
bcd winery

The catagory is printerd as a header each time a new one starts.
It's also printed as a page header so the person viewng the new page
can tell what they're looking at.

When a new catagory starts at the top of a new page, I end up with a
double header like this:

Cabernet
Cabernet
abc winery
bcd winery

I frequently force the report to start a catigory on a new page, for
instance when I got from white wines to red. As a result I end up with
many double headers

I'd like to eliminate the double header.

Any ideas?

Jim Lamb


Jim,
Don't include the [Category] in the Page Header.
Set the Group's Repeat Section property to Yes.

The Group Header will print again if the Group runs over to the second
(or third, etc.) page.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
Nov 12 '05 #2

P: n/a
Jim
Worked great,
Thx

Jim
fredg <fg******@example.invalid> wrote in message news:<1l******************************@40tude.net> ...
On 3 Mar 2004 12:33:23 -0800, Jim wrote:
I've created a database for tracking wine inventory and printing wine
lists for our resaurant.

The list is grouped by catagory then alphabetically by winery.

I.E.:

Chardonnay
abc winery
bcd winery

Cabernet
abc winery
bcd winery

The catagory is printerd as a header each time a new one starts.
It's also printed as a page header so the person viewng the new page
can tell what they're looking at.

When a new catagory starts at the top of a new page, I end up with a
double header like this:

Cabernet
Cabernet
abc winery
bcd winery

I frequently force the report to start a catigory on a new page, for
instance when I got from white wines to red. As a result I end up with
many double headers

I'd like to eliminate the double header.

Any ideas?

Jim Lamb


Jim,
Don't include the [Category] in the Page Header.
Set the Group's Repeat Section property to Yes.

The Group Header will print again if the Group runs over to the second
(or third, etc.) page.

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.