dreenaj
asked on
Knowing the right EXCEL export type to use
Hi Experts,
I wanted to export a 15-column report to EXCEL. I need some info on the following questions:
1. What excel export type will I use for excel 2000. I can also see excel2 to excel8. I'm using Crystal 8.5 running under MSSQL 2000.
2. I wanted to set the exported excel format be on Landscape (or maybe can switch from either portrait or landscape). I'm a bit confused because the RPT I designed will be printed (if the user prints it) in portrait orientation but when I export it to excel, it seems it won't fit anymore on portrait layout...and that it seems I need to change the orientation to landscape inorder to have all the columns printed on a single bond paper. Is there a way to do this?
Please show me a Delphi or VB code how to this if this is possible.
Thanks,
dreenaj
I wanted to export a 15-column report to EXCEL. I need some info on the following questions:
1. What excel export type will I use for excel 2000. I can also see excel2 to excel8. I'm using Crystal 8.5 running under MSSQL 2000.
2. I wanted to set the exported excel format be on Landscape (or maybe can switch from either portrait or landscape). I'm a bit confused because the RPT I designed will be printed (if the user prints it) in portrait orientation but when I export it to excel, it seems it won't fit anymore on portrait layout...and that it seems I need to change the orientation to landscape inorder to have all the columns printed on a single bond paper. Is there a way to do this?
Please show me a Delphi or VB code how to this if this is possible.
Thanks,
dreenaj
ASKER
Hi mlmcc,
It seems I can only use excel8 at my end.
Could this be a case of old export dll or something?
If this is the case, can you tell me where to download an update file that will support excel9?
dreenaj
It seems I can only use excel8 at my end.
Could this be a case of old export dll or something?
If this is the case, can you tell me where to download an update file that will support excel9?
dreenaj
Further research on the Crystal web site indicates Excel8 is the correct export engine for Excel 2000.
http://support.crystaldecisions.com/library/kbase/articles/c2009646.asp
mlmcc
http://support.crystaldecisions.com/library/kbase/articles/c2009646.asp
mlmcc
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
There is a PaperOrientation option on the CR object in VB.
With the Crystal Viewer the code is
CRobj.PaperOrientation = crLandscape
good luck
mlmcc