Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

CrossTab formatting

Status
Not open for further replies.

52

Programmer
Jan 23, 2002
30
US
I have a crosstab report with years in the columns and NameType in the Row followed by Name and amount in the summarized field. Is there a way to begin a new page when the "NameType" changes? (So all the NameTypes will be on different pages and not broken up?)
 
You can simply group by NameType, set new page after the group footer, and insert the CrossTab in the Group header or footer.

Cheers,
- Ido ixm7@psu.edu
 
That worked. THANKS!!!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top