Adding a Group

[kab555]

Hi,
Using Crystal Reports 8

Does anybody know why crystal does not show all available fields when attempting to add a group, or even a sort for that matter?? Frustrating to no end!

 

[dgillz]

Is the field you are referring to a formula field? If so please post the formula Software Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com

 

[IdoMillet]

Formulas that use aggregate operations such as sum and count can't be used for SORT or GROUP operations since
they are evaluated at the time sorting & grouping is already performed ("second pass&quot.

Consider getting these values directly in SQL. If you explain the situation, we may be able to suggest a concrete approach.

hth,
- Ido

CUT (Crystal UTilities): e-mailing, exporting, electronic bursting & distribution of Crystal Reports:

http://sobpc02.bd.psu.edu/CUT/CUT.htm

 

[Ngolem]

in addition....formulas that contain a function such as "WhilePrintingRecords" or "EvaluateAfter()" cannot be used in grouping data.

If you have such a formula and want data sorted or grouped on its value just remove the function and all will be well.

Does that mean you should eliminate the use formulas such as "WhilePrintingRecords"...NO...this is a very important function...I include it with every formula that is not required for Grouping/Summary Operations/Sorting. These functions give you the control as to when formulas are evaluated and doesn't leave it to Crystal's whim. Jim Broadbent