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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

[color red]Cross-Tab repeating it's self....

Status
Not open for further replies.

davefm1

Programmer
Apr 18, 2001
78
US
Hi
I have a cross tab report that repeats self multiple times at different pages with partial data in each cross tab.
Has anyone else run into this? How do you work around this?

Any Insight to this problem would be appreciated.
 
If the cross tab is in a group header/footer it will repeat for each group with only the data from that group. If you want all the data from the report, you need to place the crosstab in the report header or report footer.

Lisa
 
Hi Lisa;

I do have the cross tab in the group header for and I have a new page for each group(year) However when i get to page 13 that page of the cross tab repeats it self riight below its self
Example of cross tab for page year2010 problem on same page or mutiple page of year2010 instead of one page per year with new page after format option

Jan10 Feb10 Mar10 Apr10 May10.........
xxx 12 12 0 0 0
yyyy 145 145 0 0 0
dddd 120 120 0 0 0
_________________________________________________
0 0 12 12 12
0 0 145 145 145
0 0 120 120 120



Should be like this
Jan10 Feb10 Mar10 Apr10 May10.........
xxx 12 12 12 12 12
yyyy 145 145 145 145 145
dddd 120 120 120 120 120
___________________________________________

I hope this explation helps.

Dave
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top