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 gkittelson 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
Oct 29, 2001
35
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
 
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