rdlc报表导出到excel只导出一行.而且报表的页眉和页脚都没有导出,为什么?
各位好,向大家请教个问题,是这样的,我把rdlc报表的数据导出到excel时,发现rdlc报表导出到excel只导出一行,而且报表的页眉和页脚都没有导出,不知道是为什么,下面是我的代码,请知道的帮忙告诉一声,先在此谢谢各位了.
protected void Button1_Click(object sender, EventArgs e)
{
DataTable xwk = new DataTable();
xwk = (DataTable)Session["dt"];
LocalReport lr = new LocalReport();
string deviceInfo =
"<DeviceInfo>" +
" <OutputFormat>PDF</OutputFormat>" +
" <SimplePageHeaders>True</SimplePageHeaders>" +
"</DeviceInfo>";
lr.ReportPath = @"D:\database\viiPOS 2.5.0 - DigitalRev\viiPOSManagerCore\Document\ENG\xwk.rdlc";
lr.DataSources.Add(new ReportDataSource("dsRpt_Stock_vi_rpt_stock_summary", xwk));
string mimeType, encoding, extension;
string[] streams;
Warning[] warnings;
byte[] bytes = lr.Render(
"PDF",
deviceInfo,
out mimeType,
out encoding,
out extension,
out streams,
out warnings);
using (FileStream fs = new FileStream(@"c:\Sales.pdf", FileMode.Create))
{
fs.Write(bytes, 0, bytes.Length);
fs.Close();
}
}