Modify table linking

[SchuhTL]

I have a report that I need to modify the SQL. I have two tables, Table A has a datestamp and Table B list every day of the year with a time value of midnight. I need to link the two but since all of table B's time values are midnight I can't find a match in the Table A. I have tried to modify the SQL myself with no sucess. I know it can be done very easily in SQL*Plus, is this possible in Crystal?. I have CR 8.5 and an Oracle database.

Thanks!

 

[dgillz]

Under file, options, make you you check the "convert datetime" checkbox set to "date". This should fix the report.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com