How to change radGrid vertical to horizontal orientation?

[Saad]

i want my radgrid to show data horizontally.....is it possible?

[Princy]

Hello Saadi,

Go through the following online demo link which shows how the grid can be bound to pivot table which will be useful when you want to display the data in a reverse order but still keep the same presentation and structure in the source table.
Displaying pivot data

Thanks
Princy.

[Jagz W]

The page not found....:(

[Princy]

Hi,

Here is the demo link.
Displaying Pivot Data

Thanks,
Princy.

[Jagz W]

Hi,

Thanks for reply. It works for me.
Could you tell me how i get the selected panel values on button click?


Regards,
Jagz W

[Princy]

Hi,

Unfortunately I couldn't understand your requirement. Can you please elaborate you scenario a bit more.

Thanks,
Princy.

[Daniel]

RadPivotGrid only works with numbers, It doesn't work for string data. There is no a simple way to present a RadGrid vertically instead of horizontally. RadControls haven't got that "flexibility".

[Princy]

Hi Daniel,

I guess you want to display string values in a grid that display the data in a reverse order (vertical grid)structure. Please have a look into this documentation on Displaying pivot data, which might help you with your requirement.

Thanks,
Princy

[Daniel]

That solution only works with DataTable, I'm using a List as DataSource, because I'm working with EntityFramework in the data layer.

[Daniel]

In a way to show string data into a RadPivotGrid, I'm trying to handle the RadPivotGrid_CellDataBound event and add a Label inside the cell, but I can't access to the DataItem. I'm getting a AggregateError when I try to do it, because the original DataItem is a String.

protected void RadPivotGrid1_CellDataBound(object sender, PivotGridCellDataBoundEventArgs e)
        {
            Label lblCell = new Label();

            if (e.Cell.DataItem != null)
            {
                lblCell.Text = e.Cell.DataItem.ToString(); //It shows "AggregateError"
                e.Cell.Controls.Add(lblCell);
            }
        }

[Maria Ilieva]

Hello Daniel,

I would suggest you to review the online demo below which presents the needed approach for accessing all field types in RadPivotGrid:

http://demos.telerik.com/aspnet-ajax/pivotgrid/examples/appearance/conditionalformatting/defaultcs.aspx

I hope this helps.

Regards,
Maria Ilieva
Telerik

[Daniel]

I only see numbers in that example and I want to show Strings. I've posted a possible solution here.

[Maria Ilieva]

Hello Daniel,

Thank you for sharing your solution, I'm sure it will be of a big help for other users implementing similar scenarios.

Regards,
Maria Ilieva
Telerik