Hi all,
I've created the report with Seagate crystal reports with the source to the database through a stored procedure (with ODBC). The stored procedure contains input parameter that I want to sent it to this report from .Net through Crystal report Control Crystl32.ocx.
I installed this control into .net but I don't how can I pass the parameter which I'm writing into textbox to report that contains stored procedure as a data source.
== Some code with Crystl32.ocx that I'm using to call the report:
With cr2
.ReportFileName = Application.StartupPath + "\klient_info.rpt"
'.RetrieveStoredProcParams()
'.set_StoredProcParam(1, TextBox2.Text)
.DiscardSavedData = True
.RetrieveDataFiles()
'.ReportSource = 0
' .ReplaceSelectionFormula("@KlientID=" & TextBox2.Text)
.WindowState = crptMaximized
.Action = 3
End With
Means I simply want to pass this input parameter to this report that is actually input parameter of the stored procedure in the database.
Thanks,
ProBani.
I've created the report with Seagate crystal reports with the source to the database through a stored procedure (with ODBC). The stored procedure contains input parameter that I want to sent it to this report from .Net through Crystal report Control Crystl32.ocx.
I installed this control into .net but I don't how can I pass the parameter which I'm writing into textbox to report that contains stored procedure as a data source.
== Some code with Crystl32.ocx that I'm using to call the report:
With cr2
.ReportFileName = Application.StartupPath + "\klient_info.rpt"
'.RetrieveStoredProcParams()
'.set_StoredProcParam(1, TextBox2.Text)
.DiscardSavedData = True
.RetrieveDataFiles()
'.ReportSource = 0
' .ReplaceSelectionFormula("@KlientID=" & TextBox2.Text)
.WindowState = crptMaximized
.Action = 3
End With
Means I simply want to pass this input parameter to this report that is actually input parameter of the stored procedure in the database.
Thanks,
ProBani.