MOH_RTC


Hello

I would like to use ReportExecution2005.asmx to render a report stored on a SQL Server 2005.

How may I code this VisualBasic source example in Access VBA

Private Sub renderReport(ByVal sReportname as string, ByVal sOutputfilename as string)

rs.LoadReport(sReportname, Nothing)

Dim results() as [Byte]

results = rs.Render("PDF", "", "", "", "", Nothing, Nothing)

Dim stream as System.io.Filestream = System.IO.File.OpenWrite(sOutputfilename)

stream.Write(results, 0, results.Length)

stream.Close()

End Sub

Thank you for any help.

MOH