110,547
社区成员
发帖
与我相关
我的任务
分享
<rsweb:ReportViewer ID="ReportViewer1" runat="server" Width="100%" Font-Names="Verdana" Font-Size="8pt" WaitMessageFont-Names="Verdana" WaitMessageFont-Size="14pt">
</rsweb:ReportViewer>
<asp:ScriptManager ID="ScriptManager1" runat="server"></asp:ScriptManager>
public partial class CustReport : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
ReportViewer1.Reset();
ReportViewer1.LocalReport.ReportPath = "CustReport1.rdlc";//报表名称
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSet1", dt()));//对应的xsd数据集文件名
ReportViewer1.LocalReport.Refresh();
}
}
private DataTable dt()
{
DataTable DataTable2 = new DataTable("dt2");
DataTable2.Columns.Add("DataColumn1", typeof(string));
DataTable2.Columns.Add("DataColumn2", typeof(string));
DataTable2.Columns.Add("DataColumn3", typeof(string));
DataTable2.Columns.Add("DataColumn4", typeof(string));
DataTable2.Columns.Add("DataColumn5", typeof(string));
for (int i = 0; i < 5; i++)
{
DataRow dr = DataTable2.NewRow();
dr["DataColumn1"] = "test1" + i.ToString();
dr["DataColumn2"] = "test2" + i.ToString();
dr["DataColumn3"] = "test3" + i.ToString();
dr["DataColumn4"] = "test4" + i.ToString();
dr["DataColumn5"] = "test5" + i.ToString();
DataTable2.Rows.Add(dr);
}
return DataTable2;
}
}
private DataTable dt()
{
DataTable DataTable2 = new DataTable("dt2");
DataTable2.Columns.Add("DataColumn1", typeof(string));
DataTable2.Columns.Add("DataColumn2", typeof(string));
DataTable2.Columns.Add("DataColumn3", typeof(string));
DataTable2.Columns.Add("DataColumn4", typeof(string));
DataTable2.Columns.Add("DataColumn5", typeof(string));
DataTable2.Columns.Add("DataColumn6", typeof(string));
//DataSet.Tables["XX"].Columns["xx"].ColumnName = "NewColumnName";//修改列名
for (int i = 0; i < 5; i++)
{
DataRow dr = DataTable2.NewRow();
if (i == 0)
{
dr["DataColumn1"] = DataTable2.Columns[0].ColumnName;
dr["DataColumn2"] = DataTable2.Columns[1].ColumnName;
dr["DataColumn3"] = DataTable2.Columns[2].ColumnName;
dr["DataColumn4"] = DataTable2.Columns[3].ColumnName;
dr["DataColumn5"] = DataTable2.Columns[4].ColumnName;
dr["DataColumn6"] = DataTable2.Columns[5].ColumnName;
continue;
}
dr["DataColumn1"] = "Test" + i.ToString();
dr["DataColumn2"] = "Test" + i.ToString();
dr["DataColumn3"] = "Test" + i.ToString();
dr["DataColumn4"] = "Test" + i.ToString();
dr["DataColumn5"] = "Test" + i.ToString();
dr["DataColumn6"] = "Test" + i.ToString();
DataTable2.Rows.Add(dr);
}
return DataTable2;
}