asked on

Reporting Services (mailing labels) how to get physical page break on group change instead of column break?

I'm generating labels (Avery 5160 : 3 across, 10 down) for a school. Grouping of students is by grade. Each new grade must start printing on a new sheet of labels. We must not start printing a grade's group on the next available column of labels on a partially used sheet. The reason we cannot have more than one grade group on a physical sheet of labels is that the sheets are taken off of the printer and handed directly to the grade's teacher. No one will cut the sheet coming out of the printer to separate grades.

When I put a page break between grade groups the next grade prints on the next available column of the label sheet. How can I force extra breaks to get the next grade to print on the next label sheet in the printer? I understand that Reporting Services treats each column in a multi-column report as a page--so it would be the equivalent of forcing extra page breaks (an extra one or two page breaks depending in which column the last data item for the prior group printed).
Attached are the .rdl file and dataset, and a Word document showing an image of what is rendered vs the desired rendering. I've added a ".xml" extension to allow these files to upload to this site. Whem importing into Reporting Services make sure you remove the ".xml" extension so you have valid file names "MultiColumnPageBreakOnGroup.rdl" and "MultiColumnPageBreakOnGroup.rd
MultiColumnPageBreakOnGroup.doc
MultiColumnPageBreakOnGroup.rdl..xml
MultiColumnPageBreakOnGroup.rdl.xml

RippleBirder

ASKER

Looks like I have solved my own question. I added a column to the dataset which returns the number of page breaks (columns) that have to be forced in order for the next group to print on the next physical sheet of paper.

Then I set up an "adjacent group" after the detail section to add a page break if a one or two column shift need to be forced. If no additional page break is needed (due to a break in the actual group) the adjacent group is hidden and therefore, does not break.

A second "adjacent group" after the detail section is required if a two column shift is to be forced. This is hidden to prevent a page break if only one or no additional page breaks are needed.

I'll clean up my solution and post it for others.

ASKER CERTIFIED SOLUTION

RippleBirder

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial