[RESOLVED] Crystal report : Where are my formula for grouping?

[Zakary]

Hi!

I'm using Crystal Report 10, and I want my report to group on 4 different group base on four Formula. (fGroup01, fGroup02,fGroup03,fGroup04)
I go on group Export, then I have bean able to place a group for fGroup01 and fGroup02, but the two other (fGroup03,fGroup04) formula are not listed in the "Report Fields". Where are they?

Any clue?

[Zakary]

A picture worth 1000 words

http://www.vbforums.com/attachment.p...1&d=1251313849

[brucevde]

The code in a Formula would determine whether or not it can be used as a Group.

[Zakary]

OK .. but what Can and what can not?

[techgnome]

did you scroll down further in the drop down? The check mark indicates those fields are actually in use. Fields in sue get listed first....follwoed by fields from the query followed by other fields... at least that's the way I seem to remember it.

-tg

[Zakary]

Thanks for your, insert TG, but no, there not at the top or at the bottom

[brucevde]

OK .. but what Can and what can not?

Both lists would be quite long.

For example, Running Total fields. You cannot Group on a Formula that references a Running Total field.

Post the formula code.

[Zakary]

For now it only return a report Parameter
the parameter is a number

formula = {?pGroup03}

[brucevde]

Apparently you cannot group on a formula that references a parameter field.

You can however, Sort the records using that formula.

[Zakary]

Thanks for your reply, Ill look at this.

[Zakary]

Double post ...