Crystal Report Problem

  • Thread starter Thread starter Michael Chong
  • Start date Start date
M

Michael Chong

How can I change the sql query in my crystal report document during runtime?

TQ
Michael.
 
My problem is the report doesn't follow as my code below, it just follow
whatever I have set during the design time. How do I override the existing
query. My following codes are as follow:

Dim StrSQL As String

StrSQL = "SELECT cRef FROM TblCaveat WHERE ID = 2"

Dim da1 As OleDb.OleDbDataAdapter

da1 = New OleDb.OleDbDataAdapter(StrSQL, OleDbConnCaveat)

Dim ds As DataSet

ds = New DataSet("DataSetTmp")

da1.Fill(ds, "DataSetTmp")

RPT.SetDataSource(ds)

RPT.Database.Tables(0).SetDataSource(ds)

CrystalReportViewer1.ReportSource = RPT
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Crystal Viewer - Changing Parameters 2
Pass changing values to parameter to Crystal Report scroll thru re 3
Crystal Report Error : the maximum report processing jobs limitconfigured by your system administrat 1
Report tool for asp.net web forms 1
Crystal Reports options 1
Crystal Report 1
Crystal Report load method problem in VS2005 1
Different Assemblies At Runtime 3

Back
Top