I will explain this like i was a 6 year old so everyone can listen.

I have an application made in vfp, I made the reports in crystal reports. Well the problem is that the app is multi company, and each company has DB in SQL SERVER, well when I want to print a report it brings the same data, data that comes from the table that I use to create the report. Well I put off the option in crystal that says “Save data with report”. Then later I thought that the component it is limited. So I select the RDC of crystal. In VB is easy to use it, cause you add the component from the menu, in the part of adding components, automaticly vb puts an option of crystal in the menu, you use this option and that adds a form with the crystal component cviewer, and in addition to that you can use the craxdrt.dll (his application part(craxdrt.application) and the report(craxdrt.report)) for setting the location and table, example:

Dim appl As New CRAXDRT.Application
Dim report As New CRAXDRT.report
Dim carlos As CRViewer


Public Sub imprimir()
Set report = appl.OpenReport("C:\report1.rpt")
report.Database.Tables.Item(1).SetLogOnInfo "nomsql", "nomasystec", "sa", ""
report.Database.Tables.Item(1).Location = "nomasystec.dbo.departam"

carlos.ReportSource = report
carlos.PrintReport

End Sub

But in fox, something is missing, I cant add it threw the part of tool - menu – control. And when I want to say: “ocrystal = createobject(“craxdrt.application”)”, it says that it did not find it. In VB I can say this but first I have to go to the menu and click the add crystal report, and then is that I can declare variables as the dlls.

Conclusion: I need to use this components in order to change that DB for my reports, I know that it can be done, because I have seen other sw do it, like VAM-SQL that run the reports in crystal, Can someone show me to do this in Fox, not vb?, cause my problem is not to say ovariable = crateobject(“something.dll”) its that I cannot find the way to vfox calls the RDC components.