Search results for query: *

OK, Crystal v8.5 (as mentioned in the original post), ODBC connectivity to SQL server 2000 database. I will try putting more fields in the view and using that as the primary data source. Thanks.

I have a simple report that brings back the details from an error log table for all the cheque runs. One of the fields is 'Run Number'. I only want the details for the last run number. I tried to used the Maximum fuction in the record selection (you live in hope!) but that came back with the...

Thanks Naith, I found it! :)

I have finally got to the end of a long string of formulae all referring to each other and found one that is not recognised by the version of Crystal that my client has installed (7.0.1.100). This has resulted in all the formulae falling over. The formula in question is...

I'll try that next time I'm on site but in previous reports where a Left Outer Join has been required I would get a database error message and get chucked out of Crystal entirely. Since that didn't happen I was assuming that the matching was one to one. thanks, CB

Low, e.g. Actual Sales Revenue for the month went from 98K to 3K, but I haven't analysed how it got that way. :-) CB

The 'Actual' amounts, which were correct before adding the 'Budget' formulae, change to incorrect amounts, and the results of the Budget Formulae are incorrect as well. I think the problem is that I am not using the raw data for each individual account - the formulae summarise groups of accounts...

Ken, No, I've tried all the combinations of linking the two tables but without success. CB

Thanks for the pointers Andrew. Ken, yes it is a one to one match between tables based on the four GL Account Fields - Company, Division, Department, Account. Database is Progress 9.2 which is SQL based. Regards,

I am trying to create a Profit & Loss Report with 3 columns of Info: This Year Actual, This Year Budget, and Last Year Actual. The info is held in 2 separate tables, Actual and Budget, which have the same table structure and field names. I have linked the tables at every field except the Amount...