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...
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.
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.