If I were to use the DataReport in VB6, how could I call the report
to how a Print Preview, then an option to print to printer? Thanks.

>As Eric said...
>
>You can use the Crystal Reports with comes with VB CD .. or use the VB Datareport .. but in this case I think crystal is beter.
>
>
>
>>>>>>Which report tool is best to be used in VB6 and Access 2000
>>>>>>database? Thanks.
>>>>>
>>>>>I prefer Active Reports (www.datadynamics.com). More code to write but a lot more flexibility!
>>>>>
>>>>>Access reports are not to bad too.
>>>>>
>>>>>One thing for sure, forget the DataReport that comes with VB6!
>>>>
>>>>If I were to use Access 2000 reporting feature, how can I call from
>>>>my VB6 application? Some sample example would be appreciated. Thanks.
>>>
>>>Notice that you need to install Access to every PC with that solution (meaning more licences to buy).
>>>

>>>Const dbPathName = "c:\database.mdb"
>>>Const strPassword = "PASSWORD"
>>>Dim Acc As Object, db As Object
>>>
>>>Set Acc = CreateObject("Access.Application")
>>>Set db = Acc.Application.DBEngine.Workspaces(0).OpenDatabase(dbPathName, 0, False, ";pwd=" & strPassword)
>>>Acc.OpenCurrentDatabase dbPathName, False
>>>Set db = Nothing
>>>Acc.DoCmd.OpenReport "ReportName", acPreview
>>>Set Acc = Nothing
>>>

>>
>>Any Reporting tools are free for use? As user need to pay too much
>>for license.