Print report without preview

Question

I am using Visual Studio 2010 C # Windows Forms Application + MySql I have a Report Viewer that works 100%. The reportviewer is filled with data from my database, it is displayed, I press the button to print, and it prints ... BUT, my client does not want to click on this button, he wants to print automatically. When I call ReportViewer, it prints by itself without having to click on a button to do this. Can someone tell me how I do this?

I tried reportviewer1.print and PrintDocument from the toolbar. But I do not know how to use them correctly.

Thank you, attention!

Answer 1

I had the same problem as the code I use and it works like a charm!

using System; using System.IO; using System.Text; using System.Globalization; using System.Drawing; using System.Drawing.Imaging; using System.Drawing.Printing; using Microsoft.Reporting.WinForms; using System.Collections.Generic; using System.Collections.Specialized; using System.Diagnostics; using System.ComponentModel; using System.Data; using System.Linq; using System.Threading.Tasks; using System.Windows.Forms; namespace NewLabelPrinter { /// <summary> /// The ReportPrintDocument will print all of the pages of a ServerReport or LocalReport. /// The pages are rendered when the print document is constructed. Once constructed, /// call Print() on this class to begin printing. /// </summary> class AutoPrintCls : PrintDocument { private PageSettings m_pageSettings; private int m_currentPage; private List<Stream> m_pages = new List<Stream>(); public AutoPrintCls(ServerReport serverReport) : this((Report)serverReport) { RenderAllServerReportPages(serverReport); } public AutoPrintCls(LocalReport localReport) : this((Report)localReport) { RenderAllLocalReportPages(localReport); } private AutoPrintCls(Report report) { // Set the page settings to the default defined in the report ReportPageSettings reportPageSettings = report.GetDefaultPageSettings(); // The page settings object will use the default printer unless // PageSettings.PrinterSettings is changed. This assumes there // is a default printer. m_pageSettings = new PageSettings(); m_pageSettings.PaperSize = reportPageSettings.PaperSize; m_pageSettings.Margins = reportPageSettings.Margins; } protected override void Dispose(bool disposing) { base.Dispose(disposing); if (disposing) { foreach (Stream s in m_pages) { s.Dispose(); } m_pages.Clear(); } } protected override void OnBeginPrint(PrintEventArgs e) { base.OnBeginPrint(e); m_currentPage = 0; } protected override void OnPrintPage(PrintPageEventArgs e) { base.OnPrintPage(e); Stream pageToPrint = m_pages[m_currentPage]; pageToPrint.Position = 0; // Load each page into a Metafile to draw it. using (Metafile pageMetaFile = new Metafile(pageToPrint)) { Rectangle adjustedRect = new Rectangle( e.PageBounds.Left - (int)e.PageSettings.HardMarginX, e.PageBounds.Top - (int)e.PageSettings.HardMarginY, e.PageBounds.Width, e.PageBounds.Height); // Draw a white background for the report e.Graphics.FillRectangle(Brushes.White, adjustedRect); // Draw the report content e.Graphics.DrawImage(pageMetaFile, adjustedRect); // Prepare for next page. Make sure we haven't hit the end. m_currentPage++; e.HasMorePages = m_currentPage < m_pages.Count; } } protected override void OnQueryPageSettings(QueryPageSettingsEventArgs e) { e.PageSettings = (PageSettings)m_pageSettings.Clone(); } private void RenderAllServerReportPages(ServerReport serverReport) { try { string deviceInfo = CreateEMFDeviceInfo(); // Generating Image renderer pages one at a time can be expensive. In order // to generate page 2, the server would need to recalculate page 1 and throw it // away. Using PersistStreams causes the server to generate all the pages in // the background but return as soon as page 1 is complete. NameValueCollection firstPageParameters = new NameValueCollection(); firstPageParameters.Add("rs:PersistStreams", "True"); // GetNextStream returns the next page in the sequence from the background process // started by PersistStreams. NameValueCollection nonFirstPageParameters = new NameValueCollection(); nonFirstPageParameters.Add("rs:GetNextStream", "True"); string mimeType; string fileExtension; Stream pageStream = serverReport.Render("IMAGE", deviceInfo, firstPageParameters, out mimeType, out fileExtension); // The server returns an empty stream when moving beyond the last page. while (pageStream.Length > 0) { m_pages.Add(pageStream); pageStream = serverReport.Render("IMAGE", deviceInfo, nonFirstPageParameters, out mimeType, out fileExtension); } } catch (Exception e) { MessageBox.Show("possible missing information :: " + e); } } private void RenderAllLocalReportPages(LocalReport localReport) { try { string deviceInfo = CreateEMFDeviceInfo(); Warning[] warnings; localReport.Render("IMAGE", deviceInfo, LocalReportCreateStreamCallback, out warnings); } catch (Exception e) { MessageBox.Show("error :: " + e); } } private Stream LocalReportCreateStreamCallback( string name, string extension, Encoding encoding, string mimeType, bool willSeek) { MemoryStream stream = new MemoryStream(); m_pages.Add(stream); return stream; } private string CreateEMFDeviceInfo() { PaperSize paperSize = m_pageSettings.PaperSize; Margins margins = m_pageSettings.Margins; // The device info string defines the page range to print as well as the size of the page. // A start and end page of 0 means generate all pages. return string.Format( CultureInfo.InvariantCulture, "<DeviceInfo><OutputFormat>emf</OutputFormat><StartPage>0</StartPage><EndPage>0</EndPage><MarginTop>{0}</MarginTop><MarginLeft>{1}</MarginLeft><MarginRight>{2}</MarginRight><MarginBottom>{3}</MarginBottom><PageHeight>{4}</PageHeight><PageWidth>{5}</PageWidth></DeviceInfo>", ToInches(margins.Top), ToInches(margins.Left), ToInches(margins.Right), ToInches(margins.Bottom), ToInches(paperSize.Height), ToInches(paperSize.Width)); } private static string ToInches(int hundrethsOfInch) { double inches = hundrethsOfInch / 100.0; return inches.ToString(CultureInfo.InvariantCulture) + "in"; } } 

}

This class has the perfect setting for what you need, but all you need to do is:

 private void AutoPrint() { AutoPrintCls autoprintme = new AutoPrintCls(reportViewer1.LocalReport); autoprintme.Print(); } 

and hey presto is typing. Just attach this to the method in your code (maybe after the report loads.) And your setup is beautiful!

: (not verified)

As indicated, this prints to the default printer, to change the printer, you can do the following:

 if (printDialog.ShowDialog() == DialogResult.OK) { m_pageSettings .PrinterSettings.PrinterName = printDialog.PrinterSettings.PrinterName; } 

not tested, although I no longer have the source code to test this.

Answer 2

If my Crystal Report query does not work for you, you can also try this page . Again, I have not tested it and cannot be sure that it works, but it looks like a completely different way that might work. If not, then I will not help, unfortunately.

Answer 3

So we do it with Crystal Reports.

  ReportDocument rd = new ReportDocument(); // Insert code to run the report here // This gets the user default printer to print to. PrintDialog prt = new PrintDialog(); rd.PrintOptions.PrinterName = prt.PrinterSettings.PrinterName; // This does the printing. rd.PrintToPrinter(copies, true, 1, 1000); 

I think that the equivalent of PrintOptions.PrinterName would be ReportViewer.PrinterSettings for you, but I suspect that you really need it, is the equivalent of PrintToPrinter() , which I do not see in my brief look.