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.
<><><><><><><><><><><><><><><><><><><><>
<><> REMEMBER,,,,KNOWLEDGE IS POWER <><>
<><><><><><><><><><><><><><><><><><><><>