VC# .Net中使用Crystal Report
发布时间:2006-10-14 3:12:53   收集提供:gaoqian

  大名鼎鼎的 Crystal Reports(水晶报表)已内嵌为微软 Visual Studio .NET的标准报表工具,同时升级到 Crystal Reports for Visual Studio .NET。它的优点是:1、在 .NET 平台能够轻松创建交互式的、高质量显现的报表内容,这也是 Crystal Reports 长期以来所具有的主要优势;2、使用 Crystal Reports for Visual Studio .NET,可以在 Web 平台和 Windows 平台上承载报表,并将 Crystal 报表作为报表 Web 服务在 Web 服务器上发布;3、利用Crystal Report 创建的Web应用程序,使用户可以深化图表并根据需要筛选信息。在 .NET 中,图表实际上就是一个与应用程序中其他控件进行交互的 Crystal 报表。在这里我向大家介绍如何在 Windows 窗体应用程序中浏览水晶报表。

  设计步骤:

  1、软件环境:要求系统已安装Visual Studio .Net 集成开发系统,仅装有 .Net Framework SDk 不能实现本例效果,成为 .Net Framework SDK 没有水晶报表控件。

  2、新建一个 Visual C# 项目 Windows 应用程序,设置Form1的Text="水晶报表浏览器",StartPosition=CenterScreen //程序开始出现在屏幕中央,其它属性均保持默认;

  3、从工具箱拖入一个CrystalReportViewer,一个Button,一个openFileDialog,到窗体。

  整个设计器的窗体布局只需将button1置于窗体底边中部,不再需要其它多余布局。

  设置crystalReportViewer1的属性如下:

this.crystalReportViewer1.Dock = System.Windows.Forms.DockStyle.Fill;
//停靠方式为充满整个窗体
//展开+DockPadding
this.crystalReportViewer1.DockPadding.Bottom = 50;
//底部空出放置Button的区域
this.crystalReportViewer1.DockPadding.Left = 5;
this.crystalReportViewer1.DockPadding.Right = 5;
this.crystalReportViewer1.DockPadding.Top = 5;
this.crystalReportViewer1.ReportSource = null;
//先不载入报表资源

  设置button1的属性如下:

this.button1.Anchor = System.Windows.Forms.AnchorStyles.Bottom;
//与窗体的下边保持固定
this.button1.Text = "打开报表";
openFileDialog1是打开文件的控件,设置其属性如下:
this.openFileDialog1.Filter
= "Crystal Report (*.rpt)|*.rpt|所有文件(*.*)|*.*";
//提供打开文件对话框的文件类型,
默认类型就是此字符串的最前一种定义的类型
this.openFileDialog1.Title = "打开水晶报表";
//打开文件对话框的标题 

  布局效果图如下:

  4、双击button1,添加button1_Click点击事件:

private void button1_Click(object sender, System.EventArgs e)
{
 try
 {
  if(openFileDialog1.ShowDialog()==DialogResult.OK)
   this.crystalReportViewer1.ReportSource = @openFileDialog1.FileName;
   //加载水晶报表,将报表文件绑定到CrystalReportView 控件;
 }
 catch(Exception error)
 {
  MessageBox.Show(error.ToString(),"错误");
 }

  5、OK!按Ctrl+F5运行吧。

  可以浏览你系统内现有的报表实例:

...\Program Files\Microsoft Visual Studio .NET\Crystal Reports\Samples\Reports\Feature Examples\Chart.rpt

 

using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data;
namespace WindowsApplication10
{
 /// <summary>
 /// Form1 的摘要说明。
 /// </summary>
 public class Form1 : System.Windows.Forms.Form
 {
  private CrystalDecisions.Windows.Forms.CrystalReportViewer crystalReportViewer1;
  private System.Windows.Forms.Button button1;
  private System.Windows.Forms.OpenFileDialog openFileDialog1;
  /// <summary>
  /// 必需的设计器变量。
  /// </summary>
  private System.ComponentModel.Container components = null;
  public Form1()
  {
   //
   // Windows 窗体设计器支持所必需的
   //
   InitializeComponent();
   //
   // TODO: 在 InitializeComponent 调用后添加任何构造函数代码
   //
  }
  /// <summary>
  /// 清理所有正在使用的资源。
  /// </summary>
  protected override void Dispose( bool disposing )
  {
   if( disposing )
   {
    if (components != null)
    {
     components.Dispose();
    }
   }
   base.Dispose( disposing );
  }
  #region Windows Form Designer generated code
  /// <summary>
  /// 设计器支持所需的方法 - 不要使用代码编辑器修改
  /// 此方法的内容。
  /// </summary>
  private void InitializeComponent()
  {
   this.crystalReportViewer1 = new
   CrystalDecisions.Windows.Forms.CrystalReportViewer();
   this.button1 = new System.Windows.Forms.Button();
   this.openFileDialog1 = new System.Windows.Forms.OpenFileDialog();
   this.SuspendLayout();
   //
   // crystalReportViewer1
   //
   this.crystalReportViewer1.ActiveViewIndex = -1;
   this.crystalReportViewer1.Dock= System.Windows.Forms.DockStyle.Fill;
   this.crystalReportViewer1.DockPadding.Bottom = 50;
   this.crystalReportViewer1.DockPadding.Left = 5;
   this.crystalReportViewer1.DockPadding.Right = 5;
   this.crystalReportViewer1.DockPadding.Top = 5;
   this.crystalReportViewer1.Name = "crystalReportViewer1";
   this.crystalReportViewer1.ReportSource = null;
   this.crystalReportViewer1.Size = new System.Drawing.Size(292, 273);
   this.crystalReportViewer1.TabIndex = 0;
   //
   // button1
   //
   this.button1.Anchor = System.Windows.Forms.AnchorStyles.Bottom;
   this.button1.Location = new System.Drawing.Point(104, 240);
   this.button1.Name = "button1";
   this.button1.TabIndex = 1;
   this.button1.Text = "打开报表";
   this.button1.Click += new System.EventHandler(this.button1_Click);
   //
   // openFileDialog1
   //
   this.openFileDialog1.Filter = "Crystal Report (*.rpt)|*.rpt|所有文件(*.*)|*.*";
   this.openFileDialog1.Title = "打开水晶报表";
   //
   // Form1
   //
   this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
   this.ClientSize = new System.Drawing.Size(292, 273);
   this.Controls.AddRange(new System.Windows.Forms.Control[] {
    this.button1,
    this.crystalReportViewer1});
   this.Name = "Form1";
   this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;
   this.Text = "水晶报表浏览器";
   this.ResumeLayout(false);
  }
  #endregion
  /// <summary>
  /// 应用程序的主入口点。
  /// </summary>
  [STAThread]
  static void Main()
  {
   Application.Run(new Form1());
  }
  private void button1_Click(object sender, System.EventArgs e)
  {
   try
   {
    if(openFileDialog1.ShowDialog()==DialogResult.OK)
     this.crystalReportViewer1.ReportSource = @openFileDialog1.FileName;
     //加载水晶报表,将资源报表绑定到水晶报表查看器
   }
   catch(Exception error)
   {
    MessageBox.Show(error.ToString(),"错误"); //处理异常错误
   }
  }
 }
}

 
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50