Question Locked

Crystal report 6.0 connection string for sql server 2000 using vb 6.0

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

i am developing one application.In which i am using crystal report 6.0 ,sql server 2000 and vb6.0

My problem is:
Which connection string is used in vb 6.0 to connect crystal report with sql server ?

Please help me
It 's an urgent

Can any one help me for this?

3 replies

by clonyz

Dim Report as New CrystalReport1

Report.Database.Table(1).SetLogOnInfo "Server", "DBName", "User", "Pass"
CRViewer1.ViewReport

-->Try it..

by snair3

1. Create the Report using Crystal Report
1. Pick the Crystal Report object in VB form and write the following in the print button

VendorRep = "G:\Vbpie\reports\Vendorlist.rpt"

CrystalReport1.ReportFileName = VendorRep

CrystalReport1.Formulas(0) = "frmdate='" & Heading & "'"

StrSelectionFormula = "({Vendor.VDate} >= # " & xfrmdate & "#" & "and {Vendor.VDate} <= # " & xtodate & "#)"
CrystalReport1.ReplaceSelectionFormula (StrSelectionFormula)

CrystalReport1.Action = 1

This discussion is closed to new replies.