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?

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

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

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