[RESOLVED] Crystal report : Where are my formula for grouping?
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?
1 Attachment(s)
Re: Crystal report : Where are my formula for grouping?
Re: Crystal report : Where are my formula for grouping?
The code in a Formula would determine whether or not it can be used as a Group.
Re: Crystal report : Where are my formula for grouping?
OK .. but what Can and what can not?
Re: Crystal report : Where are my formula for grouping?
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
Re: Crystal report : Where are my formula for grouping?
Thanks for your, insert TG, but no, there not at the top or at the bottom
Re: Crystal report : Where are my formula for grouping?
Quote:
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.
Re: Crystal report : Where are my formula for grouping?
For now it only return a report Parameter
the parameter is a number
formula = {?pGroup03}
Re: Crystal report : Where are my formula for grouping?
Apparently you cannot group on a formula that references a parameter field.
You can however, Sort the records using that formula.
Re: Crystal report : Where are my formula for grouping?
Thanks for your reply, Ill look at this.
:)
Re: Crystal report : Where are my formula for grouping?