Can l use a fomular l created as a group

[NKOS13]

Hi , l have just created a report and l would like to group by one of the formulars l created , but l'm failing it just does nothing.l'm currently using crystal 10

 

[lbass]

Please show the content of the formula and also identify any other fields you are grouping on and in what order. What are you expecting to see? What are you seeing instead?

-LB

 

[Madawc]

If a formula field can't be used for grouping, that's probably because it is based on more than one 'row' or detail line. Grouping has to be based on something in a single 'row', though it can be a formula field involving several fields from different tables.

There is a 'Top N' function that will show some groups first. Also group suppression, which can use summary totals.

It helps to give your Crystal version - 8, 8.5, 9, 10, 11 or whatever. Methods sometimes change between versions, and higher versions have extra options. In this case, it probably makes no difference.


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