asked on

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?

ASKER CERTIFIED SOLUTION

Mike McCracken

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Shamanth

ASKER

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.

Mike McCracken

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

mlmcc

Ido Millet

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.

Shamanth

ASKER

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.

SOLUTION

Mike McCracken

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Shamanth

ASKER

Yes.. BOBJ just confirmed that it is not possible. I have been talking to several tech people regarding this. Thanks though..

Shamanth

ASKER

thanks..

Ido Millet

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 WorkbooksYou 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:

Excel_File: the full path and name of the excel file.
Tab: the tab (sheet) name. Use 1 to target the first tab. Leave blank to target all tabs.
Orientation: Portrait, Landscape, or leave blank for no change.
N Pages Wide: for example, use 1 to fit into 1 page wide. Leave blank for no effect.
N Pages Tall: for example, use 1 to fit into 1 page tall. Leave blank for no effect.
Left Margin: in inches. For example, 0.25. Leave blank for no effect.
Right Margin: in inches. For example, 0.25. Leave blank for no effect.
Top Margin: in inches. For example, 0.25. Leave blank for no effect.
Bottom Margin: in inches. For example, 0.25. Leave blank for no effect.
Header Margin: in inches. For example, 0.25. Leave blank for no effect.
Footer Margin: in inches. For example, 0.25. Leave blank for no effect.
Center Horizontally: Y for Yes. Any other value, including blank, for no effect.
Center Vertically: Y for Yes. Any other value, including blank, for no effect.
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>>>>>>>>>"

Shamanth

ASKER

I can't use any third party tools. Thanks for your help though..

Mike McCracken

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