VS.Net + Cr.Net and VB.Net 
Author Message
 VS.Net + Cr.Net and VB.Net

Hi!

VisualS.Net VB+CR.Net

Problem with  CrystalReports (maybe with me)

MSDN shows example how to work with SetDataSource and  CrystalReportViewer1

Made small prog:
-----------START CODE ----------------------

crReportDocument = New CrystalReport1()

Dim eConnect As OleDbConnection

Dim strConn As String = ConfigurationSettings.AppSettings("String")

Dim strSQL As String

Dim eAdapter As OleDbDataAdapter

Dim eDataset As DataSet

strSQL = "SELECT Keyname," _

& "Fiel1," _

& "Fiel2 " _

& "FROM myTable" _

& "WHERE Keyname = 'A'"

eConnect = New OleDbConnection(strConn)

eAdapter = New OleDbDataAdapter(strSQL, eConnect)

eDataset = New DataSet()

eAdapter.Fill(eDataset, "myTable")

crReportDocument.SetDataSource(eDataset)

Dim objdv As New DataView(eDataset.Tables("WIEstatesList"))

DataGrid1.DataSource = objdv

DataGrid1.DataBind()

CrystalReportViewer1.ReportSource = crReportDocument

-----------------------END CODE -------------------------

Grid on Web forme shows DataSet has only one record but CrystalReportViewer1
shows all records from myTable.

What is problem, how to solve?



Sun, 26 Sep 2004 09:19:47 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Find good book about using CR.NET with VS.NET and .NET Framework

2. VS .NET 2002 upgrade to 2003 and CR.NET

3. CR .Net is bundled with VS .Net?

4. Memory not released with vb.net and cr.net

5. LogOnInfo for CR.net repor viewer and VB.net

6. CR.Net with VB.Net

7. VB.NET & CR.NET : User Defined Function

8. VB.NET application and CR.NET - Change grouping method at runtime

9. VS.NET 2003 project back to VS.NET 2002

10. VS.Net Version vs .Net Framework version

11. Upgrading to VS.Net 2003 from VS.Net 2002

 

 
Powered by phpBB® Forum Software