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

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

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.