Print crystal report in thermal printer, short or large receipts

Print crystal report in thermal printer, short or large receipts

Video can be viewed on this link https://youtu.be/SyPma9Pcj5Y

1. Design crystal report
2. Right click on report -> design -> Page setup, set its height too large like 3000 pixel
3. 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”
4. 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();

}