pulling from Query

[needmoremoney]

I have an Access database that I am using the crystal report to pull from.

I created a query that have relationships from a few tables. Would I have any problem using crystal to pull from the query instead of the tables?

I tested it out and it works fine but when used a third party software to activate the crystal report I get an error stating that the application cannot access the database.

I think this is due to the third party application.

Does anyone know a way to export the report in crystal to a text file?

thanks for any help.

Access 97

 

[synapsevampire]

The application may not work depending upon their code, but you might make it work by using a UNC instead of a mapped drive, as in:

\\machine\path...

as opposed to

w:\path...

Crystal does have several types of *text* file exports, depending upon your version. Please remember to always post your software version with any post about software.

Click the Envelope icon and you'll see Character Seperated Values, Comma Seperated Values, Tab Seperated Values, Text file, and lots of others.

-k

 

[needmoremoney]

Hello synapsevampire,

Thanks much. I got it working.









crystal 8.5