RDLC报表的直接打印

最新推荐文章于 2019-07-04 08:51:05 发布
最新推荐文章于 2019-07-04 08:51:05 发布
阅读量1.4k 收藏
点赞数
文章标签： 报表 object stream dataset string report
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/zhoujianwen001/article/details/5569027
版权

using System;
using System.IO;
using System.Data;
using System.Text;
using System.Drawing.Imaging;
using System.Drawing.Printing;
using System.Collections.Generic;
using System.Windows.Forms;
using Microsoft.Reporting.WinForms;
using System.Data.SqlClient;


namespace RDLCReport
{
    public partial class PubPrintViewRdlcN : Form
    {
        public PubPrintViewRdlcN()
        {
            InitializeComponent();
        }

        private int m_currentPageIndex;
        private IList<Stream> m_streams;
        private System.Windows.Forms.BindingSource vBindingSource;//表BindingSource


        private DataTable LoadSalesData()
        {
            SqlConnection conn = new SqlConnection("server ='JOWEN//FLERPDATA';database = 'DB_ZFTERP';uid=zjw;pwd=");
            SqlCommand cmd = new SqlCommand("exec [PCB_H010003] '201002'",conn);
            SqlDataAdapter sda = new SqlDataAdapter();
            sda.SelectCommand = cmd;
            conn.Open();

            DataSet dataSet = new DataSet();
            sda.Fill(dataSet, "salses");

            vBindingSource = new BindingSource();
            vBindingSource.DataSource = dataSet;
            vBindingSource.DataMember = "salses";
            vBindingSource.Filter = " 产品类别 = '纸类' ";


            DataView view = new DataView(dataSet.Tables[0]);
            view.RowFilter = " 产品类别 = '纸类' ";
            DataTable newTable = view.ToTable("FilteredTable");

            dataSet.ReadXml(@"d:/My Reports/data.xml");
            //return dataSet.Tables[0];
            return newTable;

        }

        private Stream CreateStream(string name,
          string fileNameExtension, Encoding encoding,
          string mimeType, bool willSeek)
        {
            //Stream stream = new FileStream(@"d:/My Reports/" + name +
            Stream stream = new FileStream(@"c:/" + name +
              "." + fileNameExtension, FileMode.Create);
            m_streams.Add(stream);
            return stream;
        }

        private void Export(LocalReport report)
        {
            //pageSetupDialog1.PrinterSettings.ToString();
            //MessageBox.Show(pageSetupDialog1.PrinterSettings.ToString());
            string deviceInfo =
              "<DeviceInfo>" +
              "  <OutputFormat>EMF</OutputFormat>" +
              "  <PageWidth>42cm</PageWidth>" +
              "  <PageHeight>29.7cm</PageHeight>" +
              "  <MarginTop>0.3cm</MarginTop>" +
              "  <MarginLeft>0.3cm</MarginLeft>" +
              "  <MarginRight>0.3cm</MarginRight>" +
              "  <MarginBottom>0.3cm</MarginBottom>" +
              "</DeviceInfo>";

                //string deviceInfo =
                //  "<DeviceInfo>" +
                //  "  <OutputFormat>EMF</OutputFormat>" +
                //  "  <PageWidth>"+pageSetupDialog1.PageSettings.PaperSize.Width*0.01+"in</PageWidth>" +
                //  "  <PageHeight>" + pageSetupDialog1.PageSettings.PaperSize.Height * 0.01 + "in</PageHeight>" +
                //  "  <MarginTop>0.05in</MarginTop>" +
                //  "  <MarginLeft>0.05in</MarginLeft>" +
                //  "  <MarginRight>0.05in</MarginRight>" +
                //  "  <MarginBottom>0.05in</MarginBottom>" +
                //  "</DeviceInfo>";

                //"<DeviceInfo>" +
                //"  <OutputFormat>EMF</OutputFormat>" +
                //"  <PageWidth>8.5in</PageWidth>" +
                //"  <PageHeight>11in</PageHeight>" +
                //"  <MarginTop>0.25in</MarginTop>" +
                //"  <MarginLeft>0.25in</MarginLeft>" +
                //"  <MarginRight>0.25in</MarginRight>" +
                //"  <MarginBottom>0.25in</MarginBottom>" +
                //"</DeviceInfo>";
            Warning[] warnings;
            m_streams = new List<Stream>();
            report.Render("Image", deviceInfo, CreateStream, out warnings);

            foreach (Stream stream in m_streams)
                stream.Position = 0;
        }

        //private void PrintPage(object sender, PrintPageEventArgs ev)
        //{
        //        Metafile pageImage = new Metafile(m_streams[m_currentPageIndex]);
        //        ev.Graphics.DrawImage(pageImage, ev.PageBounds);

        //        m_currentPageIndex++;
        //        ev.HasMorePages = (m_currentPageIndex < m_streams.Count);

        //        //if (m_currentPageIndex == m_streams.Count) m_currentPageIndex = 1;

        //}

        //private void Print()
        //{
        //    //const string printerName = "Microsoft Office Document Image Writer";
        //    const string printerName = "Samsung ML-2850 PCL6";
        //    if (m_streams == null || m_streams.Count == 0)
        //        return;

        //    PrintDocument printDoc = new PrintDocument();
        //    //printDoc = new PrintDocument();

        //    printDoc.PrinterSettings.PrinterName = printerName;
        //    if (!printDoc.PrinterSettings.IsValid)
        //    {
        //        string msg = String.Format("Can't find printer /"{0}/".", printerName);
        //        MessageBox.Show(msg, "Print Error");
        //        return;
        //    }
        //    printDoc.PrintPage += new PrintPageEventHandler(PrintPage);
           
           

        //    printDialog1.Document = printDoc;
        //    printDialog1.ShowDialog();

        //    pageSetupDialog1.Document = printDoc;
        //    pageSetupDialog1.ShowDialog();

        //    //printPreviewDialog1.Document = printDoc;
        //    //printPreviewDialog1.ShowDialog();


        //    printDoc.Print();
        //}


        //private void Run()
        //{
        //    LocalReport report = new LocalReport();
        //    //report = new LocalReport();

        //    report.ReportPath = @"c:/My Reports/Report.rdlc";
        //    report.DataSources.Add(new ReportDataSource("Sales", LoadSalesData()));

        //    Export(report);

        //    m_currentPageIndex = 0;

        //    Print();
        //}


        private void printDocument1_PrintPage(object sender, PrintPageEventArgs e)
        {

            try
            {
                if (printDialog1.PrinterSettings.PrintRange == PrintRange.AllPages)
                {
                   
                    Metafile pageImage = new Metafile(m_streams[m_currentPageIndex]);
                    e.Graphics.DrawImage(pageImage, e.PageBounds);
                    m_currentPageIndex++;
                    e.HasMorePages = (m_currentPageIndex < m_streams.Count);
                }
                else if (printDialog1.PrinterSettings.PrintRange == PrintRange.CurrentPage)
                {
                    Metafile pageImage = new Metafile(m_streams[printPreviewControl1.StartPage]);
                    e.Graphics.DrawImage(pageImage, e.PageBounds);
                    m_currentPageIndex = printPreviewControl1.StartPage;
                    //m_currentPageIndex++;
                    //e.HasMorePages = (m_currentPageIndex < m_streams.Count);                 
                }
                else if (printDialog1.PrinterSettings.PrintRange == PrintRange.SomePages)
                {
                    if (m_currentPageIndex == 0) { m_currentPageIndex = printDialog1.PrinterSettings.FromPage-1; }

                    if (m_currentPageIndex >= printDialog1.PrinterSettings.FromPage-1 && m_currentPageIndex <= printDialog1.PrinterSettings.ToPage-1)
                    {
                        Metafile pageImage = new Metafile(m_streams[m_currentPageIndex]);
                        e.Graphics.DrawImage(pageImage, e.PageBounds);
                        m_currentPageIndex++;
                        if (m_currentPageIndex >= printDialog1.PrinterSettings.FromPage - 1 && m_currentPageIndex <= printDialog1.PrinterSettings.ToPage - 1)
                        {
                        e.HasMorePages = (m_currentPageIndex < m_streams.Count);                         
                        }               
                    }
                }
            }
            catch (Exception)
            {
                //throw;
            }
        }

 


        private void Form1_Load(object sender, EventArgs e)
        {
            m_currentPageIndex = 0;

            LocalReport report = new LocalReport();

            report.ReportPath = @"d:/My Reports/Report.rdlc";
            report.DataSources.Add(new ReportDataSource("DB_ZFTERPDataSetZJW_H010003", LoadSalesData()));

            LoadSalesData();

            //vBindingSource.SupportsFiltering = true;
            //vBindingSource.Filter = "产品类别 = '纸类' ";
         //   vBindingSource.Remove("产品类别 = '纸类'");
            //vBindingSource.Sort = "产品类别";
 
            //report.DataSources.Add(new ReportDataSource("DB_ZFTERPDataSetZJW_H010003", vBindingSource));
           
            Export(report);

            //const string printerName = "Samsung ML-2850 PCL6";
            //if (m_streams == null || m_streams.Count == 0)
            //    return;

            //printDocument1.PrinterSettings.PrinterName = printerName;
            //if (!printDocument1.PrinterSettings.IsValid)
            //{
            //    string msg = String.Format("Can't find printer /"{0}/".", printerName);
            //    MessageBox.Show(msg, "Print Error");
            //    return;
            //}

            //printDialog1.Document = printDocument1;
            //printDialog1.ShowDialog();

            pageSetupDialog1.Document = printDocument1;
            pageSetupDialog1.ShowDialog();

            printPreviewControl1.Document = printDocument1;
            printPreviewControl1.Show();
            printPreviewControl1.Zoom = 1;

            printPreviewControl1.StartPage = 0;
            tsl1.Text = "第" + "1" + "页,共" + m_streams.Count.ToString() + "页";

        }

        private void toolStripButton3_Click(object sender, EventArgs e)
        {
            m_currentPageIndex = 0;

            LocalReport report = new LocalReport();
            //report = new LocalReport();

            report.ReportPath = @"d:/My Reports/Report.rdlc";

           

 

            report.DataSources.Add(new ReportDataSource("DB_ZFTERPDataSetZJW_H010003", LoadSalesData()));

            Export(report);

            //const string printerName = "Samsung ML-2850 PCL6";
            //if (m_streams == null || m_streams.Count == 0)
            //    return;


            //printDocument1.PrinterSettings.PrinterName = printerName;
            //if (!printDocument1.PrinterSettings.IsValid)
            //{
            //    string msg = String.Format("Can't find printer /"{0}/".", printerName);
            //    MessageBox.Show(msg, "Print Error");
            //    return;
            //}

            pageSetupDialog1.Document = printDocument1;
            pageSetupDialog1.ShowDialog();

            printDialog1.Document = printDocument1;
            //printDialog1.ShowDialog();

            DialogResult result = printDialog1.ShowDialog();

            // If the result is OK then print the document.
            if (result == DialogResult.OK)
            {
                printDocument1.Print();
            }


           
        }

 

        private void toolStripMenuItem2_Click(object sender, EventArgs e)
        {
            printPreviewControl1.Zoom = 0.25;
        }

        private void toolStripMenuItem3_Click(object sender, EventArgs e)
        {
            printPreviewControl1.Zoom = 0.5;
        }

        private void toolStripMenuItem4_Click(object sender, EventArgs e)
        {
            printPreviewControl1.Zoom = 0.75;
        }

        private void toolStripMenuItem5_Click(object sender, EventArgs e)
        {
            printPreviewControl1.Zoom = 1;
        }

        private void toolStripMenuItem6_Click(object sender, EventArgs e)
        {
            printPreviewControl1.Zoom = 1.25;
        }

        private void toolStripMenuItem7_Click(object sender, EventArgs e)
        {
            printPreviewControl1.Zoom = 1.5;
        }

        //第一页
        private void toolStripButton4_Click(object sender, EventArgs e)
        {
            printPreviewControl1.StartPage = 0;
            tsl1.Text = "第" + "1" + "页,共" + m_streams.Count.ToString() + "页";
            //printPreviewControl1.Columns = 3;
            //printPreviewControl1.Refresh();
        }


        //最后一页
        private void toolStripButton7_Click(object sender, EventArgs e)
        {
            printPreviewControl1.StartPage = m_streams.Count - 1;
            tsl1.Text = "第" + m_streams.Count.ToString() + "页,共" + m_streams.Count.ToString() + "页";
            printPreviewControl1.Refresh();
        }

        //前一页
        private void toolStripButton5_Click(object sender, EventArgs e)
        {
            if (printPreviewControl1.StartPage != 0)
            {
            printPreviewControl1.StartPage = printPreviewControl1.StartPage - 1;
            tsl1.Text = "第" + (printPreviewControl1.StartPage + 1).ToString() + "页,共" + m_streams.Count.ToString() + "页";           
            }
        }

        //后一页
        private void toolStripButton6_Click(object sender, EventArgs e)
        {
            //if (printPreviewControl1.StartPage != m_currentPageIndex-1)
            //{
            try
            {
                printPreviewControl1.StartPage = printPreviewControl1.StartPage + 1;
                tsl1.Text = "第" + (printPreviewControl1.StartPage + 1).ToString() + "页,共" + m_streams.Count.ToString() + "页";

            }
            catch (Exception)
            {
               
                //throw;
            }           
            //}
        }

        private void PubPrintViewRdlcN_FormClosing(object sender, FormClosingEventArgs e)
        {
            if (m_streams != null)
            {
                foreach (Stream stream in m_streams)
                    stream.Close();
                m_streams = null;
            }
        }

        private void toolStripButton1_Click(object sender, EventArgs e)
        {
            this.Close();
        }

 

 

        //public void Dispose()
        //{
        //    if (m_streams != null)
        //    {
        //        foreach (Stream stream in m_streams)
        //            stream.Close();
        //        m_streams = null;
        //    }
        //}

    }
}

zhoujianwen001
关注
RDLC 报表打印
weixin_39874268的博客
08-25 1367
报表rdlc怎样直接打印？ 原帖地址：http://bbs.csdn.net/topics/370121874
c# 不预览 直接打印rdlc 不用reportviewer
05-13
直接打印rdlc ，不用reportviewer 预览
动态RDLC报表完整实例和代码
08-09
在没有rdlc为后缀的报表文件和没有xsd为后缀的DataSet数据源的情况下，依据从数据库中获取的数据生成RDLC报表。 Visual Studio 的最新版本是2022，在以住的版本中微软都会有一个 Microsoft RDLC Report Designer 插件来给我们设计报表，通过这个插件就可以用图形化的界面很方便、快速地做出想要的各种复杂的报表来。但我找了好长时间都没有找到 Visual Studio 2022 中适用的 Microsoft RDLC Report Designer，2019版本的 Microsoft RDLC Report Designer 也不能安装在 Visual Studio 2022中，我不知道以后会不会有适用于 Visual Studio 2022 的 Microsoft RDLC Report Designer，至少到现在我都未能找到。
RDLC ReportView 直接打印功能
06-06
RDLC ReportView 没有直接打印功能，不过可以通过展现方式来实现直接打印功能
直接打印RDLC报表
08-27
直接调用，传递参数即可 可在asp.net下或winform下使用，无需预览直接进行打印，可根据自己的需要进行修改 有适当的备注
RDLC 使用经验谈
走错路的程序员
09-23 4507
以前在用devExpress 的报表控件. 由于需要注册.费用. 而且里面的报表控件有bug 会无辜多出来几个空白页面. 实在解决不了了. 于是研究了RDLC.指南部分. 我对RDLC总的感觉是. RDL 报表描述语言是起源于sqlserver 的报表服务器. 所以它不可避免的更倾向于 系统IT维护人员的工作模式. 直接SQL连接数据库,然后取出DataTable. 再设计个报表视图模版.
RDLC报表直接打印
05-08
RDLC、printDocument1的报表直接打印
C# RDLC报表不出现预览窗体直接输出到打印机
weixin_30585437的博客
02-18 938
#region 直接打印区域 /// <summary> /// 直接打印到打印机 /// </summary> /// <param name="reportFullFileName"></param> /// <param name...
【.Net码农】RDLC（Reportview）报表直接打印，支持所有浏览器，客户可在linux下浏览使用
能看代码的CrackLibby
10-08 3700
http://www.cnblogs.com/bfyx/p/3279385.html RDLC（Reportview）报表直接打印，支持所有浏览器，客户可在linux下浏览使用 最近在做一个打印清单的，但是rdlc报表自带的工具栏中的打印按钮只有在ie内核下的浏览器才可以使用（其他的就会 隐藏），这导致了使用火狐和谷歌浏览器还有使用linux系统的客户打
rdlc报表打印
小小的花园里面挖呀挖呀～
09-22 624
从数据库显示数据和传递参数 string sql = "select ids,roomid from room where ids =2"; DataTable dt = dbutil.huoqu(sql); ReportDataSource rds = new ReportDataSource("DataSet1", dt)
C# WinForm RDLC报表打印
09-01
C# WinForm RDLC报表打印，不用自带打印方式，解决空白页和字体大小问题，博客中也有写RDLC客户端注意事项，
rdlc报表的打印
02-10
rdlc报表的条码打印，内含打印对话框的调用打印按钮的api，
RDLC自动打印
02-15
通过一个button按钮就能打印rdlc报表，而不是通过rdlc自带的打印程序
C# RDLC报表打印实例
11-21
C# RDLC报表打印实例 项目描述 C# RDLC 报表打印实例 本实例上传带的数据库是SQL SERVER 2005生成的， 在本实例中，包括了基本的报表分组、统计、表达式获得系统时间、获得本机IP。 RDLC 1、简单易用的控件，特别是Table控件，非常方便字段在报表上的排列； 2、灵活的可定制性，用XML来描述一个报表相关的一切，不用说了吧？ 3、高度可编程性，在你的项目中，甚至不需要有一个报表文件，通过代码就可以实现报表生成、预览和打印等一系列操作； 4、支持DrillThrough数据钻取功能； 5、导出的Excel文件格式非常完美，任何其它报表在这方面都不能与之比拟，而且并不需要安装Excel
VS2017、WPF使用报表工具RDLC完成报表,打印预览和直接打印-附件资源
03-05
VS2017、WPF使用报表工具RDLC完成报表,打印预览和直接打印-附件资源
C# 在不预览的情况下直接打印RDLC并解决了只打印一部分的bug RDLC连打.
走错路的程序员
07-04 2252
#region 报告打印相关代码 private void barPrint_Click(object sender, EventArgs e) { try { LocalReport localReport = new LocalReport(); R...
关于Rdlc文件直接打印浅谈
默默捂蚊的专栏
12-24 4618
      rdlc Report是.net提供给我们的一个免费使用的一个文件，拥有强大的功能。下面我来谈谈关于rdlc文档直接打印遇到的一些问题以及解决办法，希望对大家有所帮助,也希望有好的方法留言.      关于 rdlc 直接打印是一个老生常谈的问题了，现在网络上比较常见的就是"泥人张"所写的那个打印方法。这种方法确实很好用，但是在用的中间也遇到很多问题.     这段打印分成两个
Winform rdlc 报表的直接打印
07-23 1690
把类 ReportClass 引入项目 using System; using System.Collections.Generic; using System.Data; using System.Data.SqlClient; using System.Drawing.Imaging; using System.Drawing.Printing; using System.IO;
ASP.NET与WinForm下直接打印RDLC报表
在ASP.NET和Winform环境中，直接打印 RDLC (Report Definition Language) 报表是一项常见的任务，特别是在处理大量数据和简化工作流程时。本篇代码示例展示了如何在C#中利用`Microsoft.Reporting.WebForms`类库实现...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值