Wrox Programmer Forums
|
Classic ASP Basics For beginner programmers starting with "classic" ASP 3, pre-".NET." NOT for ASP.NET 1.0, 1.1, or 2.0
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old August 15th, 2011, 01:50 AM
Authorized User
 
Join Date: Aug 2011
Posts: 14
Thanks: 1
Thanked 0 Times in 0 Posts
Thumbs down The report has no tables - Error

Description: An unhandled exception occurred during the execution of the current web request.

Exception Details: CrystalDecisions.CrystalReports.Engine.DataSourceE xception: The report has no tables

I am getting this error for this code

public void load_data()
{
ReportDocument rptFineBill = new ReportDocument();
string path = Server.MapPath("~/Report/Student_Fee.rpt");
rptFineBill.Load(path);
string str = Session["roll"].ToString();
string query = "SELECT student_name, class, section, rollno, fee_type FROM dbo.tbl_fee_info where student_name='" + str + "'";
con.Open();
SqlDataAdapter da = new SqlDataAdapter(query,con);
DataSet ds = new DataSet();
da.Fill(ds);
ds.Tables[0].TableName = "Student_Fee";
rptFineBill.SetDataSource(ds); // Here I am getting
CrystalReportViewer1.ReportSource = rptFineBill;
CrystalReportViewer1.DataBind();
}

Kindly anyone resolve it soon....

Thanks
Emma
 
Old August 15th, 2011, 07:00 PM
Friend of Wrox
 
Join Date: Jan 2004
Posts: 1,870
Thanks: 12
Thanked 20 Times in 20 Posts
Send a message via AIM to mat41
Default

Hi there - You should post this in the .net area of the forum, this is for Classic ASP
__________________
Wind is your friend
Matt





Similar Threads
Thread Thread Starter Forum Replies Last Post
how to use two tables in one report? denishrt Crystal Reports 4 October 13th, 2006 11:42 AM
Multi tables in the crystal report? lovelylife1982 Crystal Reports 1 March 11th, 2005 04:21 PM
Crystal Report Error: "Cannot open anymore tables" ejan Pro VB 6 0 February 4th, 2005 03:21 PM
Two different tables, same report SilverTip BOOK: Professional SQL Server Reporting Services ISBN: 0-7645-6878-7 0 July 12th, 2004 07:39 AM
multiple tables on one report? lanctotd Access 4 October 8th, 2003 03:41 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.