Horizontal Page Break Possible? 1

[carynbo]

Goal: Report displays annual sales in columns starting with 1990 to the present. Each year a new sales column should be added to the right. Rows are regions.

It has been suggested that I do the report on legal-sized paper, to leave room for the next few years to be added to the right.

I would rather keep to our standard letter-sized paper, with a horizontal page break. If 1990-1999 fit on the first page, I'd like to continue 2000-2004 on a second page, with the same report headings.

Can this be done? Thanks very much. Caryn

 

[lbass]

Caryn,

If you are using an inserted crosstab, your new sales years would automatically be added into virtual pages to the right, which would print out as separate pages. You could format the crosstab to repeat row labels so that they appear on the virtual page as well. You would lose page headers though in this approach.

The other approach, again assuming you are using an inserted crosstab, would be to group columns, and if I'm remembering right, a year or two ago, this solution was proposed in one of your threads. You would create a new group using a formula like:

if year({table.date}) in 1990 to 1999 then 1 else
if year({table.date}) in 2000 to 2009 then 2 else 3

You would group on this formula, making it your outermost group, and then place the crosstab in the group header or footer. You could then format the group header or footer with "new page after." The down side of this is that the row totals will be limited to the columns in the group instance, but you could suppress them if you wished and add a new crosstab in the report footer that has no column field and thus summarizes all columns.

If you are not using an inserted crosstab, you can still use the outer group approach, with a new page after the group footer.

-LB

 

[carynbo]

lbass,

a very delayed thank-you for your reply. i was trying to accomplish this task without doing a crosstab, because the boss prefers the nicer report-style formatting. but your note nudged me to do this as a crosstab, which i believe is the correct, efficient way to display this matrix. and that's what i'm stickin with.

thanks again for your help and the perfect solution.

caryn