Formula not available to choose in a crosstab

[hank7]

Standalone CR10

What would cause a formula to not be listed among the available report fields in a crosstab (and sometimes in other functionality that list report fields).

This is a generic question because it happens often, but I've just set up a crosstab, and was about a set up a similar one and I noticed that the field I had based the first crosstab on wasn't listed. It wasn't listed in the first crosstab's fields either. I most probably made changes to that formula between the time I originally set up the first crosstab, but what changes would have made it "disappear"?

Thanks.

 

[chelseatech]

A crosstab can only use formulas that are calculated "WhileReadingRecords". So it it uses a database field, constant or a parameter then it's ok. if it uses a running total,summary or shared variable from a subreport then it's not available.

Manual crosstab technique can be used with any fields, although I've yet to see if that restriction above aplies with the new "Calculated Member" feature in CR 2008.

Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[Madawc]

You can use Crosstab if you duplicate the summarised function at record level. E.g.

if {code} = "A" then {value} else 0

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[dgillz]

please post your formula.

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

http://www.gainfocus.biz

"What version of URGENT!!! are you using?