ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Crystal Reports, ODBC & Access >> Crystal Reports General Issues >> Add database to existing report
http://www.istechforum.com/YaBB.pl?num=1194015276

Message started by Anna on 11/02/07 at 07:54:36

Title: Add database to existing report
Post by Anna on 11/02/07 at 07:54:36

We are trying to add databases to an existing report. When we select the database all we get under the database name is field1 instead of the list of fields. What do we need to do to get the list of fields in the database?
Thanks,
Anna

Title: Re: Add database to existing report
Post by David Waldmann on 11/05/07 at 06:21:34

How are you connecting to the data?

Title: Re: Add database to existing report
Post by Anna on 11/14/07 at 07:51:35

We are using add database, scrolling to the file in the company and then clicking on that file. When it is added all we get is "field1". None of the other fields are available.

Title: Re: Add database to existing report
Post by David Waldmann on 11/14/07 at 11:49:20

If you don't have an ODBC connection and are using the Btrieve DDFs you will want to select FILE.DDF, FIELD.DDF or INDEX.DDF in the DBAMFG folder. Maybe someone can tell you the difference - they all seem to work the same to me.

If you are using a later version of CR, when you open "Create New Connection", select "Btrieve" rather than "Database files" as it will filter out any invalid files.

If you don't have them set up, I would strongly suggest creating ODBC DDFs and an ODBC connection for a couple reasons. It's generally quite a lot faster, so your reports take seconds instead of minutes. And you limit the available tables to those in the company you are using which makes it quite a lot less confusing to find the ones you want. There are detailed instructions elsewhere on this site (maybe on the Wiki too?) but basically there are only three steps - create the ODBC compliant DDFs in DBA, create a System DSN on the server, and finally a User DSN on any workstation that needs access.