VB and Crystal Report

[bidra]

Hi !

Is there any possibility to transfer the value of a VB variable data field to CR so it can be used in formula field there ?I am using VB6 and CR 8.5.

Thanks for any help !

Bidra

 

[inncoggnitto]

here is an example of sending two dates from a vb form to crystal reports. it works the same for text boxes etc. you can also send multiple values, like lists from listviews.

hope this helps

Option Explicit
Dim varCRAXDRT_App2 As New CRAXDRT.Application
Dim varCRAXDRT_Rpt2 As New CRAXDRT.Report

Private Sub Form_Load()
'varCRAXDRT_App2 = varCRAXDRT_App
'varCRAXDRT_Rpt2 = varCRAXDRT_Rpt
Dim i
i = 0


Select Case varReportCase
Case "ProgDates"
Set varCRAXDRT_Rpt2 = varCRAXDRT_App2.OpenReport(varReportFileName)
varCRAXDRT_Rpt2.Database.Tables.item(1).SetLogOnInfo "yoda", "", varSYSTEM_USERID, varPASSWORD
varCRAXDRT_Rpt2.ParameterFields(1).AddCurrentValue varStartDate
varCRAXDRT_Rpt2.ParameterFields(2).AddCurrentValue varEndDate
varCRAXDRT_Rpt2.PrinterSetup frmSelectReport.hWnd
frmCrystalViewer.Zoom (85)
frmCrystalViewer.ReportSource = varCRAXDRT_Rpt2
frmCrystalViewer.ViewReport
Set varCRAXDRT_Rpt2 = Nothing