Multiple page report in a pivottable

R

Rayo K

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?
 
G

Gazeta

U¿ytkownik "Rayo K said:
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?
Click to expand...
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
 
R

Rayo K

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?
 
D

Debra Dalgleish

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
 
Top