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