Reporting Software Advice

[dcarlson]

I was just wondering what type of reporting options there are for VB6. I'm currently using the downloadable Crystal Reports Designer Component (crap) and I'm looking to purchase a Reporting software package. Probably a full version of Crystal Reports.

Thanks,

[ScottF]

There some goog one out there if you got the money. I had the same problem and I started biulding my report in Access and then SQl a DOA on the Table that the report is connect to then using VB to Print it or preview it, This is the code I got Online
The code below will print to the default printer, but I have figured out how to print preview it yet, if you do, please let me know how you did it.

Hope it works for you. :-)
============================================================

Private Sub Command1_Click() 'This code is trial code for printing reports.
Dim oAccess As Object
' This was the toughest part. Getting the db name and location right! (and drive)
Const gDBName = "C:\My Documents\dbMine.mdb"

On Error GoTo Command1_Click_Error

Screen.MousePointer = vbHourglass
Set oAccess = CreateObject("Access.Application")

With oAccess
.OpenCurrentDatabase (gDBName)
' Here I changed to Preview report, "acViewPreview".
' Lookup OpenReport in Access Help, only trouble is it doesn't work
.DoCmd.OpenReport "rptTest", acViewPreview
End With

Set oAccess = Nothing
Screen.MousePointer = vbNormal
Exit Sub
Command1_Click_Error:
MsgBox "Error: " & Err & " - " & Error
End
End Sub