| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple page report in a pivottable
Hi, I want to printout a rport with a separate page for each date. My table
has several hundred records for each date. How can I make a pivottable do this? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Multiple page report in a pivottable
U¿ytkownik "Rayo K" napisa³ w wiadomo¶ci ... Hi, I want to printout a rport with a separate page for each date. My table has several hundred records for each date. How can I make a pivottable do this? you cannot print hundreds of lines on one page and have it visible better solution would be to use subtotals and use option - pagebreak between subtotals mcg |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Multiple page report in a pivottable
Sorry, everyone time I tried to post a detailed question, the browser quit on
me. What I want to do is insert a page break between dates, but to have the row headers at the top of each page and have a header on each date section with the date: "Ticket log for dd/mm/yyyy" or something like that. Is that possible with a pivottable? "Gazeta" wrote: U¿ytkownik "Rayo K" napisa³ w wiadomo¶ci ... Hi, I want to printout a rport with a separate page for each date. My table has several hundred records for each date. How can I make a pivottable do this? you cannot print hundreds of lines on one page and have it visible better solution would be to use subtotals and use option - pagebreak between subtotals mcg |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Multiple page report in a pivottable
To show the headers, right-click on the pivot table, and choose Table
Options. Add a check mark to 'Set print titles', and check 'Repeat item labels on each printed page' Click OK Rayo K wrote: Sorry, everyone time I tried to post a detailed question, the browser quit on me. What I want to do is insert a page break between dates, but to have the row headers at the top of each page and have a header on each date section with the date: "Ticket log for dd/mm/yyyy" or something like that. Is that possible with a pivottable? "Gazeta" wrote: U¿ytkownik "Rayo K" napisa³ w wiadomo¶ci ... Hi, I want to printout a rport with a separate page for each date. My table has several hundred records for each date. How can I make a pivottable do this? you cannot print hundreds of lines on one page and have it visible better solution would be to use subtotals and use option - pagebreak between subtotals mcg -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help! How to print multiple charts on the same page | Excel Discussion (Misc queries) | |||
| How do I save one page out of a 80 page report in excel? | New Users to Excel | |||
| Increment Page Numbers for multiple tabs in Excel | Excel Worksheet Functions | |||
| How do I put multiple pie charts on one page? | Charts and Charting in Excel | |||
| How do I print a one page spreadsheet multiple time, each with its own page number? | Excel Discussion (Misc queries) | |||
Linear Mode
