How to Generate the Report at Runtime

[M.Zafar Iqbal]

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



Cheers

[RobDog888]

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

[Hack]

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?

[M.Zafar Iqbal]

i am using

vb6 + Crystal Reports

[Hack]

What verision of Crystal?

[M.Zafar Iqbal]

Vb6
crystal report v8.0
and
Sql Server 2000

[RobDog888]

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

[M.Zafar Iqbal]

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

[M.Zafar Iqbal]

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