Skip to Content
0
Former Member
Nov 11, 2012 at 07:17 AM

Get Field Value from Crystal Report Into Vb.net

645 Views

Hi

How i get the field value from crystal report into my vb.net variable

here in crystal report

1) I binded with a Typed Dataset using a view

2 )Done Grouping in crystal report

3)am doing some calculations in GroupFooter and Report Footer using formula fields and RunningTotal Fields,

calculating

GroupTotalGroupDiscount,GroupTotalAmount in GroupFooter

Total , TotalDiscount, TotalAmount in ReportFooter

and i want to save these values in database table tbl_Invoice and after saving a row in table a invoiceId will generated

and i want to show this Id in Report.

Can i get value and pass Invoice Id to report after setData source

 CrystalReportViewer1.ReportSource = Report

 If Not ds Is Nothing Then 
If ds.Tables(0) IsNot Nothing Then
 If ds.Tables(0).Rows.Count > 0 Then
 Dim Report As ReportDocument = New ReportDocument 
Report.Load(System.Windows.Forms.Application.StartupPath & "/Reports/" & rptName)  Report.SetDataSource(ds)
CrystalReportViewer1.ReportSource = Report
Me.Panel1.Controls.Add(CrystalReportViewer1) 
Return True
 End If
End If 
End If