printing a report from database

saphiroth42

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.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

HERBERTS NGOBOLA16y ago
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 Reports,Hope it helps.
MythicalMe21y ago
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