This field name is not known.

[rarita]

I am getting a "This field name is not known." error in a report where I have verified that the data exists.

I am grouping based on a formula field based on a parameter. If I only show the first part of the formula, the report runs fine.

if {?GroupBy} = "XXX" then {XXX}

However, if I add the second part:

if {?GroupBy} = "XXX" then {XXX}
else if {?GroupBy} = "YYYY" then {YYYY}

I get the error for field XXX which not only exists, but just ran correctly!

Any ideas? I feel like im going crazy!

 

[Madawc]

Have you tried if {?GroupBy} = "YYYY" then {YYYY} on its own?

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

 

[rarita]

OMG!!! that is just too obvious!

My stored procedure is using a function and does not include a lable, Crystal is assigning a label to it which I am refering to in the formula. This issue is wiht the second field, but since the error refered to the first, I never got past that.

Thank you!