Joined: 23 Apr 2009
Location: United States
Online Status: Offline
Posts: 54
Topic: OnFirstRecord/OnLastRecord 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?
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum