Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP Data Sources - Newbie
Message
From
27/02/2009 16:23:52
 
General information
Forum:
Visual FoxPro
Category:
Crystal Reports
Miscellaneous
Thread ID:
01384669
Message ID:
01384681
Views:
68
You have to use CR 11, R2. If you don't have that update, you can download from the Business Objects web site.

>Just installed Crystal Report 11. Want to use a VFP table as a data source in the Crystal Report designer. I have read that there are three options:
>
>1) Native access. I assume that this means to select "Create New Connection", "Database Files", then select the .dbf file. (I did COPY TO ... TYPE FOX2X to create a FOX2X table). The .dbf File Type says it is a xBase table. And when I try to Open the .dbf I get a "Failed to Load Database Information", then "Unknown Database Connector Error".
>
>2) ODBC. How do I use this screen? In odbcad32.exe I created a User DSN that paths to a specific folder that has .dbf files in it. But how do I use this the Crystal Report Data Source Select to be more generic - to open any .dbf table without having to go to odbcad32.exe first? Visual Foxpro tables is a Data Source Name. Just do not have any DSN in my C:\Program Files\Common Files\ODBC\Data Sources folder.
>
>3) OLE DB. I got this to work.
>
>Now ... does anyone have any sample code to use a report from within a VFP application. Use a simple example to get me started.
>
>Thanks
>
>Brenda
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Previous
Reply
Map
View

Click here to load this message in the networking platform