<div>
'this is the right way for showing data in crystal report and dataset or datagrid cant sent to <br />
'report directly<br />
<br />
<br />
&nbsp; cn.ConnectionString = &quot;Server=eteam08;Database=d<wbr />bTestGrid;<wbr />user id=sa;password=imran&quot;<br />
&nbsp; &nbsp; &nbsp; &nbsp; cn.Open()<br />
<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; cmd1.Connection = cn<br />
&nbsp; &nbsp; &nbsp; &nbsp; cmd1.CommandType = CommandType.Text<br />
&nbsp; &nbsp; &nbsp; &nbsp; cmd1.CommandText = &quot;select * from tblCustomer&quot;<br />
&nbsp; &nbsp; &nbsp; &nbsp; oda1.SelectCommand = cmd1<br />
&nbsp; &nbsp; &nbsp; &nbsp; oda1.Fill(ods, &quot;Customer&quot;)<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; Dim rpt As New CrystalReport1<br />
&nbsp; &nbsp; &nbsp; &nbsp; rpt.SetDataSource(ods.Tabl<wbr />es(&quot;Custom<wbr />er&quot;))<br />
&nbsp; &nbsp; &nbsp; &nbsp; CrystalReportViewer1.Repor<wbr />tSource = rpt
</div>


'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

<div>
<div class="content wysiwyg-content">
It will apprecaite if someone can tell how i can pass, dataset or dataview or a datatable to crystal report directly. &nbsp;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.<br />
thanks in advance
</div>
</div>


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

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

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,