Crystal Report: Using non .txt files as source of odbc text files 
Author Message
 Crystal Report: Using non .txt files as source of odbc text files


I got an application that generates a lot of flat files
as output. I want to use Crystal Report as our default

I builded a schema.ini file via the microsoft text odbc
driver gui and define all the structures of files. In
Crystal Report I reference this DNS as my source and
everything goes ok. All files defined in the DNS has
the .txt extension. At this point all my reports are fine.

Now I want my files to have another particular extension
(.opf). I edited my DNS: remove the .txt extension and
add the .opf. The next step was rename all the files
with the .opf extension. After this I check the files
definitions (fields mapping) from the Microsoft ODBC text
driver GUI and everything is ok...

When I get inside crystal report I redefine the location
of my source (Database/Set Locations) and change the .txt
for the .opf files -do this is pretty easy-.
The problem is that when I test my database source (Database/
Verify Database) I receive the following error:

Error Opening File.
There are no fields in the file: "MYFILENAME.opf"

The thing is that if I rename the files to .txt (just like
before), redefine the ODBC schema.ini file and redefine
the database location everything goes ok. It's looks like
Crystal Report (or the Microsoft ODBC Text Driver) doesn't
supports file extensions differents to .txt, .csv, etc.

Crystal Report Version:             Developer; Product Type Full
Microsoft ODBC Text Driver Version: 4.00.4403.02
Platform:                           WinNT 4.0 SP6A

Any help is really appreciated... I'm stuck here from a while.
Thanks in advance,
Marc Bonet

Mon, 27 Dec 2004 11:00:20 GMT  
 [ 1 post ] 

 Relevant Pages 

1. Problem using file dsn as data source for Crystal Report

2. BuiltInDocumentProperties from non-Word text files + testing if a DOC file is a Word file

3. exporting a crystal report to a txt file with the defined field length

4. .txt files used directly in Crystal?

5. Question about writing a string to a text file (file.txt)

6. Adding .TXT files to a VB program without the .TXT file

7. Crystal Reports accessing flat files thru ODBC

8. report with text file as source

9. Crystal reports 8.5 and ODBC Data sources

10. Using a Text File as a data source

11. Need help with dbgrid using text file as source data

12. Using a Grant Total with Crystal Reports 4.0 - gt.txt [1/1]


Powered by phpBB® Forum Software