Not answered How can I hide a Row in the GridView?

LHR

Posted on Nov 9, 2011 (permalink)

I would like to hide some rows in a GridView, however setting the Row's visibility to Collapsed still leaves a blank space where the row should be.

The trigger I am using to hide both GridViewGroupRows and GridViewRows looks like this:

<Style TargetType="{x:Type telerik:GridViewGroupRow}">

    <Setter Property="Visibility" Value="Visible" />

    <Style.Triggers>

        <DataTrigger Binding="{Binding Group.Key, RelativeSource={RelativeSource Self}}" Value="SomeValue">

            <Setter Property="Visibility" Value="Collapsed" />

        </DataTrigger>

    </Style.Triggers>

</Style>

I do not want to filter results because I need them for aggregate results in the groups and the footer. So how can I hide specific GridViewRows without filtering the data?

Reply

LHR

Posted on Nov 10, 2011 (permalink)

Is there a way to hide or remove the row at all?

I tried using a blank item template, and removing the item from the GridViewVirtualizingPanel, however neither of those appeared to work.

Or as an alternative, can I get the current group query from somewhere so I can query another collection in the AggregateResultsList and add my own data to group summaries?

Reply

LHR

Posted on Nov 11, 2011 (permalink)

Thanks Vlad, would you be able to point me to the demos that do this? I looked through them and didn't see any examples that would let me create a custom aggregate on a Group Row to pull the data from another data source.

I can add regular aggregates, but if I filter the data then the aggregates aren't correct since the data I am trying to aggregate is filteredout. I can also add a custom value to the Group Rows, but I don't know how to get the query that defines what that group contains so I can query the 2nd data source for the correct value.

Its important that I have the aggregate totals in the Group Rows too, not just the Footer

Reply

LHR

Posted on Nov 14, 2011 (permalink)

I'm sorry, that does not do what I am looking to do

It creates a custom Aggregate based on currently visible rows. I am looking to create an aggregate based on non-visible rows. Since I cannot hide rows, I am guessing this is not possible with your GridView.

Reply

LHR

Posted on Nov 14, 2011 (permalink)

The custom aggregate looks like it only aggregates visible grouped data. For this to work, I need it to aggregate non-visible grouped data.

My data rows are either Credits and Debits. I wish to only show the Debits rows, but to provide aggregate totals showing both Credits and Debits. Users can group by any number of fields they want, and they need to be able to see both the total Credits and Debits for that group, however when expanding to view the raw data they only want to see Debit rows.

I thought it would be easy to simply hide the Credit rows based on a trigger, however it turns out hiding a record still leaves a blank space where the record should be. I cannot Filter the data to exclude all Credit rows, because then the Credits would always show up as $0.00 in the aggregate totals.

I do not see how a custom aggregate would help, however just in case I did try copying the code to my project and now I keep getting a run-time error that says:

No generic method 'StdDev' on type 'MyNamespace.Statistics' is compatible with the supplied type arguments and arguments. No type arguments should be provided if the method is non-generic.

The only changes I made was to replace double with Decimal.

Reply

Related resources for "How can I hide a Row in the GridView?"

.NET Developer Tools DevTools