Joined: 24 Jul 2019
Location: United States
Online Status: Offline
Posts: 3
Topic: Formula Fields Not Showing as Grouping Option Posted: 02 Aug 2019 at 4:28am
I created a formula to use Maximum as a summary field. However, I need to create a group using this value. Crystal will not show that field as an option for a group. Is there a work around for that?
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Posted: 05 Aug 2019 at 10:51am
Nope.
The maximum is already based on a group or the entire data set so it can't be reused as a grouping of a grouping.
if you explain your data set and what you need to do there might be another solution.
Joined: 24 Jul 2019
Location: United States
Online Status: Offline
Posts: 3
Posted: 06 Aug 2019 at 3:36am
I have a group of specimen numbers
XX123
Name Date Location
ie
XX123
Doe, Jane 2/2/18 North
Doe, Jane 2/2/18 North
Doe, Jane 2/2/18
Sometimes the data does not have the location but it is the same as the others in the group. Doing a maximum gives the overall location for that specimen.
but it does not allow me to run reports by location.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
