本文章由jquery学堂2群的网友【北京-web-小虾米】整理分享,非常感谢!
Asp.net 简单报表生成
一、水晶报表
效果图:
Html:
<div>
<rsweb:ReportViewer ID="ReportViewer1" runat="server" Font-Names="Verdana" Font-Size="8pt" Height="400px" Width="400px">
</rsweb:ReportViewer>
</div>
code:
protected void Page_Load(object sender, EventArgs e)
protected void Page_Load(object sender, EventArgs e)
{
DataTable dt = new DataTable();
HF_DayReportBll bll = new HF_DayReportBll();
dt = bll.AreaCodeSelect("0101000000");
CrystalReport1 cr = new CrystalReport1();//CrystalReport1是创建的报表文件CrystalReport1.rpt
cr.SetDataSource(dt);//给报表文件添加数据
CrystalReportViewer1.ReportSource = cr;//把报表文件添加到报表视图
}
}
CrystalReport1.rpt报表文件创建过程:
1、创建dataset数据集,添加列,注意列名一定要与上面Datatable dt里的列名一致
2、创建CrystalReport1.rpt文件
二、微软自带报表
效果图:
Html:
<div>
<rsweb:ReportViewer ID="ReportViewer1" runat="server" Font-Names="Verdana" Font-Size="8pt" Height="400px" Width="100%">
</rsweb:ReportViewer>
</div>
Code:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using Microsoft.Reporting.WebForms;//注意此处
using System.Data;
using Queen.BLL;
namespace Web.水晶report.msReport
{
public partial class WebForm1 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
DataTable dt = new DataTable();
HF_DayReportBll bll = new HF_DayReportBll();
dt = bll.AreaCodeSelect("0101000000");
ReportDataSource rs = new ReportDataSource("DataSet1_DataTable1", dt);// DataSet1是创建的数据集名
ReportViewer1.LocalReport.ReportPath = "水晶report\\msReport\\Report1.rdlc";
//注意此处是路径,水晶report是网站下第一个文件夹
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(rs);
ReportViewer1.LocalReport.Refresh();
}
}
}
1创建dataset数据集,添加列,注意列名一定要与上面Datatable dt里的列名一致
2创建Report1.rdlc
如果您觉得本文的内容对您的学习有所帮助:
关键字:
asp.net C# Winform 水晶报表 数据报表 CrystalReport