A Problem Working With Reports

[kaustav]

hi,

check out parameter passing.

[vbjohn]

In your VB Program do something like this...

sSql = "your query here"

Set Cn = CreateObject("ADODB.Connection")
Cn.CommandTimeout = 0
Cn.ConnectionTimeout = 0
Cn.Open sCon

Set Rst = CreateObject("ADODB.Recordset")
Rst.CursorLocation = adUseClient
Rst.Open sSql, Cn, adOpenStatic

Set DReport.DataSource = Rst

DReport.Sections("Section1").Controls("txtVOIDED").DataField = "VOIDED"
DReport.Sections("Section1").Controls("txtVENDORID").DataField = "VENDORID"
DReport.Sections("Section1").Controls("txtDOCNUMBR").DataField = "DOCNUMBR"
DReport.Sections("Section1").Controls("txtDOCAMNT").DataField = "DOCAMNT"
DReport.Sections("Section1").Controls("txtVCHRNMBR").DataField = "VCHRNMBR"

DReport.Show


'''And then on the DReport "Properties" change the DataSource to...."Rst" ''''

Any other questions please let me know!!!