Hi,

I am stuck in passing values to a report at run time to SQLQueryString,

I am using the below code
dim strsql as string ' run time query

Set CrystalReport1 = Application.OpenReport(App.Path & "\Reports\" & "test.rpt")
CrystalReport1.Database.LogOnServer "crdb_oracle.dll", strDsnServer, "", strDsnUser, strDsnPwd
  CrystalReport1.DiscardSavedData
  CrystalReport1.SQLQueryString=strsql
ViewerXI.CrystalActiveXReportViewer1.ReportSource = CrystalReport1
ViewerXI.CrystalActiveXReportViewer1.ViewReport



I could able to run query which is present in the report, but not the user selected values i.e. unable to pass the query at run time.

I am using Crystal XI with VB 6.0


I would appreciate your help in this regard.

Thanks in advance