Member Avatar for vanathi_vb

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
  • 93 Views
  • 3 Days Discussion Span
  • Latest Post Latest Post by schanglani
Member Avatar for schanglani

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

Member Avatar for schanglani

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.