VB 6.0/Crystal Reports
-
I am sick of using Data Environment for creating reports through VB 6.0 so I wanted to know the exact method with full detail as to how can we make use of crystal reports through VB6.0 for the creation of reports. Thanks & Regard, Indrojeet
Indrojeet Bhattacharya
-
I am sick of using Data Environment for creating reports through VB 6.0 so I wanted to know the exact method with full detail as to how can we make use of crystal reports through VB6.0 for the creation of reports. Thanks & Regard, Indrojeet
Indrojeet Bhattacharya
Hi, I dont know how to create crystal reports by using VB6. But i can help u for calling report from VB6. Here is a sample code gtRptDsn = "DSN = " & ServerName & ";UID = **; PWD=****" .Connect = gtRptDsn .Destination = crptToWindow .Destination = crptToPrinter in report function .ReportFileName = tcpath & "ReportName.rpt" //stored procedure parameters .StoredProcParam(0) = GiSbuid .StoredProcParam(1) = iProjectId .StoredProcParam(2) = iVendorId .StoredProcParam(3) = ICategoryId .StoredProcParam(4) = IGroupId .StoredProcParam(5) = IMaterialId //for header(like company name and addresss) use Fomula .Formulas(0) = "Company='" & GTEnterprise & "'" .Formulas(1) = "Add1='" & GTSbuAdd1 & "'" .Formulas(2) = "Add2='" & GTSbuADD2 & "'" // to show report RptQuotation.Action = 1 RptQuotationReport.PageZoom 100 // to make the report as a child of MDI form .WindowParentHandle = mdiFormMain.hwnd By Dileep I love my bug since she is my best friend.
-
Hi, I dont know how to create crystal reports by using VB6. But i can help u for calling report from VB6. Here is a sample code gtRptDsn = "DSN = " & ServerName & ";UID = **; PWD=****" .Connect = gtRptDsn .Destination = crptToWindow .Destination = crptToPrinter in report function .ReportFileName = tcpath & "ReportName.rpt" //stored procedure parameters .StoredProcParam(0) = GiSbuid .StoredProcParam(1) = iProjectId .StoredProcParam(2) = iVendorId .StoredProcParam(3) = ICategoryId .StoredProcParam(4) = IGroupId .StoredProcParam(5) = IMaterialId //for header(like company name and addresss) use Fomula .Formulas(0) = "Company='" & GTEnterprise & "'" .Formulas(1) = "Add1='" & GTSbuAdd1 & "'" .Formulas(2) = "Add2='" & GTSbuADD2 & "'" // to show report RptQuotation.Action = 1 RptQuotationReport.PageZoom 100 // to make the report as a child of MDI form .WindowParentHandle = mdiFormMain.hwnd By Dileep I love my bug since she is my best friend.
What all .dll references I need to add ?
Indrojeet Bhattacharya
-
I am sick of using Data Environment for creating reports through VB 6.0 so I wanted to know the exact method with full detail as to how can we make use of crystal reports through VB6.0 for the creation of reports. Thanks & Regard, Indrojeet
Indrojeet Bhattacharya
Indrojeet_Bhattacharya wrote:
so I wanted to know the exact method with full detail as to how can we make use of crystal reports through VB6.0 for the creation of reports.
If you want that much detail, read the documentation on Crystal Reports. Though I think all support has been dropped for VB6 in the lastest versions.
A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
2006, 2007