Solved

Ultragrid Column Formula  - Circular Reference Error?

Posted on 2009-05-18
4
1,193 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 11

Accepted Solution

by:
saragani earned 500 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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

We all know that functional code is the leg that any good program stands on when it comes right down to it, however, if your program lacks a good user interface your product may not have the appeal needed to keep your customers happy. This issue can…
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…

690 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