report->selection formula->GROUP

[CarrJ]

I am using Crystal 11. I keep seeing in some of the solutions "report->selection formula->GROUP " and the formula to put in there is something like
{A.Date} = Maximum({A.Date}, {A.EmployeeID}). When I try to do this, it tells me that I need a group that matches Maximum({A.Date}, {A.EmployeeID}). Where/How do I enter that group? I know how to enter one field, but I can't figure out how to enter "Maximum({A.Date}, {A.EmployeeID})" as a group.

 

[MCuthill]

CarrJ,

I am using CR10, but think I can help you on this one. How to acheive a Maximum on a group would be done by creating a group on the field (in your case {A.EmployeeID}) then creating a summary field for the other field for the given group (in your case the {A.Date} field would be summarized).

Hope this helps!

Mike
---------------------------------------------------------------
"To be alive is to revel in the moments, in the sunrise and the sunset, in the sudden and brief episodes of love and adventure,
in the hours of companionship. It is, most of all, to never be paralyzed by your fears of a future that no one can foretell."

 

[lbass]

The second condition in the maximum summary is the group field, so as Mike suggested, you need to insert a group on {A.EmployeeID}. Then you can use the group selection formula you showed successfully.

-LB

 

[MCuthill]

oops... Thanks LBass. Thought process clearly got derailed mid-sentence.

Cheers!

Mike
---------------------------------------------------------------
"To be alive is to revel in the moments, in the sunrise and the sunset, in the sudden and brief episodes of love and adventure,
in the hours of companionship. It is, most of all, to never be paralyzed by your fears of a future that no one can foretell."

 

[CarrJ]

Thank you both! I was trying to make the group with Employee ID and Date. Your solution worked great! Thanks so much!