Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Identify the LastRecord of each Group 2

Status
Not open for further replies.

gurlfob

Programmer
Joined
Oct 29, 2001
Messages
35
Location
US
How can I identify the last record in a Group? I am displaying categotyname and the sellPRice for category. I have to display the sellprice at the lastrecord of categoryname. Any input will be highly appreciated. Thanks.
 
Conditionally suppress that field with the following code:

Not OnLastRecord
{Category.name}=Next({Category.name})

The 'Not OnLastRecord' will prevent the very last record of the report from producing an error. Software Support for Sage Mas90, Macola, Crystal Reports, Goldmine and MS Office
 
It worked. Thanks a lot.
 
I am having the same problem as you (Parnini) so I tried what dgillz suggest and I got an error. Can you or anyone else help explain because something is goofy? I am sure it is a simple explanation or an over sight on part but I been trying different things and none of my suppressions are working or they error.

Dgillz: I was going to ask him directly but no email anybody know?

Error: The remaining text does not appear to be part of the formula

Formula: Not OnLastRecord {CV042B100_ttx.CalendarName} = Next({CV042B100_ttx.CalendarName})

P.S.
Working with Crystal 8.0 (TTX method)
 
There should be a ';' after Not OnLastRecord

Naith
 
Thank You--Naith. This made my Friday and it worked perfect thanks again.

Chuck
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top