Hello All,
I have implemented the group by row in ultragrid with one column named ‘City’ & filter by one another column named ‘LName’.
When I select some criteria & that filtered out some rows in the grid & shows 0 rows, in that case grid shows ‘0 items’ in the group by row, I don’t want that group by row to be appear in the grid.
How can I remove the ‘0 items’ group by row from the grid?
Any help will be appreciated. Thanks in advance.
Please find the snaps below
Hi,
What version of the grid are you using? I tried this out and I don't get these results. The grid does not show any empty GroupByRows. I think maybe it used to do that years ago, but it was a bug and it was fixed.
Hello Mike,
I am using infragistic version 11.2.20112.1010
I am attaching the sample project for your reference, & snapshot of the database table.
I'm not sure what happened here. After I wrote my reply yesterday, I went back your sample and replaced your data source with an UltraDataSource and I could see the problem you described. Then I came back here and edited my post to let you know, and I attached a sample which uses a CreationFilter to remove the unnecessary GroupByRow.
My sample project is still attached to my post above, but the text seems to have been lost.
Basically, the reason this empty row shows up in your case and did not display in my original test is that you are setting the headers to FixedOnTop. Normally, the GroupbyRow would appear above the column headers in the grid, and therefore it would always be necessary to show at least one GroupByRow, because if the grid did not do this, there would be no column headers and therefore no way to un-filter the grid and get the rows back.
Once you set the header to fixed on top, the column headers are above the GroupByRow. In this case, the GroupByRow is technically not needed, but I guess the grid is not accounting for this very specific case.
Sorry you sent to trouble of changing your sample - it was not necessary. Check out the sample I attached above and you can use the same CreationFilter in your grid to remove the empty GroupByRow.
Sorry for your inconvinience. Please find attached project with the sample data.
When i select 'Blanks' from the 'LName' column filter that '0 Items' group by row appears, i dont want to show the same row.
How can i remove that from the grid.
Thanks in advance,
Hi Pradeep,
Can you create a sample with some sample data in it, perhaps using UltraDataSource or a DataSet created in code?
Your sample doesn't help me because I don't have access to your data source and so there's no data in the grid.
Hi Mike,
Attaching the project for the reference.
Thanks,
Pradeep