Cannot Group by Formula ?? V10

[medieval]

Hi,

Pretty new to this so bear with me however using V10..

I have created two simple mathematical formulas however when attempting to group the data under detail by formula; the program does not give me the option. I have the various fields for any one of the Tables I have chosen but that is it !!

Does anyoneone know why I do not have the option to choose by formula ?

thanks.

 

[synapsevampire]

Whether new or not, please don't post asking us to review the contents of an unknown formula, post it...

The trick is to make sure that the formula allows for all rows since you intend to group by it.

So a formula of:

if {table.value} = 1 then
"Blah"

Wouldn't work

The following would because it allows for all rows as a result of the else:

if {table.value} = 1 then
"Blah"
else
"No Blah"

-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

 

[medieval]

thanks synapsevampire and Madawc.

The code to the formula is 'Year (CurrentDate)'.
What are your thoughts ?

 

[Madawc]

CurrentDate is something the system gives you, the date according to the computer. That's not a sensible thing to group on, even if the computer would allow it. YOu should be grouping on some field from the data.

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

 

[medieval]

thanks. problem solved.