报表效果图:
数据库表:
源代码:
<span style="font-size:24px;"><span style="font-size:24px;">using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Linq;
using System.Windows.Forms;
using DevExpress.XtraEditors;
using System.Data.SqlClient;
using Microsoft.Reporting.WinForms;
namespace DXApplication4
{
public partial class report : DevExpress.XtraEditors.XtraForm
{
public report()
{
InitializeComponent();
}
private void report_Load(object sender, EventArgs e)
{
this.reportViewer1.RefreshReport();
using (SqlConnection conn = new SqlConnection("server=(local);database=员工考勤信息管理系统;Integrated Security=true;"))
{
SqlDataAdapter sda = new SqlDataAdapter("select * from staff", conn);
DataSet ds = new DataSet();
sda.Fill(ds);
//构建报表数据源
ReportDataSource rds = new ReportDataSource("DataSet1", ds.Tables[0]);
this.reportViewer1.LocalReport.DataSources.Clear();//清空之前的数据源
this.reportViewer1.LocalReport.DataSources.Add(rds);//加入新的报表数据源
this.reportViewer1.RefreshReport();
}
}
}
}</span></span>
实例下载:http://download.csdn.net/detail/tingzhiyi/9457044