Very Wide report - needs multiple pages
I have a report (several, actually) which have 1-n columns, but only y
columns can fit on a page. The first x columns are fixed. So, I want to
repeat the first x columns on each page, and print what will fit on each
page.
Example: I have the following data:
Date Col1 Col2 Col3 Col4 Col5 Col6 Col7
Only four columns fit on a page, and the Date is needs to be on each page.
I want to print as follows:
Page 1
Date Col1 Col2 Col3
Page 2
Date Col4 Col5 Col6
Page3
Date Col7
Is there a built-in mechanism in report builder that I can use?
columns can fit on a page. The first x columns are fixed. So, I want to
repeat the first x columns on each page, and print what will fit on each
page.
Example: I have the following data:
Date Col1 Col2 Col3 Col4 Col5 Col6 Col7
Only four columns fit on a page, and the Date is needs to be on each page.
I want to print as follows:
Page 1
Date Col1 Col2 Col3
Page 2
Date Col4 Col5 Col6
Page3
Date Col7
Is there a built-in mechanism in report builder that I can use?
This discussion has been closed.
Comments
Check out the following example. This shows how to extend columns to the
next page by controlling which pages are sent to the printer devices. Hope
this helps.
http://www.digital-metaphors.com/tips/SpreadsheetStyle.zip
--
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com