How to fetch database detailsin pre-printed copy using rdlc

Question

hi frnds I am working in c# Windows forms I want to design invoice in pre-printed copy using rdlc report. I have to fetch database details in that pre-printed copy and dot matrix printer is used to print the invoice. How to align the data's in pre-printed invoice form? While fetching values from database in rdlc report the textbox values shrink or expand automatically. How to do this?

sridevi u · Answer

I have a blank certificate or invoice copy in that I want to print data(from database) using rdlc report in dot matrix printer. Please help me it is urgent.

Joginder Banger · Answer

Hi sridevi U if you want align of RDLC report then open the reports in Reportviewer set the page as per requirements. Last I was set the align on TVS LP-45 printers. you can set the printer setting as per requirements System.Drawing.Printing.PageSettings pg = new System.Drawing.Printing.PageSettings(); //Margin Top set here... pg.Margins.Top = 1; pg.Margins.Bottom = 1; pg.Margins.Left = 0; pg.Margins.Right = 0; // pass the page setting in local report setting . reportViewer1.SetPageSettings(pg); // hide the print button this.reportViewer1.ShowPrintButton = false; this.reportViewer1.RefreshReport(); // set the parameters in reportviwer this.reportViewer1.LocalReport.SetParameters(parameter); // refres here ... clear all old values .. this.reportViewer1.LocalReport.Refresh(); this.reportViewer1.SetDisplayMode(DisplayMode.PrintLayout); which version of visual studio are using. In 2013 have lots of option are available. check this link I hope some help you. http://www.codeproject.com/Articles/31862/Dynamic-Binding-Of-RDLC-To-ReportViewer