报表查看器 - 它成功运行但不显示任何数据 [英] Report Viewr-it runs succesfullly but not displaying any data

问题描述

你好朋友，

我需要你的帮助..我是使用数据集编码的绑定报表查看器。

它运行成功但没有显示任何数据。它只是显示我在default.aspx页面放了一个reportviewer控件。这是我的代码..pl帮助我..

Hello friends,
I need your help..I am binding report viewer by coding using dataset.
It runs successfully but not showing any data.It simply shows reportviewer control which I have put in default.aspx page.Here is my code..pl help me..

public partial class _Default : System.Web.UI.Page
{
    string connectionString = WebConfigurationManager.ConnectionStrings["NirmanGroupConnectionString"].ConnectionString;
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            ReportViewer1.ProcessingMode = ProcessingMode.Local;
            ReportViewer1.LocalReport.ReportPath = "Report.rdlc";
            ReportDataSource rdS = new ReportDataSource("Dataset1", GetData());
            ReportViewer1.LocalReport.DataSources.Add(rdS);
            ReportViewer1.DataBind();
            ReportViewer1.LocalReport.Refresh();
        }
    }
    public DataTable GetData()
    { 
            SqlDataAdapter dta = new SqlDataAdapter();

            SqlConnection con = new SqlConnection(connectionString);

            DataSet ds = new DataSet();       

            SqlCommand cmd = new SqlCommand("SELECT [Vendor_Code],[Company_Name],[First_Name],[Last_Name] FROM Vendor_Entry",con);

            dta.SelectCommand = cmd;

            dta.SelectCommand.Connection = con;

            dta.Fill(ds, "Vendor_Entry");

            return ds.Tables[0];
    }
}

推荐答案

假设您的Crystal报告命名为 CRQuotation.rpt



尝试将数据绑定到报告查看器

Suppose your Crystal report is named as CRQuotation.rpt

Try this to bind data to Report Viewer

CRQuotation rptDoc = new CRQuotation();
rptDoc.SetDataSource(GetData());
ReportViewer1.ReportSource = rptDoc;

这篇关于报表查看器 - 它成功运行但不显示任何数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！