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
ViewerXI.CrystalActiveXReportViewer1.ReportSource = CrystalReport1
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
I would appreciate your help in this regard.
Thanks in advance