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
|
|