Tips and Tricks: Return maximum Date

Print Page | Close Window

Return maximum Date

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Tips and Tricks
Forum Discription: Have you learned some great tricks to share with the group? Post them here!
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=7645
Printed Date: 24 Apr 2024 at 2:03pm

Topic: Return maximum Date

Posted By: DAVIDX
Subject: Return maximum Date
Date Posted: 10 Sep 2009 at 2:08am

Hi All,

I'm trying to return just the maximum date < paramater, but m getting issues, it is sayiong a boolean is required here. The formulae I'm using is maximum ({HIST_TPPAPOSITION.ACCESS_STAMP}). I imagine it's simple to solve, but I can't get it to work in the record selction formula editor.

Can anyone help.

Thanks

Replies:

Posted By: DBlank
Date Posted: 10 Sep 2009 at 7:03am

Sounds like you placed the

"maximum ({HIST_TPPAPOSITION.ACCESS_STAMP})"

in the select expert and not in a formula field.

If you are trying to create a field that displays the maximum value of the Access_stamp Field from all rows in the report then in the field explorer add a new formula field and use your formula there.

You can then place that field in your report canvas.

Is that what you were trying to do?

Posted By: DAVIDX
Date Posted: 11 Sep 2009 at 2:50am

Hi Thanks, that works in a formula and returns the max date for a given group. However I need to just select the newest records for a given criteria/group.

Posted By: DBlank
Date Posted: 11 Sep 2009 at 6:41am

You mean you want to limit the report data set of the report to the maximum date per group?