[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Ultragrid Column Formula  - Circular Reference Error?

Posted on 2009-05-18
4
Medium Priority
?
1,230 Views
Last Modified: 2013-11-26
I have an Infragristics Ultragrid, that selects a couple of  columns that are categories with values:
I want to set a formula on these columns that is the column itself * qty, so the formula looks like

e.Layout.Bands[0].Columns[i].Formula =  "[" + e.Layout.Bands[0].Columns[i].ToString() + "] * [qty]"

but I get an error about Circular Formulas...how do I do this?

THANKS
0
Comment
Question by:melegant99
  • 3
4 Comments
 
LVL 11

Accepted Solution

by:
saragani earned 2000 total points
ID: 24415250
Maybe you get this error because the value of Column i = value of column i * qty ??

The source and result columns must not be the same, at least from what I understand.
0
 

Author Comment

by:melegant99
ID: 24415263
That is what I was looking for confirmation of...and that stinks....but I guess I will have to have to add some unbound columns .

thx.
0
 
LVL 11

Expert Comment

by:saragani
ID: 24415281
Infragistics has in their example that they take: col1 = col2 * 10
If you change that the destination and the source are not the same and you still get the error then post back and I'll try to figure it out.
0
 
LVL 11

Expert Comment

by:saragani
ID: 24415662
Ok, I've tested it also with Excel. It will give the same Circular Referece error, and it is only logical that it will do that.

You said that you are going to have an unbound column... The question is why?

If for example you get the data source by running an SQL Command and using data adapter to fill a DataSet then you can alter the SQL command to have the columns that you want and do manipulations on columns/data, for example:

SELECT ID, Col1*Col2 AS NewNameForColumn, Col3 FROM Table1;

That should do the trick... I'm suggesting those methods because working with unbound data can be very slow
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Wouldn’t it be nice if you could test whether an element is contained in an array by using a Contains method just like the one available on List objects? Wouldn’t it be good if you could write code like this? (CODE) In .NET 3.5, this is possible…
Hello there! As a developer I have modified and refactored the unit tests which was written by fellow developers in the past. On the course, I have gone through various misconceptions and technical challenges when it comes to implementation. I would…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …
Suggested Courses

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question