View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Rayo K
 
Posts: n/a
Default 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