Solved

Scaling Fit to page -  excel export

Posted on 2010-08-13
11
1,097 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
Comment Utility
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
Comment Utility
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
Comment Utility
Are you trying to change how the Excel sheet looks after you do the export?

mlmcc
0
 
LVL 22

Expert Comment

by:Ido Millet
Comment Utility
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
Comment Utility
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
Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

 
LVL 100

Assisted Solution

by:mlmcc
mlmcc earned 500 total points
Comment Utility
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
Comment Utility
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
Comment Utility
thanks..
0
 
LVL 22

Expert Comment

by:Ido Millet
Comment Utility
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
Comment Utility
I can't use any third party tools. Thanks for your help though..
0
 
LVL 100

Expert Comment

by:mlmcc
Comment Utility
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

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Problem Statement In an SAP BI BO Integration project when a BO universe is built on a BEx query, there can be an issue of unit & formatted value objects not getting generated in a BO universe for some key figures. This results in an issue whereb…
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…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

771 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now