Solved

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

Posted on 2004-08-17
6
303 Views
Last Modified: 2010-04-23
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
Comment
Question by:meharmahmood
  • 2
6 Comments
 
LVL 70

Accepted Solution

by:
Éric Moreau earned 250 total points
ID: 11830209
0
 
LVL 2

Expert Comment

by:ahmadfuwad
ID: 12083738
'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
 
LVL 70

Expert Comment

by:Éric Moreau
ID: 12271111
Points to emoreau
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

A while ago, I was working on a Windows Forms application and I needed a special label control with reflection (glass) effect to show some titles in a stylish way. I've always enjoyed working with graphics, but it's never too clever to re-invent …
Since .Net 2.0, Visual Basic has made it easy to create a splash screen and set it via the "Splash Screen" drop down in the Project Properties.  A splash screen set in this manner is automatically created, displayed and closed by the framework itsel…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question