vs2012 中水晶報(bào)表引用
1.下載安裝包安裝,你可以從下面鏈接下載:
http://downloads.businessobjects.com/akdlm/cr4vs2010/CRforVS_13_0_5.exe
2.添加4個(gè)引用

3.添加一個(gè).rpt文件

1)綁定數(shù)據(jù)源

2)手動(dòng)畫出報(bào)表表格,拖動(dòng)顯示字段

字段顯示的時(shí)候碰到了幾個(gè)小問題:
a.一個(gè)格子里面顯示兩個(gè)字段;
b.格子里面的字段根據(jù)條件判斷顯示;
c.文本上下左右對(duì)齊;
解決方法:
a.制一文本框,在文本框中把要顯示的兩個(gè)字段拖進(jìn)來

b.建一個(gè)公式字段,在公式字段里面添加條件

c.這個(gè)居中問題不好弄,水晶報(bào)表里面只有左右居中,沒有垂直居中,在網(wǎng)上找了好久也沒有找到方法,最后在一篇博客里面看到了一個(gè)行的同方法(不是垂直居中)

4.還要添加一個(gè).aspx文件

界面代碼
<body> <form id="form1" runat="server"> <div> <CR:CrystalReportViewer ID="ReTransport" runat="server" AutoDataBind="true" /> </div> </form></body>
后臺(tái)綁定代碼
public void GetList() { ReportDocument doc = new ReportDocument(); doc.Load(Server.MapPath("/Cry/StudentInfo.rpt")); string studentType = Request.QueryString["studentType"].ToString(); string schoolCode = Request.QueryString["schoolCode"].ToString(); string district = Request.QueryString["district"].ToString(); string strWhere = " TiJiaoStatus=1"; if (!string.IsNullOrEmpty(studentType)) { strWhere += " and TypeName='" + studentType + "'"; } if (!string.IsNullOrEmpty(district)) { strWhere += " and DistrictCode='" + district + "'"; } if (!string.IsNullOrEmpty(schoolCode)) { strWhere += " and PRimarySchoolCode ='" + schoolCode + "'"; } strWhere += " ORDER BY TiJiaoNumber "; DataTable dt = new BLL.ObjMethod().GetList("View_Student", strWhere); ReTransport.ToolPanelView = ToolPanelViewType.None; doc.SetDataSource(dt.DefaultView); this.ReTransport.ReportSource = doc; }
新聞熱點(diǎn)
疑難解答
圖片精選
網(wǎng)友關(guān)注