vfp and crystals repots can they be linked?

[mutisya7906]

can visual foxpro be linked with crystals reports?

 

[Mike Lewis]

Yes.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips, training, consultancy

 

[mutisya7906]

mikelewis please help me with a code which can link them

 

[Mike Lewis]

What exactly do you need? Are you talking about accessing VFP data from Crystal? Or displaying a CR report withing a Foxpro application? Or what?

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips, training, consultancy

 

[mutisya7906]

accessing vfp data from crystal

 

[Mike Lewis]

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

 

[mutisya7906]

thanks alot mike,i appreciate your concerned,thanka again

 

[Mike Lewis]

You're welcome. Come back if you have any more problems with using CR and VFP.

You might also like to know that there's an article on my website with some relevant information: Using Crystal Reports with Visual FoxPro.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips, training, consultancy

 

[mutisya7906]

whats your website mike?

 

[JRB-Bldr]

When you click on the Using Crystal Reports... link that Mike provided above, it will take you to his website.

Good Luck,
JRB-Bldr