creating crystal report in C#.net asp.net V-Studio 2012

wish dar

12y1.7k.NET

Hi,

I'm having problem in displaying my crystal report. Whenever I run my program, details are not showing. I already created the layout(.rpt) and my webform which only contains the CrystalReportViewer. Details are connected to my SQL Database 2008.

Here's my code behind. What am I missing?

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using CrystalDecisions.CrystalReports.Engine;

using CrystalDecisions.Shared;

using System.Data.Sql;

using System.Data.SqlClient;

using System.Data;

namespace Demo

{

public partial class WebForm1 : System.Web.UI.Page

{

public string GetConnectionString()

{

return System.Configuration.ConfigurationManager.ConnectionStrings["connString"].ConnectionString;

}

protected void Page_Load(object sender, EventArgs e)

{

SqlConnection conn = new SqlConnection(GetConnectionString());

SqlDataAdapter ad = new SqlDataAdapter("Select city_code, city_cd from cities", GetConnectionString());

DataTable _dt = new DataTable();

ad.Fill(_dt);

CrystalReport3 rpt = new CrystalReport3();

rpt.SetDataSource(_dt);

CrystalReportViewer1.ReportSource = rpt;

CrystalReportViewer1.DataBind();

}

Appreciate your help a lot.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

wish dar12y ago
attached is the output...
+1
wish dar12y ago
hi, It's running fine but the details are still not appearing. I'm using only local host. Is there an issue with that? Thanks a lot.
+1
Satyapriya Nayak12y ago
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
using CrystalDecisions.CrystalReports.Engine;
namespace ReportViewer
{
    public partial class _Default : System.Web.UI.Page
    {
        string connStr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
        SqlDataAdapter sqlda = new SqlDataAdapter();
        SqlCommand com = new SqlCommand();
        DataTable dt;
        DataSet1 ds=new DataSet1();
        ReportDocument rptDoc=new ReportDocument();

        protected void Page_Load(object sender, EventArgs e)
        {
            bindReport();

        }
        private void bindReport()
        {

            SqlConnection conn = new SqlConnection(connStr);
            dt = new DataTable();
            dt.TableName = "Crystal Report Example";
            com.Connection = conn;
            com.CommandText = "SELECT * FROM product";
            sqlda = new SqlDataAdapter(com);
            sqlda.Fill(dt);
            ds.Tables[0].Merge(dt);
            rptDoc.Load(Server.MapPath("CrystalReport1.rpt"));
            rptDoc.SetDataSource(ds);
            CrystalReportViewer1.ReportSource = rptDoc;

        }
    }
}
+1