Jervis Level: Trainee
 Registered: 31-03-2005 Posts: 1
|
Customizing Crystal Reports with CSV as data source
hi guys!
I'm currently using Crystal Reports 8.5 and i'm kinda new to it. I'm now trying to customize a report.
The situation:
The source for the report are in CSV and i can't run the preview in the report because it says that there is a problem with the ODBC driver and it cannot locate the file used as the source. Also prompts an error message the says "Error in Database DLL". I found the dll file and its working just fine. I have also found where the those csv files are located. it is in a schema.ini file.
My Problem:
I was wondering how can i extract those csv items in the schema file and used it as my data source in my report. I know it sounds confusing but i've already tried using every ODBC driver to connect the csv file to my report and it won't work. i also tried converting the schema.ini to excel and it won't work.
Is there any one who can help me? pls. i really need to know how to do it. any suggestion will be very much appreciated. it's been bugging almost everyday. Thanks!
Note: The CSV's in the Schema.ini are in TabDelimited format.
-Jervis
|