?
Solved

How to control the Page Breaks in a Cross Tab?

Posted on 2011-04-26
13
Medium Priority
?
1,963 Views
Last Modified: 2012-05-11
Hi,

I have a Crystal Report, which is made into a Cross Tab. This Cross Tab has 3 levels.
But when i exported the report to Microsoft Excel(97-2000), it is page breaking somewhere in the middle and the headers are repeated in the next page. Is there a way, i can overcome this issue? Please advise.

Attaching the report.
NEW.rpt
0
Comment
Question by:pvsbandi
  • 7
  • 6
13 Comments
 
LVL 101

Expert Comment

by:mlmcc
ID: 35467556
I don't think there is a way to control the page breaks

In the cross tab expert you may be able to keep groups together
In a quick look I wasn't able to find anything that would control the groups.

WHen I use your report I don't see the issue.

Is it paging vertically?

mlmcc
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 35467566
How are you exporting?

Are you setting the option to export headers once?

mlmcc
0
 

Author Comment

by:pvsbandi
ID: 35467788
yes..what options were you suggesting to make it work? Please advise.
0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
LVL 101

Expert Comment

by:mlmcc
ID: 35468000
How are you exporting?

When I exported from the preview, there was an option screen presented.  One of the options pertained to exporting page and group headers.

If you are exporting from code there should be a property to set that controls that.

mlmcc
0
 

Author Comment

by:pvsbandi
ID: 35468111
I'm selecting Microsoft Excel (97-20000) and in the next step, i'm selecting the "Grid Lines" checked.
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 35468258
WHat version of Crystal?

See the attached image for what i am getting as options
NEW-Export.jpg
0
 

Author Comment

by:pvsbandi
ID: 35468338
Mine is XI R2..

   The options you chose doesn't have the "Show Gridlines" checked. It will make it very hard for the users to follow the report.

   Can you please attach the excel output also, so i get a feel of how you did?

Thanks a bunch for looking into this issue.
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 35468621
Show Gridlines will not affect the paging.  I don't have FOLIO as a page size option in Excel so the paging is off.

mlmcc
new-1-.xls
0
 

Author Comment

by:pvsbandi
ID: 35469169
But the data is not legible on the report. If the user gets this report, he would have a hard time formatting it to be able to analyze.
  Can we do some width change and yet not let the page breaks repeat the headers?
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 35469522
Are you talking about horizontal or vertical page splits?

You can in my option block choose where the column width are determined.  Use the field headers.


Crystal does not do a good job of exporting to Excel.  There is a document that provides guidance on how to format a report to make exporting better.  However as I recall much of the guidance doesn't really apply to the cross tab and especially to one with 3-levels of grouping.

http://www.sdn.sap.com/irj/boc/go/portal/prtroot/docs/library/uuid/20c9c239-7b64-2b10-4ab3-b59d52ed35de?QuickLink=index&overridelayout=true

mlmcc
0
 

Author Comment

by:pvsbandi
ID: 35469648
I'm talking about Horizontal Page splits.. On the report, level 1 repeats whenever a part of level 2 or level3 falls on the next page. Similarly, level1 and level2 repeat when a part of  level3 falls into the next page.
0
 
LVL 101

Accepted Solution

by:
mlmcc earned 2000 total points
ID: 35471775
I dont think there is much you can do.

I see the issue.  

One thing to try would be a different printer or use one where you can define a custom paper size that is wide enough or tall enough to hold the entire cross tab.
I defined a custom page of 33" wide for one of the reports I was writing.  We didn't need to ever print the data just export to Excel.

mlmcc
0
 

Author Closing Comment

by:pvsbandi
ID: 35476433
Thank You! I could solve this by changing the print layout to a larger page..

  I have another question ,but i'll ask as a new question.
Thanks again for your help!
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
Suggested Courses

807 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question