Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

export crosstab report to PDF

Status
Not open for further replies.

crystalhelp

Programmer
May 13, 2002
56
0
0
CA
I have a cross tab report that is rather wide and long and spans multiple pages. It exports properly to HTML and Word, but when I export to PDF the column labels, the row labels, and page numbers do not print on the pages that are too wide, but do print on the pages that are too long. Does that make sense?

Imagine I have a cross tab that looks like this:


column1 column2 column3 column4 column5
row1
row2
row3
row4
row5

Let's say only the first 4 columns fit on the page and column 5 is pushed to the next page. It will display the data for all the rows in that column, but it won't display the labels or count the page.

If row4 was the last row to fit on the page and row 5 was pushed to the next page, everything will be perfect, except the page number would be 2 of 2, when really it should be 3 of 4. (page 1 would be row 1-4 column 1-4, page 2 would be row 1-4 column 5, page 3 would be row 5 column 1-4, and page 5 would be row 5 column 5)

Is this a crystal/pdf bug, or is there some way I can fix this?
 
This is actually often a benefit. If you print pages 5 to 7, it will actually print the pages that would be 5 to 7 if each row fitted on a single page width.

Having said that, I can see how this could be annoying.

Since I do not have any better answer for you, my suggestion is to make the font small enough so that the data does fit on a single page width.

Of course, you may need to budget for magnifying glasses...
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top