Writing Code
 Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Writing Code
Message Icon Topic: [Ask] Print Last Record Post Reply Post New Topic
Author Message
Herfian
Newbie
Newbie
Avatar

Joined: 12 Jul 2012
Location: Indonesia
Online Status: Offline
Posts: 4
Quote Herfian Replybullet Topic: [Ask] Print Last Record
    Posted: 12 Jun 2013 at 6:48pm
Dear All,

I want print last record using index record and using Group Selection Formula Editor, example like this :

{"099/MM/2013"}=Maximum ({"099/MM/2013"})

And my problem is : if that record get a reset number fieldindex on next year, a report still preview a maximum summary number. how to solution my case.

Thanks
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3701
Quote hilfy Replybullet Posted: 14 Jun 2013 at 8:16am
Something is lost in translation here, so let me see whether I understand your question.
 
You want to show just the last record for each group for the current year.  Is that correct?
 
If so, you don't need the Group Selection Editor.  Instead, I would do something like this:
 
1.  In the Record Select Expert, edit the selection formula and add something like the following to it:
 
{MyTable.MyDateField} <= Date(Year(CurrentDate), 12, 31)
 
This will give you only the data for this year.
 
2.  In the report, suppress the details section.  Put your data in the Group Footer section.
 
3.  If you need the data in the Group Header, set the group to sort Descending and use the Group Header section instead of the footer.
 
-Dell
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
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



This page was generated in 0.031 seconds.