Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 297
  • Last Modified:

How to make a page break in cross-tab between each group section?

I'm using crystal report 8 to create report. But, I don't know how to make a page break between each group section when I am using cross-tab. Anyone can help me?
0
leo_wh_cheung
Asked:
leo_wh_cheung
  • 3
  • 2
1 Solution
 
DRRYAN3Commented:
You really cannot do this.  Take a look at where CRW is putting your crosstab - it's all in the report header.  There is no way to add sections to a crosstab report that I'm aware of.

DRRYAN3
0
 
leo_wh_cheungAuthor Commented:
So, I can't find ANYWAY to add a page break to a crosstab?!?


Like,
                Day1  Day2  Day3  Day4  Day5  Day6 .....
Department A
  Person A

  Person B

  Person C

-----page break---------

Department B
  Person A

  Person B

  Person C


0
 
leo_wh_cheungAuthor Commented:
I put the crosstab in report footer
0
 
DRRYAN3Commented:
You can always make your own crosstab query in Access or SQL Server and design your report from that query to make it do whatever you want.

Regardless of where you put the crosstab report, header or footer, you are not provided the opportunity to add page breaks.

You might be able to create a crosstab that limits records only to the department in question as a subreport, basing the main report on the department numbers.  Link the subreport to the main report on the department number and limit the crosstab to the linked department.  Put the sub-report in the details and add a group on the department number.  Force the page break in the group footer section formatting.  Never tried that, but it may work.

DRRYAN3
0
 
leo_wh_cheungAuthor Commented:
Thanks a lot
The time now is 2:00am
Good night!!!
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now