I have a special summary:
e.Layout.Bands[0].Summaries.Add("Forced1", fcFormula);
I have a column("X") that I want to create a formula for... but I want to reference the value in the summary Forced1. So do this..
e.Layout.Bands[0].Columns["X"].Formula = "[Forced1] * 1.25";
but it doesn't seem to work right.
Is there a way to reference Forced1?
Hi,
Since it is possible to have a column and a summary that both have the same key, you have to tell the Formula that the name you are using is a Summary and not a column. You do that with parens:
e.Layout.Bands[0].Columns["X"].Formula = "[Forced1()] * 1.25";
I tried that and I get a Circularity error.... here is my formula: e.Layout.Bands[0].Columns["X"].Formula = "[Forced1()] * 2";
A circularity means that you have formulas that reference each other in a circle, which you can't do.
Does your summary formula rely on column "X" in some way?
No it doesn't rely on "X". Its not apparent whats causing it. I created another special summary and it worked ([Forced2()]) So something in my formula for Forced1 is a problem ... will have to bang on this.