<div>
Look at this thread:<br />
<a href="http://support.businessobjects.com/library/kbase/articles/c2016289.asp" rel="ugc">http://support.businessobjects.com/library/kbase/articles/c2016289.asp</a><br />
<br />
Spykair
</div>


<div>
Really appreciate if someone can convert dylanyee code into VB. Thanks.
</div>


<div>
m_Report.ExportOptions.Exp<wbr />ortFormatT<wbr />ype = ExportFormatType.Excel<br />
<br />
The of &quot;ExportFormatType&quot; of &quot;ExportFormatType.Excel&quot; gave error of variable not defined.<br />

</div>


<div>
You may need to include additional dlls or VB may use different constants. &nbsp;<br />
<br />
If you delete Excel and the . then add the . do you get a list?<br />
<br />
mlmcc
</div>


<div>
I think ExportFormatType is reference from CrystalDecision.shared dll, I can't figure it out now since I am away from my office currently.<br />
<br />
dylan
</div>


<div>
&quot;If you delete Excel and the . then add the . do you get a list?&quot;<br />
<br />
NO
</div>


<div>
ExportFormatType is reference from CrystalDecisions.Shared.<br />
CrystalDecisions.Shared.Ex<wbr />portFormat<wbr />Type<br />
Could you try add a reference to CrystalDecisions.Shared.dl<wbr />l and add Import CrystalDecisions.Shared to your code?<br />
<br />
dylan
</div>


<div>
Glad i could help<br />
<br />
mlmcc
</div>


<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I am using VB and Crystal Report XI. May I know how can I export crystal report directly to excel once it's generated?<br />
<br />
I know if I want it to be print, I can call this<br />
CRViewer1.PrintReport<br />
<br />
Is there anything that I can do to export to excel?<br />
<br />
Please advice. Thanks.
</div>
</div>


Hi,

I am using VB and Crystal Report XI. May I know how can I export crystal report directly to excel once it's generated?

I know if I want it to be print, I can call this
CRViewer1.PrintReport

Is there anything that I can do to export to excel?

Please advice. Thanks.

Look at this thread:
http://support.businessobjects.com/library/kbase/articles/c2016289.asp

Spykair

Really appreciate if someone can convert dylanyee code into VB. Thanks.

m_Report.ExportOptions.ExportFormatType = ExportFormatType.Excel

The of &amp;quot;ExportFormatType&amp;quot; of &amp;quot;ExportFormatType.Excel&amp;quot; gave error of variable not defined.


You may need to include additional dlls or VB may use different constants.  

If you delete Excel and the . then add the . do you get a list?

mlmcc

I think ExportFormatType is reference from CrystalDecision.shared dll, I can&amp;#39;t figure it out now since I am away from my office currently.

dylan

&amp;quot;If you delete Excel and the . then add the . do you get a list?&amp;quot;

NO

ExportFormatType is reference from CrystalDecisions.Shared.
CrystalDecisions.Shared.ExportFormatType
Could you try add a reference to CrystalDecisions.Shared.dll and add Import CrystalDecisions.Shared to your code?

dylan

Directlly Export crystal report to an Excel file

Hi,

I am using VB and Crystal Report XI. May I know how can I export crystal report directly to excel once it&amp;#39;s generated?

I know if I want it to be print, I can call this
CRViewer1.PrintReport

Is there anything that I can do to export to excel?

Please advice. Thanks.

Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.