Print Page | Close Window

Formula Fields Not Showing as Grouping Option

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22806
Printed Date: 29 Mar 2024 at 2:30am


Topic: Formula Fields Not Showing as Grouping Option
Posted By: sfranc01
Subject: Formula Fields Not Showing as Grouping Option
Date 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?

Thanks in advance.



Replies:
Posted By: DBlank
Date 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.


Posted By: sfranc01
Date 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.


Posted By: DBlank
Date Posted: 06 Aug 2019 at 6:26am
You can add a group select condition.
Create a dynamic parameter using the location field
add a select criteria as a group condition

Maximum ({table.Location}, {table.SpecimenNumber}) = {?My Parameter}


Posted By: sfranc01
Date Posted: 07 Aug 2019 at 7:53am
I can use that for some other needs, but unfortunately won't allow me to show all locations on the same report.

Thanks for the reply!



Print Page | Close Window