Crystal 9 - runtime files for xBase / GoldMine 1

[marketfx]

One of our clients had some reports written in Crystal 9 for use with their GoldMine CRM system. The network users run GoldMine hosted on MSSQL. The remote users run GoldMine using dBase.

They created 2 versions of their reports - 1 for MSSQL (all tables are in the same database) and 1 for the dBase users (tables are from 2 different folders).

The SQL versions of the reports work fine, the problem is with the dBase versions of the reports

On the development workstation where Crystal is installed and the reports were developed, the user can run the report from within Crystal 9 (open the report and refresh the report data, etc.)

The dBase versions of the reports use the native xBase drivers but I have tried switching the connections to ODBC using the Microsoft drivers and I have the same problem.

Using Crystal 8.5, GoldMine users were able to run Crystal reports from within the "GoldMine Reports Center" as long as the Crystal 8.5 runtime files were installed.

Using Crystal 9, GoldMine users who are running the "MSSQL" versions of the reports have no problems as long as the Crystal 9 runtime files are installed and registered. (I've listed the runtime files that we are using at the end of this post.

When trying to launch the dBase versions of the reports from within GoldMine (whether or not Crystal 9 is installed on the workstation, the user gets the following errors:

Error #536 - Error in file - c:\goldmine\reports\nationalopportunitiescr9.rpt
Unable to connect: incorrect log on parameters

Then:
Unable to change location for table: Contact1

Then the report terminates.

According to unofficial information I have heard, the issue is related to the fact that these reports are trying to pull their data from multiple tables located in 2 different folders. (actually c:\goldmine\gmbase and c:\goldmine\common)

I've turned off the autolinking options and linked the tables manually, I've turned off the Crystal Options that would try to verify the database when it was opened (as far as I can tell). I've run out of things to try.

I do not have access to the runtime.chm file so I don't know for sure that we're using all the necessary runtime files. But, then again, I'm not even sure if the problem is really with Crystal 9, or if it's something on the GoldMine side. As I said before, we can do this with Crystal 8.5 just fine (but there's a whole lot more files in the "runtime" stuff I have for Crystal 8.5. I know Crystal 9 is a MAJOR change from Crystal 8.5.

Also, my understanding is that there is no way to create a "free-standing" exe version of the report in Crystal 9 as you can in Crystal 8.5 so we can't even run these reports "outside of GoldMine"

And, it seems that one cannot save a Crystal 9 report as a "Crystal 8.5 compatible version" so we can't use the 8.5 dlls AND we can't even redesign the report without starting from scratch in Crystal 8.5.

Any and all suggestions, ideas, workarounds, alternatives, etc., would be very much appreciated.

Thanks,

Dave Dunlap

Here are the runtime files that GoldMine supplies. Any input would be appreciated. (there are some reports that have subreports and several are configured to export to Word or Excel):

08/19/2003 11:56 PM 6,180,929 craxdrt9.dll
06/14/2003 11:41 PM 386,636 crdb_odbc.dll
07/05/2002 05:15 PM 188,416 crdb_p2bbde.dll
07/08/2003 11:06 PM 405,504 crdb_p2bxbse.dll
06/22/2003 12:03 PM 5,840,956 crpe32.dll
06/01/2003 11:25 PM 1,552,457 crqe.dll
06/09/2003 01:36 AM 795,880 crviewer9.dll
12/01/1996 04:00 PM 18,944 Implode.dll
04/06/2000 08:10 PM 401,462 msvcp60.dll
06/11/2003 11:50 PM 184,391 querybuilder.dll
07/16/2002 12:37 PM 225,280 ufmanager.dll
04/23/2002 06:30 AM 237,936 unicows.dll

 

[synapsevampire]

You can write your own viewer, or there are 3rd party viewers:

http://kenhamady.com/bookmarks.html

Or you might use Crystal Enterprise (pricey).

If the Goldmine app uses CR 8.5, then you must develop using CR 8.5, they are VERY different.

Here's a blurb on using the RDC in CR 9:

http://support.businessobjects.com/library/kbase/articles/c2012421.asp

-k

 

[marketfx]

K,

Thanks for the information. We are testing one of the viewers I found on the links page at

http://www.kenhamady.com

- Report Runner Viewer - seems to work pretty well.

I don't have the developer's edition of Crystal 9 so don't have access to the runtime.chm file. I also couldn't find it on their website. Do you happen to know if it's available somewhere on the web.

Thanks again!

Dave

 

[synapsevampire]

I've looked at

http://www.milletsoftware.com,

such as Visual Cut. Ido is one of the strongest contributors here, and writes great code.

I rarely work with Goldmine, so I can't really help you there.

-k

 

[marketfx]

K,

Thanks again. Ido's stuff looks very nice. We'll definitely check it out.

Dave