Group by Formula Field

[Kibeth]

I just created a formula field to give me the Product Name, and I need to be able to group by that field, but it is not listed in my Group Expert. I have put the field in the report details, and it is not even listed under the "Report Fields" in the Group Expert.

Please help

I am using CR XI.

 

[synapsevampire]

Post your formula...

-k

 

[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.

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

 

[Kibeth]

The formula I'm trying to group by:
stringvar array MyValues:=split({@PN1},"<");
MyValues[1]

 

[Madawc]

Try a formula field that says just

split({@PN1},"<")[1]

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

 

[Kibeth]

This is working now, thanks!