Environment: Microsoft Visual Studio Net
        Microsoft .NET framework 1.0
        Microsoft .NET framework 1.0
                        SQL Server 2000
                        Windows 2000 Pro
                         IIS Personal Web Server

I am having the dickens of a time generating a crystal report using a push method. The report (cfrEmp) exists in the .net solution as well as the dataset schema. I am using the following code to retrieve data from a stored procedure in a SQL database. I then use a dataadapter to populate a dataset (cfrEmpAll) which then becomes the datasource for the crystal report. The stored proc has set no counts on and has no parameters. The report will generate with field labels and report heading, but no data. Like the dataset is not populating. Anyone have any thoughts???

Thanks

-Paul

Code Follows:
Imports System.Data
Imports System.Data.SqlClient
Imports System.Security

Public Class cfrAllEmpForm
    Inherits System.Web.UI.Page
    Protected WithEvents CrystalReportViewer2 As CrystalDecisions.Web.CrystalReportViewer

#Region " Web Form Designer Generated Code "

    Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        Dim MyConnection As SqlConnection
        Dim MyAdapter As SqlDataAdapter
        Dim MyStoredProc As SqlCommand
        Dim MyData As DataSet
        Dim oRpt As New cfrEmp()

        ' Connection
        Dim strCon As String

        '
        strCon = "Server=****; Trusted_Connection=yes; uid=gvldataload; pwd=********; Integrated Security=True; Database=****;"
        MyConnection = New SqlConnection(strCon)

        ' select command
        MyStoredProc = New SqlCommand()
        MyStoredProc.Connection = MyConnection
        MyStoredProc.CommandType = CommandType.StoredProcedure
        MyStoredProc.CommandText = "cfrLevelAll_sps"

        'DataAdapter
        MyAdapter = New SqlDataAdapter()
        MyAdapter.SelectCommand = MyStoredProc

        ' DataSet
        MyData = New cfrEmpAll()

        MyAdapter.Fill(MyData)
        'oRpt.Load()
        oRpt.SetDataSource(MyData)
        CrystalReportViewer2.ReportSource = oRpt
        CrystalReportViewer2.DataBind()

    End Sub

End Class

I have successfully used strongly-typed datasets as datasources for Crystal reports. Like you, I used stored procedures to access data through dataAdapters for each typed dataset. Although it probably makes no difference, I also used the TableMapping object auto-generated by the Visual Studio dataAdapter wizard. If you set a breakpoint at MyAdapter.Fill(MyData) you could determine, for example by examining the dataset in the Locals window, whether the data you expected is in the dataset. This will tell you whether the problem lies in your data access or Crystal Reports-related code. (In case you're not familiar with this, select Debug -- Processes, then attach the asp.net worker process to initiate debugging.)

I think if you change the last part of your code as follows it will work:

oRpt.Load("path + fileName of your .rpt file")
oRpt.SetDataSource(MyData.Tables(0))
CrystalReportViewer2.ReportSource = oRpt
'CrystalReportViewer2.DataBind() -> you don't have to do that

Sorry I made a mistake :D It should be like this:

oRpt.Load()
oRpt.SetDataSource(MyData.Tables(0))
CrystalReportViewer2.ReportSource = oRpt

i got a bit confusion on the declaration on Dim oRpt As New cfrEmp()
where's the origin class for this?

i got a bit confusion on the declaration on Dim oRpt As New cfrEmp()
where's the origin class for this?