intelligently using text files as a source for crystal report

[vincer]

I have a problem that I am wondering if a crystal reports has the solution.

We have a directory structure which contains a customer Id within the directory path name. I want to selectively look in a customers directory for a specific file and then use this file to run a report on. The file is in a csv format.

Is this possible? This is to try and identify a one off problem that has occurred.

I know I can create a connection to a local file system,
I know I can create an ODBC connection to a "Microsoft text driver" and I know I can make an SQL connection to the database. What I need to know is how to join the different connection together.
I know I could do it manually by just using an odbc source, but there are thousands of accounts in question.

Is crystal man enough for the job? I

Many thanks

 

[AndrewBaines]

I think you'll need to use a VB app to check for the file then set the datasource of the report to the file.
Unless someone has an easier solution?

 

[vincer]

I was hoping that I could do it all within crystal, otherwise I could just right an App to do the whole lot.