Next Function

[tarynsuedavids]

Hello,

I am using Crystal 2008. I have a report that has a client span start and end date; the report is then grouped by a service with a start and end date. I am trying to display the Next Service Start Date for each service to eventually do a datediff. When I display my formula it continues to grab the next service start date even if it pertains to the next client. How do I reset this to only show if there is a next service start date for the same client id ?

I have the following groups:
GH 1 - TClient.Client.ID
GH 2 - TCAS.Client.Span
GH 3 - TCL.SERV.Auth.NBR

Next({TCL_SRVC.BGN_DT}) this simple formula works, but how do I do a reset for each client ID/Grouping?

Thank you for any help you can offer I am new at reports.

 

[fisheromacse]

There is likely an easier way, but...one way could be to change your formula:

IF {TABLE.ID}=NEXT({TABLE.ID}) then
Next({TCL_SRVC.BGN_DT}) else ""

 

[tarynsuedavids]

That worked. Thank you!