Unbound PivotGrid

[Steve]

Hi,

Are there any examples of a Unbound PivotGrid? I would like to have PivotGrid that looks like a Property Grid.
I need to use PivotGrid because I need multiple rows.  I need to add my own rows.
I would like to have a PivotGrid that has categories (groups) and images in the individual rows.

I have not found any examples for adding rows manually.

Below is an example of what I want the grid to look like.

Thanks
Steve Morrow

[Peter]

Hi Steve,

By design RadPivotGrid is implemented for business intelligence purposes and it is a data summarization tool. It aggregates the data coming from a data table or a data cube (OLAP), and then this data is displayed to the end-user. Its UI can't be used outside the context of this scenario, hence it can't be used in unbound mode.

You can either use our RadGridView applying a GroupDescriptor for the groups handling CellFormatting for the images, or RadPropertyGrid handling the ItemFormatting for the images.

All the best,
Peter
the Telerik team

[Steve]

Can you please point to examples of using the RadGridView in this manner?

[Peter]

Hello Steve,

Thank you for writing back.

You can refer to this Knowledge Base article: Change row and cell visual appearance using code. 
Please, refer to the sample code below:  

void gridView_CellFormatting(object sender, CellFormattingEventArgs e)
{
    GridDataCellElement cell = e.CellElement as GridDataCellElement;
    if (cell != null)
    {
        if (cell.Value = ....)
        {
            cell.Image = myImage;
            cell.TextImageRelation = TextImageRelation.TextBeforeImage;
            cell.ImageAlignment = ContentAlignment.MiddleRight;
            cell.ImageLayout = ImageLayout.None;
        }
        else
        {
            cell.ResetValue(LightVisualElement.ImageProperty, ValueResetFlags.Local);
            cell.ResetValue(LightVisualElement.ImageAlignmentProperty, ValueResetFlags.Local);
            cell.ResetValue(LightVisualElement.TextImageRelationProperty, ValueResetFlags.Local);
        }
    }
}

I hope you find my answer useful. 

Regards,
Peter
the Telerik team