IS THIS MISSION IMPOSSIBLE!!!

[Dominican1979]

Hello Everyone,

Thanks for reading my post. This is what I need to do:

I have an invoice report with order lines. Each order line has a memo field that may or may not be filled in. If it is filled in, then the field contanins a path to the memo file on the file system like this:
C:\program files\visma\business\F0002\M600395.txt
The actual memo file above may contain something like this:
"Defective Return" or whatever. I need to be able to read this text file using the path stored on this field and display it for each order line on the report.

Could someone please give me some direction on how to go about doing this, I've looked everywhere without any luck. Is this something in which somehow I need to use some kind of function in the SQL Server in conjunction with Crystal?

Thanks for your help

Crystal XI & SQL Server 2005

 

[lbass]

Please do not create multiple posts on the same topic. This is your third one, I believe.

-LB