Has anyone tried to apply a formula condition across bands? I am trying to check for the existence of particular band on the grid (underlying datasets are related by a FK relationship).
I'd like to highlight a cell in the parent band yellow when the child band for that particular row is populated. I'm attempting to do this w/ a formula similar to the following:
not(isdbnull( [../fk_tradeexecution_canceltradeexecution/cancelexecutionid] ))
(fk_tradeexecution is my child band, cancelexecutionid is the key relating the two bands)
Not sure why this doesn't work.... If there are child bands for the row, then a call to isdbnull should return false and hence should highlight the cell yellow......
If tried replacing isdbnull with isnull, I've even tried replacing isdbnull with a count() function and checking to see if the count is <> 0.... no luck in either situation.
As an aside, I definitely have an UltraCalcManager on the grid...
Hi,
I'm not sure I follow what you are trying to do here. I assume "fk_tradeexecution_canceltradeexecution" is the name of the child band. What is "cancelexecutionid"? Is this a column? Is it a column in the child band or the parent band.
It sounds like you are trying to check if the count of the child rows for a particular parent row is 0. In which case, you should probably be using the Count function. the collection of rows will never return DBNull or Null.
Yes Mike, I am trying to check to see if there are any child rows for a particular band. I was able to do get this to work using the aggregate function sum(), for some reason count() didn't have the same effect.
Regardless, problem solved. Thanks for the advice.