Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

vfp and crystals repots can they be linked?

Status
Not open for further replies.

mutisya7906

Programmer
Dec 6, 2010
7
KE
can visual foxpro be linked with crystals reports?
 
Assuming you are using a recent version of VFP, you will need the Microsoft OLE DB Provider for Visual FoxPro. If your users don't already have this, they will need to download it from Microsoft and install it on their system.

You should then do the following:

1. Open Crystal Reports. Launch the report wizard. In the data page, drill down to Create New Connection, and then double-click on OLE DB (ADO).

2. In the OLE DB Provider dialogue, select Microsoft OLE DB Provider for Visual FoxPro. Click Next.

3. In the next dialogue, in the Datasource box, type the full path and filename of the DBC file that you wish to access. Click Finish.

4. You should now see the DBC file in the data page, below the node you just clicked on. Drill down to see the tables and views in the DBC.

5. Select the tables or views you want to use in the report, and drag them to the right-hand side of the dialogue.

That's all there is to it. From now on, CR will treat the data just like any other data. You don't need to do anything special because it comes from FoxPro.

Hope this helps.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips, training, consultancy
 
When you click on the Using Crystal Reports... link that Mike provided above, it will take you to his website.

Good Luck,
JRB-Bldr
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top