Scaling Fit to page - excel export

I am trying to mimic an excel report. In excel scaling (50%) is enabled in the page setup and is fit to page.
I have to use Letter and Landscape. The report is too lengthy. Is they any scaling option in Crystal?
At the moment I am using fotnt size 6 to fit to page after exporting to excel.
It is good for printing, But it is not good for viewing in excel after the export.
Can somebody help me?
ShamanthAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
mlmccConnect With a Mentor Commented:
I don't know any such feature.  This document about Exporting Crystal to Excel may help

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

mlmcc
0
 
ShamanthAuthor Commented:
I already have this doc.  It doesn't help me much. Please try scaling in Escel Page setup and you will know what I am talking about. May be you know the answer for that in Crystal.  But I am looking after excel export within Crystal.

0
 
mlmccCommented:
Are you trying to change how the Excel sheet looks after you do the export?

mlmcc
0
Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

 
Ido MilletProfessor of MIS at Penn State Erie and Owner, Millet SoftwareCommented:
At least one of the 3rd-party Crystal Reports desktop scheduling tools listed at http://www.kenhamady.com/bookmarks.html#desktopsched allows you to this via a command line argument.
0
 
ShamanthAuthor Commented:
mlmcc,

yes. I am trying to see the feature after excel export without updating the excel sheet manually. At the moment I am using Arial Font6 to fit the report in one page. But in the current excel reports they are using scaling feature to fit in one page.
0
 
mlmccConnect With a Mentor Commented:
I believe you will have to use an application or 3rd-party tool to control that after the sheet is created.

mlmcc
0
 
ShamanthAuthor Commented:
Yes.. BOBJ just confirmed that it is not possible. I have been talking to several tech people regarding this.  Thanks  though..
0
 
ShamanthAuthor Commented:
thanks..
0
 
Ido MilletProfessor of MIS at Penn State Erie and Owner, Millet SoftwareCommented:
Sounds like you are giving up but, as mentioned above, there is at least one Crystal Reports scheduler that provides a solution.  Here is some detail from the user manual.

Setting Up Print Properties for Excel Workbooks
You can instruct <this tool> to change the print setupproperties of an Excel workbook or a specified tab (sheet) inside thatworkbook.  The command line argumentstructure is as follows:

"XLS_Print_Setup:Excel_File>Tab>"

The parameters (after the “:”) are separated by a “>” and are as follows:
  1. Excel_File: the     full path and name of the excel file.
  2. Tab: the tab     (sheet) name.  Use 1 to     target the first tab. Leave blank to target all tabs.
  3. Orientation:  Portrait, Landscape, or     leave blank for no change.
  4. N Pages Wide: for     example, use 1 to fit into 1 page wide.  Leave blank for no effect.
  5. N Pages Tall:     for example, use 1 to fit into 1 page tall.  Leave blank for no effect.
  6. Left Margin: in     inches.  For example, 0.25.  Leave blank for no effect.
  7. Right Margin: in     inches.  For example, 0.25.  Leave blank for no effect.
  8. Top Margin: in     inches.  For example, 0.25.  Leave blank for no effect.
  9. Bottom Margin:     in inches.  For example, 0.25.  Leave blank for no effect.
  10. Header Margin:     in inches.  For example, 0.25.  Leave blank for no effect.
  11. Footer Margin:     in inches.  For example, 0.25.  Leave blank for no effect.
  12. Center Horizontally:     Y for Yes.  Any other value,     including blank, for no effect.  
  13. Center Vertically:     Y for Yes.  Any other value,     including blank, for no effect.  
  14. Print Grid Lines:     Y for Yes.  Any other value,     including blank, for no effect.
Note: you can use field or formula names (from the Crystal Report) within thecommand line arguments.  
The dynamic content of these fields/formulas would be substituted into thecommand line.
For example (all in one line):
"XLS_Print_Setup:c:\temp\{Customer.Country}.xls>>>1>1>>>>>>>>>"
0
 
ShamanthAuthor Commented:
I can't use any third party tools. Thanks for your help though..
0
 
mlmccCommented:
Since the third-party tool is a viable (though not necessarily for you) solution, you really should include that comment in the split of points.

mlmcc
0
All Courses

From novice to tech pro — start learning today.