Solved

FoxPro dataset and Crystal reports 2008

Posted on 2009-05-15
11
507 Views
Last Modified: 2012-05-07
Can Crystal Reports 2008 open Foxpro 9.x Datasets ? I am trying to open a dataset so I can develop a new Crystal Report but it keeps asking for a 'User name' and 'Password'.

                                                         Thanks,
                                                         Bob H
                                           
0
Comment
Question by:hums
  • 5
  • 4
  • 2
11 Comments
 
LVL 42

Expert Comment

by:pcelba
ID: 24399469
If your FoxPro data are in the folder which is accessible without password for you then FoxPro should not ask. Some small possibility is a FoxPro database event which asks for the password - you could partly recognize it by existence of .DBC file in data folder.

ANother problem could caused by fact that not all the newest FoxPro data types are supported by ODBC and ADO.

BTW, why not to use Visual FoxPro 9 report writer? It is easier and more user friendly than Crystal. You should try to open data tables in Visual FoxPro at least.
0
 

Author Comment

by:hums
ID: 24399543
The FoxPro database is from a third product that uses Crystal Reports for the report writter. I will give the .DBC file a try. The FoxPro data is in a sepeate directory.

                                                                                                       Thanks,
                                                                                                        Bob H
0
 
LVL 42

Expert Comment

by:pcelba
ID: 24399619
Another possibility would to copy .DBF, .FPT, and .CDX files of your interest to another folder and create the report on this copy.
0
How Do You Stack Up Against Your Peers?

With today’s modern enterprise so dependent on digital infrastructures, the impact of major incidents has increased dramatically. Grab the report now to gain insight into how your organization ranks against your peers and learn best-in-class strategies to resolve incidents.

 

Author Comment

by:hums
ID: 24413042
I tried to copy the  .FPT, and .CDX files and run the report from the same directory without sucess. The only *.cdx I see on the system are Datadict.cdx and DDnames.cdx. May be the reports that work are somehow run through the products data dictionary. Also I 'googled' the error message and it might be a problem with xbase type databases and Crystal Reports 2008. Anyway I will post the solution when I figure out what is wrong.

                                                                             Thanks for the info,
                                                                             Bob H
0
 
LVL 42

Expert Comment

by:pcelba
ID: 24413264
.DBFs are data, .FPTs are memo fields, and CDXes are indexes. If there are almost no indexes is not obvious but possible.

It is not so easy to open these files without Visual FoxPro installed (and it is not easy to me investigate the problem without Crystal installed :-).

I'll appreciate if you write your further observations here. Thanks.
0
 

Author Comment

by:hums
ID: 24455535
The answer that was given to us is that the RDC (COM) object is no longer support or shipped with  2008. The RDC was how the 3rd party software was hooked into FoxPro and Crystal Reports. This may be the case and there may not be a work around. All of the required *.dll's are installed on my work station so I am not going to give up yet. I think there still may be a work around to hook into the FoxPro dataset. 2008 Crystal Reports  is not going to set up any COM object type interfaces as people are used to.

                                                                                 Bob H

                                                                                                           

                                                                     
0
 
LVL 42

Expert Comment

by:pcelba
ID: 24455611
It seems, you are right - http://www.craigberntson.com/blog/2007/11/crystal-reports-2008-dont-bother.asp

I would propose to access data via ODBC driver. It is rather independent on the data source and everything you need is VFP ODBC driver and connection string.

This article confirms it: http://www.ml-consult.co.uk/foxst-19.htm

Some additional infor is here: http://www.experts-exchange.com/Microsoft/Applications/FoxPro/Q_21769827.html

So, th equestion is: Do you really need all new features of Crystal 2008?
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 24455649
The official Crystal/SAP line.  You are correct the RDC was dropped for CR2008.

https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/80bd35e5-c71d-2b10-4593-d09907d95289

mlmcc
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 24456374
According to this article Foxpro is not a supported database unless you can get database driver from Foxpro.
https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/f05523e4-35c4-2b10-2c89-9fcf64b0dd22

mlmcc
0
 
LVL 42

Expert Comment

by:pcelba
ID: 24459349
According to above document FoxPro and many more other data sources can be accessed via ODBC driver.
0
 

Accepted Solution

by:
hums earned 0 total points
ID: 24506909
Final Comment - I could not figure out a way to attach the FoxPro dataset from the 'AUS CIS' product so the only solution I could think of was to switch back to Crystal Report XI.  
0

Featured Post

Webinar: Aligning, Automating, Winning

Join Dan Russo, Senior Manager of Operations Intelligence, for an in-depth discussion on how Dealertrack, leading provider of integrated digital solutions for the automotive industry, transformed their DevOps processes to increase collaboration and move with greater velocity.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

756 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question