Can one expression field refer to another expression field in its calculation

[James Blibo]

Can one expression field refer to another expression field in its calcalation? for example..

this.groupingEngine.TableDescriptor.ExpressionFields.Add("test1");
this.groupingEngine.TableDescriptor.ExpressionFields["test1"].Expression = "[Col1] + [Col2]";


this.groupingEngine.TableDescriptor.ExpressionFields.Add("test2");
this.groupingEngine.TableDescriptor.ExpressionFields["test2"].Expression = "[test1] * [Col3]";

Will the engine spot circular reference if it occurs?

[Administrator]

Hi James,

I am afraid I am not able to reproduce this issue. I have tested a modified sample on my system which has "Essential version 4.4 +Windows XP sp2 +.Net 1.1" installed. Could you please try running the same at your end and send me back the modified sample if still the problem exists? Also please let me know about the current version of Essential Studio/.NET framework you are using.

If you give more information about this issue, we will try debugging here.

Here is a sample.
GGCExpressionField.zip

Best Regards,
Haneef