Displaying title and page #'s on multiple-page cross-tab report

[YAmoah]

I've created a cross-tab report that displays data in a total of 8 columns(4 columns on each page). I'm not able to figure out how to make the Title of my report, display on every page. It only displays on the first page of the report. I put the title in the Page Header section because I knew that it would not carry over to the next page if it was in the Report Header section. The cross-tab is located in my Group Header section. I also noticed that when I run the report the page count shows as "1 of 1" even though the cross-tab spans throughout two pages. It's as if the cross-tab doesn't recognize that there is a second page. I hope someone can help me with this problem. It's driving me crazy!

Thanks,

YAmoah

 

[kenhamady]

what version of crystal are you using? Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal

 

[YAmoah]

I'm using version 8.

 

[kenhamady]

YAmoah,

The Report header (if it streches to multiple pages) can't print a page number except for page one. There are two options. If you put your Cross-tab in the report footer, you will get page numbers. This is handy when your report is only a Cross-tab.

If you need the Cross-tab first and then the report there is one work around. It involves adding an additional primary group to the report, that groups the entire report as one group (find a field that is constant and group on it).

Since the entire report is this group, the Group header for this report will behave like the page header, appearing once per report.

Put the Cross-tab here and it will generate page numbers. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal

 

[YAmoah]

KenHamady,

I followed your suggestion and grouped the entire report based on a constant field in the data source and placed the title and the crosstab in this grouped section. When I use the arrow buttons at the top of the report viewer to scroll to the next page, the title and crosstab is showing on every page. However, I noticed this only happens when the detail section is not suppressed. I do not need the detail section, but if it is suppressed, I'm back to the same problem - the title showing only on the first page and the report viewer showing "page 1 of 1", as if it doesn't recognize that the crosstab spans throughout several pages. I also noticed that even when the details section is suppressed, the page numbers are showing, and I'm able to use the arrow buttons at the top of the viewer to scroll to the next page, the first four columns of the crosstab, shown on the first page, is repeated on the subsequent pages. It should not be doing this. The other pages should show the remaining columns of the crosstab. But when I use the scroll bar at the bottom of the viewer to move to the next page, I can see the entire crosstab the way it should appear, but I do not see the title and the page number shows as "page 1 of 1. How can I solve this problem?

YAmoah

 

[YAmoah]

If my last reply was confusing, I can send you a sample of my report.

YAmoah

 

[kenhamady]

What do you mean by "Viewer"?
Is that the same as preview or are you using a specific viewer?

Subsequent pages down (arrow keys) should show additional rows of the same columns, never additional columns. Additional columns are always to the right, even if it goes to another piece of paper.

If your Cross-tab more than one piece of paper wide, crystal doesn't number these pages separately. Wide cross tabs that span another piece of paper are considered as being one very wide page for pagination purposes.

That being said, please explain again the difference between having details, and not having details.

Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal

 

[flowgage]

I am in 8.5 and have the same problem anyone have a new solution for page number problem?

 

[kenhamady]

flowgage,

Did you try the technique I posted on 11/12? Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com