The Creator on the viewer form has been overridden so that the DataSet can be sent to it.  So, the creator looks like this:

private BOEUserAuditRpt auditRpt;

public BOEAuditRptViewer(DataSet dsAuditInfo)
{
  InitializeComponent();
  auditRpt = new BOEUserAuditRpt();
  auditRpt.SetDataSource(dsAuditInfo);
  auditRptViewer.ReportSource = auditRpt;
}

 

 

private void RunReport()
{
  BOEAuditRptViewer viewer = new BOEAuditRptViewer(dsAuditInfo);
  viewer.Show();
}

 

-Dell

 

I'm suffering from the same problem. . . 

 

I've been unsuccessfully trying to get a report working in a Windows Forms app that I am working on in VS2005/VB.NET.

 

In the end, I decided to try getting it to work using the tutorial data (VB_Win_Data_DataSets).  This worked fine with the xtreme.mdb.  I then created a new dataset schema pointing it at a simple Stored Procedure "SELECT * FROM tblCustomer" in the production SQL Server database.  The data previewed ok.  I then created a new report which simply displayed the data, without any sorting, grouping or filtering.  Finally, I substituted the code in the CustomerDataSet property in the DataSetConfiguration class. 

 

The "myDataSet" dataset is populated (I can iterate thru it and display the data) prior to the customerReport.SetDataSource call.  As with other folks, the report headers are displayed but no data and only a single page. . .

 

Has anyone got any bright ideas please?

 

Best regards

 

Mike W

 

 

 

The code I am using is the standard tutorial sample code in VB_Win_Data_DataSets.

 

Public Class Form1

    Private customerReport As ReportDocument

    Private Sub ConfigureCrystalReports()
        customerReport = New ReportDocument()
        Dim reportPath As String = Application.StartupPath & "\" &  

                                                                                        "Customer.rpt" 

        ' My version of the report displays the CustomerId and name.
        customerReport.Load(reportPath)
        Dim myDataSet As DataSet = DataSetConfiguration.CustomerDataSet

        ' I have placed code to iterate thru myDataSet here and it's

        ' populated with the correct data.

        customerReport.SetDataSource(myDataSet)
        myCrystalReportViewer.ReportSource = customerReport

    End Sub

 

    Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As

                                               System.EventArgs) Handles MyBase.Load
        ConfigureCrystalReports()
    End Sub
End Class

The only code changes I have made are to the DataSetConfiguration class.

I use the Enterprise Library, both here and in the app I'm developing to populate the dataset and it works fine.

 

 

Imports System.Data
Imports System.Data.OleDb
Imports Microsoft.Practices.EnterpriseLibrary.Data
Imports Microsoft.Practices.EnterpriseLibrary.Common
Public Class DataSetConfiguration

    Public Shared ReadOnly Property CustomerDataSet() As DataSet
        Get
            Dim dsCustomer As DataSet = Nothing
            Try

                Dim db As Microsoft.Practices.EnterpriseLibrary.Data.Database=

Microsoft.Practices.EnterpriseLibrary.Data.DatabaseFactory.CreateDatabase

                Dim sqlCommand As String = "sel_EBCustomer"
                Dim dbCommand As System.Data.Common.DbCommand = db.GetStoredProcCommand(sqlCommand)

                dsCustomer = db.ExecuteDataSet(dbCommand)

            Catch ex As Exception
                MsgBox(ex.Message)
            End Try
            Return dsCustomer
        End Get
    End Property

 

End Class

 

Best regards

 

Mike

 

Best regards

 

Mike