Export Dialog box

[crystalline]

How do I get the export button (with the web activex viewer ) to open the "Export Report to File, Mail.." Dialog box that has the two select boxes for Format and Destination instead of the "Report Viewer Export" Dialog which is the windows file save as Dialog box..

Thanks.

 

[jfrost10]

Hi crystalline,

There should be a property that you change for "export button enabled".

If that doesn't fix it though, the only way I found around it was to create a seperate button and put in the code manually (I'm guessing you're doing this in vb?). We determined that we only needed to export to excel, so we hardcoded some values:

Report.ExportOptions.DestinationType = crEDTDiskFile
Report.ExportOptions.FormatType = crEFTExcel70Tabular
'We've opted to save all files to the desktop (the user can move them from there)
Report.ExportOptions.DiskFileName = "c:\Documents and Settings\All Users\Desktop\" & strFileName & ".xls"

What you can do though if you want to be able to have the user select is to create a dialog form and create the option buttons, etc. yourself and then just associate the Report.ExportOptions variables to them.

There may be an easier way to do it, but I havn't found one..not even with replies from other people on this board.

Let me know if I can help further,

Jack

 

[crystalline]

Thanks for the reply. But I'm using ASP and calling the ActiveX viewer??

 

[balves]

If you have used the sample code from Crystal, you should have a file SmartViewerActiveX.asp in your InterDev project with code like this. You can set the options via PARAM NAME.

<OBJECT ID=&quot;CRViewer&quot;
CLASSID=&quot;CLSID:C4847596-972C-11D0-9567-00A0C9273C2A&quot;
WIDTH=100% HEIGHT=95%
CODEBASE=&quot;/viewer/activeXViewer/activexviewer.cab#Version=2,2,4,28&quot;>
<PARAM NAME=&quot;EnableRefreshButton&quot; VALUE=1>
<PARAM NAME=&quot;EnableGroupTree&quot; VALUE=1>
<PARAM NAME=&quot;DisplayGroupTree&quot; VALUE=1>
<PARAM NAME=&quot;EnablePrintButton&quot; VALUE=1>
<PARAM NAME=&quot;EnableExportButton&quot; VALUE=1>
<PARAM NAME=&quot;EnableDrillDown&quot; VALUE=1>
<PARAM NAME=&quot;EnableSearchControl&quot; VALUE=1>
<PARAM NAME=&quot;EnableAnimationControl&quot; VALUE=1>
<PARAM NAME=&quot;EnableZoomControl&quot; VALUE=1>
</OBJECT> Brian J. Alves
Terrier Consulting, Inc.
Email: brian.alves@worldnet.att.net
VB / Crystal / SQLServer

 

[crystalline]

Thanks, I did that.
The thing is, it opens the &quot;Save Report as&quot; Dialog box, I need it to open the &quot;Export Report&quot; Dialog box, like it does in VB, where you get the &quot;Format&quot; and &quot;Destination&quot; select boxes.

I need to be able to email the report on clicking the export button.

 

[balves]

Perhaps that's the way it is intended to work on the web. If you run the demo on the Crystal Decisions web site for web reporting and try to export the Xtreme report, you get the Save As dialog box.

It never came up on my Crystal / Web project because we disabled the export function for business/security reasons. Brian J. Alves
Terrier Consulting, Inc.
Email: brian.alves@worldnet.att.net
VB / Crystal / SQLServer