printing a report from database

Question

Hello I have an Access database which I write to and read from VB.NET. This database keeps records of pressure gauges that have passed a certain test. What I need to do is print out a Certificate of Compliance sheet which has some fields from the database which need to be entered. After the user finishes the test and enters the data in the database he/she will press a button which will print out this Certificate of Compliance with the data that the user just entered. I also have a datagrid and was wondering if I could do that same thing but have the user just select the record to print a report for. All this is done is VB.NET even though I know you can do it in VBA but dont know how to exactly. Thank you.

HERBERTS NGOBOLA · Answer

Please try this: Private Sub Form_Load() Set report = CreateObject(FastReport.TfrxReport) report.LoadReportFromFile (Parameter_demo.fr3) End Sub Private Sub Form_Unload(Cancel As Integer) Set report = Nothing End Sub Dim report As FastReport.TfrxReport. This is in Fast ReportsHope it helps.

MythicalMe · Answer

As you haven't specified anything in particular just use the PrintDocument control. Here is a link on how to use it effectively: http://www.vbdotnetheaven.com/Code/Jun2003/2087.asp