Print Page | Close Window

problem in loading dynamic crystal report asp.net

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Writing Code
Forum Discription: .NET programming API, report integration
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=7608
Printed Date: 19 May 2024 at 4:31pm


Topic: problem in loading dynamic crystal report asp.net
Posted By: asmasm
Subject: problem in loading dynamic crystal report asp.net
Date Posted: 07 Sep 2009 at 2:28am
not getting data in vs2005 using asp.net 2.0 and i am using stored procedure
the data from dataset does not get loaded into crystal report as there is no error message
as my code is below
Dim con As New SqlConnection(ConfigurationManager.ConnectionStrings("satinconnectionstring").ConnectionString)
        con.Open()
        Dim cmd As New SqlCommand
        cmd.Connection = con
               Dim W As String = Today.DayOfWeek.ToString
         cmd.CommandText = "EXEC MYSP_DEMAND_SHEET '20983','" & M & "','" & W & "','" & dat & "'"
             Dim da As New SqlDataAdapter(cmd.CommandText, con)
        Dim ds As New DataSet
        da.Fill(ds)
       
        Dim myReportDocument As CrystalDecisions.CrystalReports.Engine.ReportDocument
        myReportDocument = New CrystalDecisions.CrystalReports.Engine.ReportDocument()
        myReportDocument.Load(Server.MapPath("employee.rpt"))
            myReportDocument.Database.Tables("employee").SetDataSource(ds)
                CrystalReportViewer1.ReportSource = myReportDocument
        CrystalReportViewer1.DataBind()
     please help me in this regard
      


Tongue



Print Page | Close Window