Hi!
I believe this is a simple issue for experienced users, but I am totally new to Crystal reports, and I need step by step instructions on how to:
1) create a calculated field (need to combine a date and time into one field)
2) report the last record ( based on the calculated field) for each unique value within another field.
For example, I have several records for each [problem_code]. I want to report ONLY the last entry for that problem code, based on the maximum value in a calculated field that contains the date and time.
Please Hellllllp! Thanks.
Candace Burts [sig][/sig]
I believe this is a simple issue for experienced users, but I am totally new to Crystal reports, and I need step by step instructions on how to:
1) create a calculated field (need to combine a date and time into one field)
2) report the last record ( based on the calculated field) for each unique value within another field.
For example, I have several records for each [problem_code]. I want to report ONLY the last entry for that problem code, based on the maximum value in a calculated field that contains the date and time.
Please Hellllllp! Thanks.
Candace Burts [sig][/sig]