当前位置:首页 > Windows程序 > 正文

winform 使用 ReportViewer做报表

2021-03-18 Windows程序

public DataTable dt;

private void FormReport_Load(object sender, EventArgs e)
{
string sPath = "D:\\bzj\\MyBooks\\MyBooks\\report1.rdlc";

this.reportViewer1.LocalReport.ReportPath = sPath;

Microsoft.Reporting.WinForms.ReportDataSource reportDataSource2 = new

Microsoft.Reporting.WinForms.ReportDataSource("DataSet1_DataTable1", dt);

reportViewer1.LocalReport.DataSources.Add(reportDataSource2);


this.reportViewer1.RefreshReport();
}

说明:

dt在初始化时传入到FormReport中,如下:

ConfigFile m_ConfigFile = new ConfigFile();

int iLength = m_ConfigFile.m_iBookNameLength;

System.Data.DataTable dt = new System.Data.DataTable();
dt.Columns.Add("Name");
dt.Columns.Add("Code");
dt.Columns.Add("VIP");

for (int i = 0; i < listView1.Items.Count; i++)
{
string sName = "";
string sCode = "";


string str = listView1.Items[i].SubItems[2].Text;

if (GetLength(str) > iLength)
{
sName = (GetSubString(str, 0, iLength));
}
else
{
sName = (str);
}

sCode = (listView1.Items[i].SubItems[1].Text);

DataRow dr = dt.NewRow();
dr[0] = sName;
dr[1] = sCode;
dr[2] = textBoxName.Text+"("+textBoxID.Text+")";
dt.Rows.Add(dr);
}

FormReport mFormReport = new FormReport();
mFormReport.dt = dt;


mFormReport.ShowDialog();

当然,之前需要做好的准备包括:

1 创建数据集文件

通过系列命令:项目 右键菜单 添加 新建项 数据 数据集  来创建数据集文件(*.xsd)

在其中添加DataTable,并添加column

2 创建数据集文件

通过系列命令:项目 右键菜单 添加 新建项 reporting 报表  来创建rdlc文件(*.rdlc)

在该文件中需要指定数据源为1中创建的xsd文件

然后,就可以设计报表了。

第二种方法(不需要显示报表控件,直接用代码完成打印)

当然,还是需要设计好的rdlc文件,相关代码如下:

private int m_currentPageIndex;

/// <summary>
/// 声明一个Stream对象的列表用来保存报表的输出数据,LocalReport对象的Render方法会将报表按页输出为多个Stream对象。
/// </summary>
private IList<Stream> m_streams;

private void Print3()
{
System.Data.DataTable dt = GetDataTable();
ReportViewer rvDoc = new ReportViewer();
string sPath = string.Format("{0}\\report1.rdlc", System.Windows.Forms.Application.StartupPath);
rvDoc.LocalReport.ReportPath = sPath;//加上报表的路径
rvDoc.LocalReport.DataSources.Add(new Microsoft.Reporting.WinForms.ReportDataSource("DataSet1_DataTable1", dt));
PrintStream(rvDoc.LocalReport);
}

private System.Data.DataTable GetDataTable()
{
ConfigFile m_ConfigFile = new ConfigFile();

int iLength = m_ConfigFile.m_iBookNameLength;

System.Data.DataTable dt = new System.Data.DataTable();

dt.Columns.Add("Name");
dt.Columns.Add("Code");
dt.Columns.Add("VIP");

for (int i = 0; i < listView1.Items.Count; i++)
{
string sName = "";
string sCode = "";


string str = listView1.Items[i].SubItems[2].Text;

if (GetLength(str) > iLength)
{
sName = (GetSubString(str, 0, iLength));
}
else
{
sName = (str);
}

sCode = (listView1.Items[i].SubItems[1].Text);


DataRow dr = dt.NewRow();
dr[0] = sName;
dr[1] = sCode;
dr[2] = textBoxName.Text + "(" + textBoxID.Text + ")";
dt.Rows.Add(dr);
}

return dt;
}

private Stream CreateStream(string name, string fileNameExtension, Encoding encoding, string mimeType, bool willSeek)
{
//如果需要将报表输出的数据保存为文件,,请使用FileStream对象。
Stream stream = new MemoryStream();
m_streams.Add(stream);
return stream;
}

public void PrintStream(LocalReport rvDoc)
{


Export(rvDoc);
PrintSetting();
Dispose();
}
private void Export(LocalReport report)
{
string deviceInfo =
"<DeviceInfo>" +
" <OutputFormat>EMF</OutputFormat>" +
" <PageWidth>3in</PageWidth>" +
" <PageHeight>20in</PageHeight>" +
" <MarginTop>0.1in</MarginTop>" +
" <MarginLeft>0in</MarginLeft>" +
" <MarginRight>0in</MarginRight>" +
" <MarginBottom>0.1in</MarginBottom>" +
"</DeviceInfo>";
Warning[] warnings;
m_streams = new List<Stream>();
//将报表的内容按照deviceInfo指定的格式输出到CreateStream函数提供的Stream中。
report.Render("Image", deviceInfo, CreateStream, out warnings);
foreach (Stream stream in m_streams)
stream.Position = 0;
}

温馨提示: 本文由Jm博客推荐,转载请保留链接: https://www.jmwww.net/file/63027.html