• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 325
  • Last Modified:

Is it possible to send dataset,datatable directly to crystal report

It will apprecaite if someone can tell how i can pass, dataset or dataview or a datatable to crystal report directly.  I m having one calculated table on my form. i want to print that table data through crystal report. So how is it possible to send that table to crystal report directly instead of saving on server and then crystal report fetch data from server.
thanks in advance
0
meharmahmood
Asked:
meharmahmood
  • 2
1 Solution
 
Éric MoreauSenior .Net ConsultantCommented:
0
 
ahmadfuwadCommented:
'this is the right way for showing data in crystal report and dataset or datagrid cant sent to
'report directly


  cn.ConnectionString = "Server=eteam08;Database=dbTestGrid;user id=sa;password=imran"
        cn.Open()


        cmd1.Connection = cn
        cmd1.CommandType = CommandType.Text
        cmd1.CommandText = "select * from tblCustomer"
        oda1.SelectCommand = cmd1
        oda1.Fill(ods, "Customer")

        Dim rpt As New CrystalReport1
        rpt.SetDataSource(ods.Tables("Customer"))
        CrystalReportViewer1.ReportSource = rpt
0
 
Éric MoreauSenior .Net ConsultantCommented:
Points to emoreau
0

Featured Post

[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now