winform水晶报表制作步骤【源】

 

水晶报表运行效果如下：

收起树形菜单

建立步骤：

1.添加DataSet1.xsd文件

建立数据

2.添加CrystalReport1.rpt文件

2.1 CrystalReport设计

3程序集

4.Form1.cs 代码段

--------------------------------------邪恶的分割线------------------------------------------------------

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;

using System.Data.SqlClient;

namespace WindowsApplicationCrystalReports
{
    public partial class Form1 : Form
    {
        SqlConnection conn = new SqlConnection("server=.;database=Northwind;uid=sa;pwd=321456;");
        DataSet1 myData = new DataSet1();
        SqlDataAdapter da;

        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            //
            showReport();
        }
        private void showReport()
        {
            da = new SqlDataAdapter("SELECT * FROM Orders INNER JOIN [Order Details] ON Orders.OrderID =[Order Details].OrderID INNER JOIN Employees ON Orders.EmployeeID = Employees.EmployeeID", conn);
            da.Fill(myData, "DataTable1");
            //创建报表
            CrystalReport1 cr = new CrystalReport1();
            //设置报表的数据源
            cr.SetDataSource(myData);
            //设置报表视图的报表源
            crystalReportViewer1.ReportSource = cr;
        }
    }
}

5.附件：

winform水晶报表入门视频http://v.youku.com/v_show/id_co00XMTU1OTU3ODQ=.html