none
Get Field Value from Crystal Report Into Vb.net RRS feed

  • Question

  • 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


    adil

    • Moved by Jie Bao Monday, November 19, 2012 3:37 AM (From:Visual Basic General)
    Sunday, November 11, 2012 7:17 AM

All replies