Saving crystal a report to an sql server databse

[Guest_imported]

Can anyone tell me how to export a report into a diffrent format for example a word doc and then save this directly into a sql server database. I am using crystal reports version 8 and sql server 7

My code to date is below

Sub ReportSave()

If Not isObject(session("oApp&quot) Then
Set session("oApp&quot = Server.CreateObject("CrystalRunTime.Application&quot
End If


If isObject (session("oRpt&quot) Then
Set oRpt = Nothing
End If

Set session("oRpt&quot = session("oApp&quot.OpenReport("\\Wax116\catch22\Reports\test.rpt",1)

session("oRpt&quot.MorePrintEngineErrorMessages = false
session("oRpt&quot.EnableParameterPrompting = false

Set session("ExportOptions&quot = session("oRpt&quot.ExportOptions

session("exportfilename&quot = "gaz"
session("ExportOptions&quot.diskfilename = session("exportfilename&quot
session("ExportOptions&quot.formattype = cint(14)
session("ExportOptions&quot.destinationtype=1
session("oRpt&quot.export false

set rs = server.createobject("adodb.recordset&quot
ssql = "insert into report(report)values('" & session("oPpt&quot & "')"
cn.execute sSQL
End Sub

cheers

gaz

 

[kenhamady]

>> for example a word doc and
>> then save this directly
>> into a sql server database

save what? Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)