Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Crystl32.ocx with vb .net

Status
Not open for further replies.

ProBani

Programmer
Mar 21, 2005
48
YU
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.
 
As you were told last time this is the VB6 forum. Please read faq222-2244 to understand how these forums work

Try here for VB.NET: forum796

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top