?
Solved

Ultragrid Column Formula  - Circular Reference Error?

Posted on 2009-05-18
4
Medium Priority
?
1,205 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 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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying 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

For those of you who don't follow the news, or just happen to live under rocks, Microsoft Research released a beta SDK (http://www.microsoft.com/en-us/download/details.aspx?id=27876) for the Xbox 360 Kinect. If you don't know what a Kinect is (http:…
This article is for Object-Oriented Programming (OOP) beginners. An Interface contains declarations of events, indexers, methods and/or properties. Any class which implements the Interface should provide the concrete implementation for each Inter…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
Suggested Courses

777 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