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?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

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
mlmccCommented:
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
DB Reporting Tools

From novice to tech pro — start learning today.