How to Generate the Report at Runtime

Hi,
Can someone help me about how can i generate the report at run time.



Cheers

What type of reports are you wanting info on? Crystal Reports, Access Reports, or the Data Environment?

Quote:

---

Originally Posted by M.Zafar Iqbal

Hi,
Can someone help me about how can i generate the report at run time.



Cheers

---

What are you using for a front end? VB6? VB.NET? C#? What, if any, database are you using?

i am using

vb6 + Crystal Reports

What verision of Crystal?

Vb6
crystal report v8.0
and
Sql Server 2000

I have an example in my signature - "VB6/Crystal Reports Ex."

i didn't found ?
can u plz send the link ?

Hi,
after i found it
you have placed this code there


Dim oApp As CRAXDRT.Application
Dim oReport As CRAXDRT.Report
Dim oRs As ADODB.Recordset
Dim sSQL As String

sSQL = "SELECT * FROM Table1"
Set oRs = New ADODB.Recordset
Set oRs = oCnn.Execute(sSQL)
Set oApp = New CRAXDRT.Application
Set oReport = oApp.OpenReport(App.Path & "\MyReport.rpt", 1)
oReport.Database.SetDataSource oRs, 3, 1
crvMyCRViewer.ReportSource = oReport
crvMyCRViewer.ViewReport

you passed the recordset to the report
is there a way to pass the date using loop
in other words can i pass the fields to report at runtime.


Cheers