前台界面:
<cc1:StiWebViewer ID="StiWebViewer1" width="100%" height="800" runat="server" GlobalizationFile="/reports/Localization/zh-CHS.xml" ShowDesignButton="False" ScrollBarsMode="true" Theme="Office2010" BackColor="#e8e8e8" />
后台:
protected void Page_Load(object sender, EventArgs e)
{
string RowGuid = Request.QueryString["RowGuid"];
ShowReport(RowGuid);
}
public void ShowReport(string rowGuid)
{
string Sql = @"select .......";
DataView dv = DB.ExecuteDataView(Sql);
//
string filepath = Server.MapPath("~/Page/Report/report1.mrt");
StiReport stireport = new StiReport();
stireport.Load(filepath);
stireport.RegData("Test", dv);
StiReportTitleBand RTitle = stireport.Pages[0].Components["ReportTitleBand1"] as StiReportTitleBand;
StiText Name = RTitle.Components["Name"] as StiText;
//dv2省略
Name.Text = Convert.ToString(dv2[0]["Name"]);
//设置页边距
stireport.Compile();
StiWebViewer1.Report = stireport;
}
protected void StiWebDesigner1_SaveReport(object sender, Stimulsoft.Report.Web.StiWebDesigner.StiSaveReportEventArgs e)
{
var report = e.Report;
string filepath = Server.MapPath("~/Page/Report/report1.mrt");
report.Save(filepath);
}
报表制作:
新建数据源,从dataview中获取数据,然后新建列,再报表中将列放在显示的位置即可
注:数据源中的列名,必须和dataview中的列名一致。