SqlDataAdapter da = new SqlDataAdapter("SELECT * from BillMaster where InvoiceNo ='" + inv + "'", cs); // SqlDataAdapter da = new SqlDataAdapter("SELECT * from BillMaster where InvoiceNo = INV-78472734", cs); // SqlDataAdapter da = new SqlDataAdapter("SELECT * from Sales ", cs); DataSet4 dr = new DataSet4(); da.Fill(dr.View4); CrystalReport4 cr = new CrystalReport4(); cr.SetDataSource(dr); crystalReportViewer1.ReportSource = cr; PrintDocument pd = new PrintDocument(); string defaultPrinter = pd.PrinterSettings.PrinterName; height += (cr.Rows.Count * 5F); // MessageBox.Show("Test: " + height); PaperSize pkCustomSize1 = new PaperSize("First custom size", 4, (int)height); pd.DefaultPageSettings.PaperSize = pkCustomSize1; foreach (PaperSize paperSize in pd.PrinterSettings.PaperSizes) { if (paperSize.PaperName == "Envelope Monarch") { //MessageBox.Show("Test: " + rptDocument.PrintOptions.PaperSize); try { cr.PrintOptions.PaperSize = (CrystalDecisions.Shared.PaperSize)paperSize.RawKind; } catch (Exception Ex) { MessageBox.Show("Exception: " + Ex); return; } //crystalReportViewer1.Refresh(); } } MessageBox.Show("Test: " + cr.PrintOptions.PaperSize); MessageBox.Show("Test: " + pd.DefaultPageSettings.PaperSize); // cr.PrintOptions.ApplyPageMargins(pageMargins); crystalReportViewer1.RefreshReport(); crystalReportViewer1.Show(); // cr.PrintOptions.PrinterName = "Hewlett-Packard LaserJet 4100 Series"; // cr.PrintToPrinter(1,false, 0, 0); // crystalReportViewer1.Refresh();}
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)