- April 23, 2019
- Posted by: admin
- Category: School Management Software Help, Softwares
Print crystal report in thermal printer, short or large receipts
Video can be viewed on this link https://youtu.be/SyPma9Pcj5Y
- Design crystal report
- Right click on report -> design -> Page setup, set its height too large like 3000 pixel
- Go to section expert, select paging, select your last section where your report getting end, Check the both options “Reset page number after” and “New page after”
- Go to “Printers & scanners” -> Printer properties -> change paper cutting to “After document”
- Following code is used to
print a crystal report directly from code
private void
FillReport(string where)
{
string sql = null;
sql = “select Order_id, RegularPrice, SalePrice from Inv_OrderDetails_view ” + where + ” order by ID DESC “;
SqlDataAdapter da = dbmgr.getDataAdapter(sql);
DataSets.SaleReceipt_ds ds = new DataSets.SaleReceipt_ds();
da.Fill(ds, “FillAdapter”);
Reports_Inv.SaleReceipt3_rpt objRpt = new Reports_Inv.SaleReceipt3_rpt();
fun.LoadReport(objRpt, “”, ds);
System.Drawing.Printing.PrinterSettings settings = new System.Drawing.Printing.PrinterSettings();
settings.PrinterName =
fun.GetSchoolSettings(“Small Invoice Printer”);
System.Drawing.Printing.PageSettings pagesettings = new System.Drawing.Printing.PageSettings();
pagesettings.PaperSize = new System.Drawing.Printing.PaperSize(“Custom”, 275, 3000);
objRpt.PrintToPrinter(settings,
pagesettings, false);
//crystalReportViewer1.ReportSource
= objRpt;
//crystalReportViewer1.Refresh();
}