0

Hi,
i have created a store procedure having 2 input parameters.
i am using this procedure in crystal report.
how can i send parametrs to crystal reports for input parametrs of store procedures using vb6
pl send some sample coding. its urgent.

Thanks in advance,
Vanathi.G

2
Contributors
2
Replies
3
Views
8 Years
Discussion Span
Last Post by schanglani
0

HI Vanathi.G
Here is the code to pass parameters to Sql 2000 from vb
With CrystralReport1
'1st Parameter to Sql 2000 from Vb Thru Crystal Reports
.StoredProcParam(0) = txtStartDate.DateValue
'2nd Parameter to Sql 2000 from Vb Thru Crystal Reports
.StoredProcParam(1) = txtEndDate.DateValue
'3rd Parameter to Sql 2000 from Vb Thru Crystal Reports
.StoredProcParam(2) = HostName
'4th Parameter to Sql 2000 from Vb Thru Crystal Reports
.StoredProcParam(3) = IIf(chkAllCompanies.Value = 1, "Y", "N")
'.... so on
End with

0

Hi
Can anyone help me with sample code for calling Crystal Reports XI
From VB 6 (along with inculding References & Components in the vb project)

Thanks in advance
Satish Changlani

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.