在Excel2001中使用RDLC报表.docVIP

在 Excel 20?10中使用RDLC报?表 本系列所有示例代?码均在 Visual? Studio 20?10 Ultimat?e RTM?+ Of?fice 2010 ?Profession?al Plus Be?ta x64?下测试?通过 注：本次数据库?使用的是 SQL S?erver 2008? R2 x64 RT?M ? 1、在VS2?010中，新建一个E?xcel 2010 ?Workbook项目?： ? 2、添加?引用： Micros?oft.Report?Viewer.Win?Forms ? ?3、创建一个RDLC?报表，添加一个报表参?数p_Country?： 报表的目的很?简单，用的North?wind数据库，根据?传递的参数，从Cus?tomers表中查询?数据。 ? 4、创建?一个存储过程： 代?码 IF?EXI?STS(SELECT??*?FROM?db?o.sysobjec?ts?WHERE?i?d?=?OBJECT?_ID(Nsp_L?inqTest)??AND?OBJECT?PROPERTY(i?d,?NIsPro?cedure)?=??1)?BEGI?N?????DR?OP?PROCEDU?RE?dbo.sp_?LinqTest??END?GO??CREATE?P?ROCEDURE?d?bo.sp_Linq?Test?(??????@Coun?try?VARCHA?R(20)?)??AS?SEL?ECT?*?FROM??dbo.Custo?mers?WHERE??Country?=??@Country??GO? ? ?? ? 5、在项目中?添加一个Linq t?o SQL Clas?s，将Custome?rs表和sp_Lin?qTest存储过程添?加进来： ? 6?、打开Sheet1的?设计界面，添加一个C?omboBox： ? ? 7、初始化数据?： ? ? 代码 ? ?????????ReportView?er?rptExce?l?=?new?Re?portViewer?();?????????private??void?fnDat?aIni()?????????{?????????????t?his.rptExc?el.LocalRe?port.Repor?tEmbeddedR?esource?=??RDLCInExc?el.LinqRpt?.rdlc;??????????????Excel.Rang?e?range?=??this.Range?[B4,?J2?2];?????????????thi?s.Controls?.AddContro?l(this.rpt?Excel,?ran?ge,?rptIn?Excel);??????????????Northwin?dDataConte?xt?ctx?=?n?ew?Northwi?ndDataCont?ext();?????????????v?ar?result??=?from?c?i?n?ctx.Cust?omers????????????????????????????select?c.?Country;??????????????foreach?(?string?lis?t?in?resul?t.Distinct?string()?.ToListst?ring())??????????????{?????????????????t?Cou?ntry.Items?.Add(list)?;?????????????}?????????} ? ?? 8、构造数据源，?传递报表参数： ? ?? 代码 ?????????priv?ate?void?f?nBuildData?Source(str?ing?v_strC?ountry)?????????{??????????????NorthwindD?ataContext??ctx?=?new??Northwind?DataContex?t();?????????????var??datasourc?e?=?from?c??in?ctx.sp?_LinqTest(?v_strCount?ry)????????????????????????????????orderby??c.Custome?rID????????????????????????????????select??c;?????????????Repo?rtParamete?r?rpCountr?y?=?new?Re?portParame?ter(p_Cou?ntry,?v_s?trCountry)?;????