Hello,
I am adding a formula field to ugReport grid. It seem by default the Formula Builder loads all availble columns Infragistic controls (grids, dropdowns, so on...) . Is there a way to specify which control should be availble in for the user to create formula? Ideally, I want the user only to have access to all the columns of ugReport grid.
Oh that was easy, I sorted my problem and the problem of the original poster by changing the code in event on formulaBuilder_OperandInitializing event to the following:
Private Sub formulaBuilder_OperandInitializing(ByVal sender As Object, ByVal e As OperandInitializingEventArgs)
If Not (TypeOf e.OperandContext Is UltraGridColumn Or _
TypeOf e.OperandContext Is Infragistics.Win.UltraWinGrid.UltraGrid Or _
TypeOf e.OperandContext Is Infragistics.Win.UltraWinGrid.UltraGridBand Or _
TypeOf e.OperandContext Is String) Then
e.Cancel =True
End If
End Sub
I miss understood what the other function was doing I thought it was hiding the text fields when infact it was hiding the text functions which was working. I am not too bothered about hidng the text columns now I have functions that work with them (As I removed that event). Still wish I could rename the blooming columns :(
Alex
Also to hide the other grids you will need to hide them by name, the code is simple for that.
If e.OperandName = "gridname"
e.cancel = true