passing ADO recordset to Crystal Reports in ASP

[dokken]

I have a SQL server 2000 database. I understand that I cannot use NT authentication to connect to a database in CR. I thought I could open a recordset and set the report database to the recordset. Has anybody done this?

Thanks,
Paul

 

[Guest_imported]

Try something like this


Set RS = MyConn.Execute("Select * From XYZ&quot


reportname = "Report1.rpt"

If Not IsObject (session("oApp&quot) Then

Set session("oApp&quot = Server.CreateObject("Crystal.CRPE.Application&quot
End If

Path = Request.ServerVariables("PATH_TRANSLATED&quot
While (Right(Path, 1) <> &quot;\&quot; And Len(Path) <> 0)
iLen = Len(Path) - 1
Path = Left(Path, iLen)
Wend

If IsObject(session(&quot;oRpt&quot) then
Set session(&quot;oRpt&quot = nothing
End if

Set session(&quot;oRpt&quot = session(&quot;oApp&quot.OpenReport(path & reportname, 1)


set Database = session(&quot;oRpt&quot.Database

set Table = Database.Tables.Item(1)
Table.SetPrivateData 3, Rs