1.æ°å»ºä¸ä¸ªWinForm项ç®ï¼é¡¹ç®->å¢å æ°é¡¹->éæ©Crystal æ¥è¡¨
2.使ç¨æ¥è¡¨å导->å建æ°è¿æ¥->æ°æ®åºæ件->éæ©ä¸ä¸ªAccessæ°æ®åºdb.mdb
3.éä¸ä¸ä¸ªè¡¨ï¼Articleæ·»å å°éå®ç表ä¸ï¼ä¸ä¸æ¥
4.éæ©å¯ç¨å段添å å°è¦æ¾ç¤ºçå段ä¸ãä¸ç¹ä¸ä¸æ¥ï¼ç´æ¥ç¹å®æã
5.è¿æ ·å°±å建äºä¸ä¸ªæ¥è¡¨æ件ï¼ä¸ºæ¥è¡¨åä¸äºç¾åã
è¯çæ·»å ä¸ä¸ªææ¬å¯¹è±¡ï¼ä¸ä¸ªçº¿æ¡å¯¹è±¡ï¼ä¸ä¸ªçº¿æ¡å¯¹è±¡ï¼çä¸ä¸ææã
5.æ°å»ºä¸ä¸ªçªä½,æä¸ä¸ªCrystalReportViewerè¿æ¥ã
ç§ç§æ¥è¡¨æ¯ä»ä¹æ¨¡æ ·ï¼åµåµã
6.为çªä½å¢å Loadäºä»¶ï¼æ·»å å¦ä¸ä»£ç ã
private void FrmFirst_Load(object sender, EventArgs e)
{
string strPath = Application.StartupPath.Substring(0, Application.StartupPath.Substring(0, Application.StartupPath.LastIndexOf("\\")).LastIndexOf("\\"));
strPath += @"\crptFirst.rpt";
this.crystalReportViewer1.ReportSource = strPath;
}
7.è¿è¡çå°çæææ¯ï¼æ¥è¡¨ææ°æ®åºä¸çæ°æ®æä½ è®¾è®¡çæ ·åæ¾ç¤ºåºæ¥ï¼
并ä¸æä¾ï¼æå°ï¼å¯¼åºï¼å页ï¼æç´¢çåè½ã
8.æ¥çè¿è¡ææä¹åï¼è§å¾æ°æ®åºä¸çè±æå段åæ ·æ¾ç¤ºä¸å¤ªå¥½ï¼å¯ä»¥æå¼crptFirst.rptç¶ååå»é£ä¸ªå段修æ¹ã
ä¿®æ¹åä¸è½ç¨å车ï¼ä¸å车就æ¢å°ä¸ä¸è¡ï¼åµåµï¼æå¨è¿éè¿·æäºä¸ä¸ãä¹å°±æ¯è¯´æ é¢é£éå¯ä»¥æ¯å¤è¡æ¾ç¤ºã
æ´æ¹ä¸ä¸æ¥è¡¨çé¢è²ï¼ä¿®é¥°ä¸ä¸ã
9.æ»ç»ä¸ä¸ï¼
crystalReportViewerå°±ç¸å½äºGridViewæ¯ç¨æ¥æ¾ç¤ºæ°æ®çï¼åªä¸è¿ä¸ç¨æ¥è®¾è®¡æ°æ®æ¾ç¤ºæ ¼å¼ã
crystalReportå°±ç¸å½äºDataSourceå
¼æ°æ®æ¾ç¤ºè®¾è®¡ï¼å¨è¿ä¸ªæ§ä»¶éç»å®æ°æ®è®¾è®¡æ°æ®æ¾ç¤ºæ ¼å¼
æ³äº(æå½ç½å)ï¹
æ°´æ¶æ¥è¡¨è¿è¡ææå¦ä¸ï¼
æ¶èµ·æ å½¢èå
建ç«æ¥éª¤ï¼
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;
}
}
}
温馨提示:答案为网友推荐,仅供参考