Welcome, Guest. Please Login.
05/06/24 at 08:07:16
News:
Home Help Search Login


Pages: 1
Send Topic Print
Add database to existing report (Read 988 times)
Anna
Browser
*




Posts: 23
Gender: female
Add database to existing report
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
Back to top
 
 

DBA Version 2004.1
  IP Logged
David Waldmann
Active Member
*****


Live to work, or
work to live?

Posts: 1924
Gender: male
Re: Add database to existing report
Reply #1 - 11/05/07 at 06:21:34
 
How are you connecting to the data?
Back to top
 
 

David N Waldmann
President
Vermont Hardwoods
Chester, VT

Evo-ERP, 5 user
IST Build: 3/4/19, patched 04/30/19
Pervasive v11.31
Server 2012 / Win10 x64
Crystal Reports v11
Email WWW   IP Logged
Anna
Browser
*




Posts: 23
Gender: female
Re: Add database to existing report
Reply #2 - 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.
Back to top
 
 

DBA Version 2004.1
  IP Logged
David Waldmann
Active Member
*****


Live to work, or
work to live?

Posts: 1924
Gender: male
Re: Add database to existing report
Reply #3 - 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.
Back to top
 
 

David N Waldmann
President
Vermont Hardwoods
Chester, VT

Evo-ERP, 5 user
IST Build: 3/4/19, patched 04/30/19
Pervasive v11.31
Server 2012 / Win10 x64
Crystal Reports v11
Email WWW   IP Logged
Pages: 1
Send Topic Print