I am using Crystal report version: 8.5.3
I have a document that can be downloaded from a web page as CSV file. I open this file and save it as DBF 4 file.
I load this file into a Crystal reports table via add tables option Find database files. I browse to the correct location and select the correct DBF file. The DBF file is loaded into Crystal reports now.
The loaded table is not linked to a database table but I should like to match some fields between the tables. I think the best is to have the database table as lead and then search in the created table. But then I need to create an Index. When i right click on the created table then I have the option add index. But then Crystal is asking for a file containing the index. What is this and how do I created this file? Is there an easier solution for what I am doing?
I forgot to say that the file is coming from an Microsoft environment and the table is running a Oracle database.
I have a document that can be downloaded from a web page as CSV file. I open this file and save it as DBF 4 file.
I load this file into a Crystal reports table via add tables option Find database files. I browse to the correct location and select the correct DBF file. The DBF file is loaded into Crystal reports now.
The loaded table is not linked to a database table but I should like to match some fields between the tables. I think the best is to have the database table as lead and then search in the created table. But then I need to create an Index. When i right click on the created table then I have the option add index. But then Crystal is asking for a file containing the index. What is this and how do I created this file? Is there an easier solution for what I am doing?
I forgot to say that the file is coming from an Microsoft environment and the table is running a Oracle database.