OnFirstRecord/OnLastRecord
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=9723
Printed Date: 27 Apr 2024 at 3:51pm
Topic: OnFirstRecord/OnLastRecord
Posted By: huddy33
Subject: OnFirstRecord/OnLastRecord
Date Posted: 19 Apr 2010 at 2:34am
I had a very difficult (IMO) report that I received some advice from on here. I was guided into using a formula evaluating a running total reading like this on evaluate (no reset):
{@Quarter}='1st Qtr'
and {LookUp_ContractStatus.ContractStatusID} in [3,6]
and previous({Meeting.MeetingID})<>({Meeting.MeetingID})
The original post is here: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=9652&KW=
The issue I'm having now is that a record that may be missing from the report footer sum by quarter and is the very last row in the group. Using previous or at the next in the evaluate formula is still not grabbing that last row of data. How do I accommodate this error?
|
|