Sorry Alvin,

I didn't reach this step yet.. I will not be able to help in this.

Regrds

>I started the Crystal Report by the VB6 Add-Ins menu.
>How could I call the report in my application to run the report. 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.