Formula Not available from Group / Record Sort Experts

[bernie321]

Hi

We have many formula fields that are not available from teh Group Expert and Record Sort Expert.

We are using Crystal Reports Developer XI

Is there certain reasons for this?

Thanks
B

 

[dgillz]

Please post your formula.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

 

[synapsevampire]

In general, if they are formulas which do not return results for every row, then you can't use them, nor could you use a summary function, except in some cases as with the Top N.

-k

 

[lbass]

In earlier versions, you can only use a group sort on inserted summaries (and I'm guessing this might be the case with 11.0, although I haven't tested it), so if you cannot insert a summary on the field you want to sort by, you won't be able to use the topN/group sort feature. There might be a way to do this with SQL expressions or using the Add Command feature, depending upon your datasource and your formula.

Record sort is based on detail level records and won't work for summaries or formulas that use sequential functions like next or previous.

-LB