Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Execute a Access Report
Message
From
06/12/2001 17:21:33
 
 
To
06/12/2001 16:38:28
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00590746
Message ID:
00590876
Views:
22
>>
>>I don't think this is possible. You have to base the report on a query or table that somehow is populated with the contents of your cursor. Two ways to do it that come to mind are:
>>- base the report on a linked fp2.6 table, write the cursor with COPY TO TYPE FOX2X
>>- base the report on an odbc query to a vfp free table, write the cursor to this table.
>>
>>HTH
>
>i found the solution :
>
>x = GETOBJECT('c:\reportfox.mdb','access.application')
>x.visible = .t.
>x.OpenCurrentDatabase("c:\reportfox.mdb")
>x.DoCmd.TransferDatabase(2,"odbc","ODBC;DSN=testing;DATABASE=datebase",,"tabletest","tabletest")

That's yet another way. Basically an import of the tabletest table into an Access table. I assume you wrote the cursor into a DBF before doing this.
Previous
Reply
Map
View

Click here to load this message in the networking platform