Print Label Format Problem

[Eljefegeneo]

I have three reports that I want to combine. They are a list of names and addresses to be displayed in three line blocks as five across. The only way I could figure out how to do this was to say I was printing labels, selected a pre-designed format from the report wizard, and then added a header and footer. It all looks great except when I try to combine all three. Both the report header and report footer display the full width of the report.

I inserted a group header, but since the print format is set to print labels, doesn't seem to permit me to display the group header as it does the report header and footer – full width across the page. It displays it as if it was part of the labels, so only part of the group header is displayed.

There are three reports combined, each using the same query with only one criteria difference which is the group header. One report takes almost a full page, the second and third take up about half a page.

What I would like to have is a Report Header, a Report Footer, and three Group Headers that can be displayed (full page width) and the names and addresses five across.

I have tried the following to no avail. Changing the keep together property of the group header to yes and no, changing the repeat section property to yes or no, and inserting a page header which repeats the first group header throughout the report.

Any suggestions?

 

[vbaInet]

A lot of explanation here without any visual evidence. Can you upload some screenshots that best describe your problem?

 

[Eljefegeneo]

I am attaching a sample in 2010 format. The two reports show what I am getting with my "label style" report and a "non-label style" report. I want rptLabelStyle to have a State Header on a separate line like the other report has. Now, it has a State Header, but it is lost in the main body and is confusing to the viewer.

I can send the DB in 2003 if that is preferred.

Thanks for looking at this.

 

[vbaInet]

Yes, send a 2003 version and ensure that the navigation pane is visible. My laptop that has 2010 died on me yesterday so I'm fixing it at the mo.

 

[Eljefegeneo]

Thanks. I had a bit of trouble trying to save it to mdb format, but by changing the sort to General-Legacy, then do a compact an repair, I as able to save it.

I have figured out a work-around, but it is not a very satisfactory one. I only have three different states listed. For each additional one I would hae to have a new query and a new subreport.

 

[vbaInet]

See attached and have a look at rptLabels.

 

[Eljefegeneo]

All seems so simple now. Thank you. I would never have occurred to me that you could do that way. One question. Is the report based on a labels format like I was using previously, or something else. the report is sbrIndLabels.

 

[vbaInet]

The subreport is a columnar report. Open the report in design view and on the ribbon look for the Columns button. Clicking on it will take you to a dialog box where you setup the columns.

You can of course try one of the label formats, but I'm not sure if it would work.