Formula can't be used in group selection

[tkschief]

I have a report that is grouped by case number. Each record has a case_status_date and I am trying to return only the groups that contain matching case status dates. I created a formula called @new1 with the following: if {Command.CASE_STATUS_DATE} = next({Command.CASE_STATUS_DATE}) then 1. I put this formula in the details of my report and a 1.00 displays where the case status date matches the next case status date - perfect. I then was trying to use a group selection formula to display only the case_num groups where the @new1 contains a 1. Tried the following group selection formula of sum({@new1},{Command.CASE_NUM})=1. When I try to save, I encounter an error of this field (@new1) cannot be summarized.

Any help would be appreciated. I'm using Crystal Reports XI 11.5.12.1838

Thanks!

 

[IanWaterman]

Next() is a while printing function and can not be use in group selection.

You can use it in the section expert to supress the sections as required.

Ian

 

[Madawc]

Any selection rule must be based on the properties of a single detail line.

Madawc Williams (East Anglia, UK). Using Crystal 2008 with SQL and Windows XP

 

[tkschief]

Any suggestions on how to do the comparison of the case_status_date in the case_num group instead of using next?

 

[CoSpringsGuy]

Group by {Command.CASE_STATUS_DATE}

use a formula like

count({Command.CASE_NUM},{Command.CASE_STATUS_DATE}} > 1

in group selection formula

_____________________________________
Crystal Reports 2011 and XI
Intersystems Cache 2012 ODBC connection