crosstab page breaks

[coffee123]

can you force a page break in a crosstab.

ie New page after the total?

thanks

 

[DuncanSutcliffe]

You can accomplish this by putting it in a group header or footer of its own, and setting the section to page break after.

Example: you want to produce a crosstab listing each of your customers and their sales by month, with a total for each sales rep. Then a page break after each rep's total.

Create a group on the {sales rep} field, then put your crosstab in that group's header or footer with {customer} as the row heading and {month} as the column heading. Make sure the section you put the crosstab in is set to page break after.

Duncan

 

[kenhamady]

The only downside is that if one group doesn't have all of the columns, it's section will be narrower than the others. If you want more control over the columns you can hard code them with a manual cross-tab, and do your page breaks using the appropriate section of the report. See my FAQ on common formula examples for how to do manual cross-tabs. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com