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:
Dim fSalesReportViewer As frmSalesReportViewer = New frmSalesReportViewer Dim gl_conReport As OleDb.OleDbConnection Dim ConString As String ConString = "Provider=sqloledb;Data Source=server;Initial Catalog=test;User Id=sa;Password=;" gl_conReport = New OleDb.OleDbConnection(ConString) gl_conReport.Open() Dim CrReport As CrystalDecisions.CrystalReports.Engine.ReportDocument = New CrystalDecisions.CrystalReports.Engine.ReportDocument Dim QueryString As String = "select * from CompanyMaster" Dim CrAdapter As OleDbDataAdapter = New OleDbDataAdapter(QueryString, gl_conReport) Dim CrDataSet As DataSet = New DataSet fSalesReportViewer.MdiParent = MainForm CrAdapter.Fill(CrDataSet) Dim CrDataTable As DataTable = New DataTable CrDataTable = CrDataSet.Tables(0) CrReport.Load(Application.StartupPath & "\Reports\CompanyReport.rpt") CrReport.Refresh() CrReport.SetDataSource(CrDataTable) fSalesReportViewer.ReportViewerSales.ReportSource = CrReport fSalesReportViewer.Show()
thanks
asm




Reply With Quote