Urgent !!! data directly from datagrid to crystal report

[masqazi]

i want to create a report in crsytal report, which should show data present in grid of a vb form, (not from the data base as we do usually).... how to do this???

[Hack]

How does the data get into the grid?

[masqazi]

I will explain it further..

data is in database, we get it into a recordset and then put into the grid...the only important thing is that we apply a complicated formula to modifiy the data in recordset before populating the grid..and the formula can change depending of several factors....

our exact requirement is to just print the contents of the grid as a report.

[anguswalker]

According to their website you can use the .SetPrivateData method to pass a ADO recordset to the crystal report. This is the code they give (the crucial bit is in red):
'General Declarations
Dim crpApplication As CRPEAuto.Application
Dim crpReport As CRPEAuto.Report
Dim crpDatabase As CRPEAuto.Database
Dim crpTables As CRPEAuto.DatabaseTables
Dim crpTable As CRPEAuto.DatabaseTable
Dim adoRs As ADODB.Recordset

Private Sub Form_Load()
Set crpApplication = CreateObject("crystal.crpe.application")
End Sub

Private Sub Command1_Click()

'Now that the report has been created, we can set the report
'object to it (open the report)

Set crpReport = crpApplication.OpenReport(App.Path & "\test.rpt")

'We need to set the database, database tables and database table
'to get to the method that we need: SetPrivateData

Set crpDatabase = crpReport.Database
Set crpTables = crpDatabase.Tables
Set crpTable = crpTables.Item(1)

'SetPrivateData sets the report data to the recordset in memory
'assuming the adoRS has been populated somewhere in the application

Call crpTable.SetPrivateData(3, adoRs)
crpReport.Preview

End Sub

[masqazi]

thanks a lot !

do we need some references, dll , etc to use crpe...further can u put some ore light on crpe.