Hi

How can I pass the formula in Crystal Report 10 in VB.Net. Without formula I am using this method to call the crystal report.

Can anybody guide me how to pass the formula :
VB Code:
  1. Dim fSalesReportViewer As frmSalesReportViewer = New frmSalesReportViewer
  2. Dim gl_conReport As OleDb.OleDbConnection
  3. Dim ConString As String
  4. ConString = "Provider=sqloledb;Data Source=server;Initial Catalog=test;User Id=sa;Password=;"
  5. gl_conReport = New OleDb.OleDbConnection(ConString)
  6. gl_conReport.Open()
  7. Dim CrReport As CrystalDecisions.CrystalReports.Engine.ReportDocument = New CrystalDecisions.CrystalReports.Engine.ReportDocument
  8. Dim QueryString As String = "select * from CompanyMaster"
  9. Dim CrAdapter As OleDbDataAdapter = New OleDbDataAdapter(QueryString, gl_conReport)
  10. Dim CrDataSet As DataSet = New DataSet
  11. fSalesReportViewer.MdiParent = MainForm
  12. CrAdapter.Fill(CrDataSet)
  13. Dim CrDataTable As DataTable = New DataTable
  14. CrDataTable = CrDataSet.Tables(0)
  15. CrReport.Load(Application.StartupPath & "\Reports\CompanyReport.rpt")
  16. CrReport.Refresh()
  17. CrReport.SetDataSource(CrDataTable)
  18. fSalesReportViewer.ReportViewerSales.ReportSource = CrReport
  19. fSalesReportViewer.Show()

thanks

asm