Consider below example:
In Ultragrid if column 2 is dependent on Column 1 Values ,
and if we filter column 1 then column 2 get automatically filtered , -(this is correct)
but on click of "Filter" of Column 2 ,still we are able to access all values of column 2 (irrespective of value selected in column 1)
This is not as per default Excel filter bahaviour.
please suggest that how can we get default Excel filteration behaviour in Infragestics UltraGrid.
-Mayank.
I tested this out and it appears to work just fine for me. The second filter dropdown displays only values that are still visible in the list and not not contain any values that were filtered out as a result of the filter on the other column.
Perhaps you are using an old version of the grid that had a bug. Or maybe there is some setting that is changing this behavior, although I am unable to find any such setting.
Can you duplicate this in a small sample project?
HI Mike,
Thanks for quick response.
If we use default filter behavior then its working as expected (like excel) ,but
if we use UltraGridFilterUIProvider
then its not behaving like default Excel filtration .
please see below screenshot.
Here if we filter Department by "Admin", then it is filtering Employee list correctly, but in filter option of Employee its showing all employees.
Please suggest me the exact implementation..
Thanks,Mayank.
Hi Mayank,
Can you provide me with some details, how to use UltraGridFilterUIProvider to show the same behaviour as shown in your above snapshot.
What i want is, how to get the checkbox dropdown for filtering (default filter behavior like excel).
Thanks in advance,
Amit
Hi Amit,
If you are using Infragistics version 9, then you can drag and drop the UltraGridFilterUIProvider from Toolbox onto your form. Then go to grid's Properties -> Display Layout -> Override -> FilterUIProvider and select the UltraGridFilterUIProvider from the dropdown.
Alternatively you can use this code:
private UltraGridFilterUIProvider filterUIProvider = null;
private void Form1_Load(object sender, EventArgs e)
{
this.filterUIProvider = new UltraGridFilterUIProvider();
this.ultraGrid1.DisplayLayout.Override.FilterUIProvider = this.filterUIProvider;
}
Thanks for the quick reply.
I am usind Infragistics version 9.1, however when i drag and drop the UltraGridFilterUIProvider on my form and try to select the FilterUIProvider property of UltraGrid, it dint listed UltraGridFilterUIProvider.
Then i tried to do the same through code, but i get a runtime exception with the following message,
Unhandeled exception occured,
See the end of this message for details on invoking just-in-time (JIT) debugging instead of this dialog box.************** Exception Text **************System.EntryPointNotFoundException: Entry point was not found. at Infragistics.Win.UltraWinGrid.IFilterUIProvider.Show(ColumnFilter columnFilter, RowsCollection rows, Rectangle exclusionRect, ValueList values) at Infragistics.Win.UltraWinGrid.ColumnHeader.OnClickFilterDropDown(HeaderUIElement headerElem, Boolean shiftKeyDown) at Infragistics.Win.UltraWinGrid.FilterDropDownButtonUIElement.OnMouseDown(MouseEventArgs e, Boolean adjustableArea, UIElement& captureMouseForElement) at Infragistics.Win.ControlUIElementBase.ProcessMouseDownHelper(Object sender, MouseEventArgs e) at Infragistics.Win.ControlUIElementBase.ProcessMouseDown(Object sender, MouseEventArgs e) at Infragistics.Win.Utilities.ProcessEvent(Control control, ProcessEvent eventToProcess, EventArgs e) at Infragistics.Win.UltraControlBase.OnMouseDown(MouseEventArgs e) at System.Windows.Forms.Control.WmMouseDown(Message& m, MouseButtons button, Int32 clicks) at System.Windows.Forms.Control.WndProc(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m) at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)Is there somthing that i am missing..?
Thanks,
Was your project built using older versions of Infragistics? If yes, then you may need to upgrade it by the Upgrade Project Utility.
If not then I am afraid I cannot be of further help. You may want to raise the issue with Infragistics team (on a separate thread) or build a small sample project and try to reproduce the behavior there.
Regards,
Mayank
Thanks, it worked after i upgraded using Upgrade project utilities.
However if we use UltraGridFilterUIProvider
then its not behaving like default Excel filtration. Is there any solution to it ?
Thanks and Regards,