Solved

Scaling Fit to page -  excel export

Posted on 2010-08-13
11
1,116 Views
Last Modified: 2013-11-16
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?
0
Comment
Question by:Shamanth
  • 5
  • 4
  • 2
11 Comments
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
ID: 33434500
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
 

Author Comment

by:Shamanth
ID: 33436429
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
 
LVL 100

Expert Comment

by:mlmcc
ID: 33436862
Are you trying to change how the Excel sheet looks after you do the export?

mlmcc
0
3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

 
LVL 22

Expert Comment

by:Ido Millet
ID: 33439159
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
 

Author Comment

by:Shamanth
ID: 33440935
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
 
LVL 100

Assisted Solution

by:mlmcc
mlmcc earned 500 total points
ID: 33457819
I believe you will have to use an application or 3rd-party tool to control that after the sheet is created.

mlmcc
0
 

Author Comment

by:Shamanth
ID: 33461227
Yes.. BOBJ just confirmed that it is not possible. I have been talking to several tech people regarding this.  Thanks  though..
0
 

Author Closing Comment

by:Shamanth
ID: 33461235
thanks..
0
 
LVL 22

Expert Comment

by:Ido Millet
ID: 33464301
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
 

Author Comment

by:Shamanth
ID: 33465107
I can't use any third party tools. Thanks for your help though..
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 33467048
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

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Suggested Solutions

Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

822 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