Connect to ACT! 2007 with CRXI

[iemproductions]

I have been asked to create some reports from an ACT database. I was under the impression that the db's were in .dbf format. I searched but could not find them. After snooping some more, I think the db is a .ADF file. If so, which of the crystal connection types should I use?

Thank you.

 

[synapsevampire]

I believe it uses SQL Server Express Edition.

There may already be an ODBC connection set up, check for that first.

Otherwise you'll need to configure a connection.

-k

 

[iemproductions]

I do not know what SQL Server Express is. Is this something that comes with ACT!

 

[GLComputing]

ACT! 6 and earlier was in DBF
ACT! 7 and later use SQL - 2000 for 7/8 and 2005 for ACT! 9

There is a link for ACT! that can be obtained from Business Objects -

http://itdomino.act.com/act.nsf/docid/18420

You might also get a head start with a bunch of pre-built reports from

http://www.crystalclearreports.com/

Regards,
Mike Lazarus
ACT! Evangelist
GL Computing, Aust

http://www.GLComputing.com.au