Print Page | Close Window

No Data in Report

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=2470
Printed Date: 17 Apr 2025 at 3:47pm


Topic: No Data in Report
Posted By: dextar
Subject: No Data in Report
Date Posted: 27 Feb 2008 at 8:28pm
I am new to crystal reports , i am using crytal reports to display data in a asp.net form . on basis of selection from the dropdown i fill a table in database having same structure as of in .Xsd file , then assign the data set to report datasource . report is loading but the data is not coming
kindly help


code

            int sbu = Convert.ToInt32(ddl1.SelectedItem.Value);
            report=new CrystalReport1();
            string conn1 = "  ";
            SqlConnection conn = new SqlConnection(conn1);
            conn.Open();
            SqlDataAdapter da = new SqlDataAdapter("sp_cis",conn);
           
            DataSet Dataset1 = new DataSet();
            DataTable Temp = Dataset1.Tables.Add();
//            Dataset1.Tables.Add("CISTemp");
            Temp.TableName="CISTemp";
            SqlCommand cmd = new SqlCommand("sp_cis",conn);
            cmd.CommandType= CommandType.StoredProcedure ;
            cmd.Parameters.Add( new SqlParameter("@hlevelid",sbu));
            da.SelectCommand=cmd;
            da.Fill(Dataset1,"CISTemp");
            CrystalDecisions.CrystalReports.Engine.ReportDocument myReportDocument;
            myReportDocument = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
            myReportDocument.Load(Server.MapPath("CrystalReport1.rpt"));
             myReportDocument.SetDataSource(Dataset1);
            CrystalReportViewer1.ReportSource = myReportDocument;
            CrystalReportViewer1.DataBind();
            conn.Close();

Thanks in advance


Replies:
Posted By: hilfy
Date Posted: 28 Feb 2008 at 11:45am

Try this: 



int sbu = Convert.ToInt32(ddl1.SelectedItem.Value);
report=new CrystalReport1();
string conn1 = "  ";
SqlConnection conn = new SqlConnection(conn1);
conn.Open();
            
DataSet Dataset1 = new DataSet();
DataTable Temp = new DataTable("CISTemp");
SqlCommand cmd = new SqlCommand("sp_cis",conn);
cmd.CommandType= CommandType.StoredProcedure ;
cmd.Parameters.Add( new SqlParameter("@hlevelid",sbu));
Temp.Load(cmd);
Dataset1.Add(Temp);
CrystalDecisions.CrystalReports.Engine.ReportDocument myReportDocument;
myReportDocument = new 
     CrystalDecisions.CrystalReports.Engine.ReportDocument();
myReportDocument.Load(Server.MapPath("CrystalReport1.rpt"));
myReportDocument.SetDataSource(Dataset1);
CrystalReportViewer1.ReportSource = myReportDocument;
CrystalReportViewer1.DataBind();
conn.Close();
Also, is your report designed using the "CISTemp" table name?  If not, that could also be part of your problem.  Even though you're assigning the Datasource to the report, the report won't work if the table names don't match up.
 
-Dell


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics


Print Page | Close Window