Print Page | Close Window

Print area in excel

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=17882
Printed Date: 17 May 2024 at 7:51pm


Topic: Print area in excel
Posted By: Barb
Subject: Print area in excel
Date Posted: 31 Oct 2012 at 1:47am

Please help...

 

I have a problem where a report in Crystal Reports shows as one page, but when I export it to Excel it shows up as two pages.

 

So far I have found nothing that could overcome this problem. Does any one know how to make print area work as in pdf without manual intervention?

 

 

Thank you

 

Barb 



-------------
Many thanks
Barb



Replies:
Posted By: hilfy
Date Posted: 01 Nov 2012 at 7:30am
I would check you Excel export settings - make sure that "Create Page Breaks for Each Page" is turned off.  Beyond that, there is not much that you can do to control how things are exported to Excel.
 
-Dell


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics


Posted By: Barb
Date Posted: 01 Nov 2012 at 11:00am
Thanks Dell

I was afraid of that



-------------
Many thanks
Barb



Print Page | Close Window