Reading in a file for comparison
Hi,
I'd like to be able to read a file into Crystal XI so that I can do calculations against the contents of the Database and the file.
For Example.
Table A contains date fields of when a record was created (date_logged) and when that record was last updated (Closed_Date). I want to compare that Date range against a list of Statutory Holidays contained in a text file.
Like this I can calculate the number business days in between the Date_Logged and Closed_Date. Unfortunately I'm a little green on Crystal Reports.
Any advice would be appreciated.
background info.
We are connecting to Oracle 9i directly using ODBC. The report will be executed in the production environment using the Visual Cut Batch processor.
Thanks.
|