Crystal Reports XI with dbf files

[PamRutledge]

I'm new to Crystal. I have used R & R Report Writer in the past. We have .dbf files for our student management system. Crystal XI doesn't play nice with the links so I attached to dbf files using Add Command to test it:
EX:
SELECT *
FROM c:\sasiwes\datafile\astu7023.dbf

Now that I want to connect to the live data I'm having problems. The Command would have to look like this:
EX:
SELECT *
FROM \\wghsv2\apps\sasi-el\datafile\astu7023.dbf

IT DOESN'T LIKE THE "-" IN THE UNC PATH! ARG! Can anyone head me in the correct direction?

Pam Rutledge

 

[dgillz]

I think crystal is a fine report writer with dbf files, but don't try to create a command. Just connect directly to the .dbf file in the report wizard, and then grsb the fields you want in the report.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[pmgatwork]

Its is quicker if you use an ODBC connection rather than the xbase driver

Peter