ragGrid vs radPivotGrid

[Benson Group]

Hello All:
New to the product, just purchased it last week.
What I am trying to do is take a table, in the following format, and be able to pivot (transpose rows and columns), but also be able to insert/update from this mode.

CREATE TABLE [dbo].[tablename](
[lbrID] [bigint] IDENTITY(1,1) NOT NULL,
[lbrDate] [date] NOT NULL,
[lbrName] [varchar](128) NOT NULL,
[lbrStore] [varchar](3) NOT NULL,
[lbrTime1] [money] NULL,
[lbrTime2] [money] NULL,
[lbrTime3] [money] NULL,
[lbrTime4] [money] NULL,
[lbrTime5] [money] NULL,
[lbrTime6] [money] NULL,
[lbrTime7] [money] NULL,
[lbrTime8] [money] NULL,
[lbrTime9] [money] NULL,
[lbrTime10] [money] NULL,
[lbrReconcile1] [money] NULL,
[lbrTime11] [money] NULL,
[lbrTime12] [money] NULL,
[lbrTime13] [money] NULL,
[lbrTime14] [money] NULL,
[lbrTime15] [money] NULL,
[lbrTime16] [money] NULL,
[lbrReconcile2] [money] NULL,
[lbrTime17] [money] NULL,
[lbrTime18] [money] NULL,
[lbrTime19] [money] NULL,
[lbrTime20] [money] NULL,
[lbrReconcile3] [money] NULL,
[lbrTotal] [money] NULL
) ON [PRIMARY]

Basically take that table, and have the lbrName as the columns (for each distinct name for that date) and the lbrTimes as the rows.

which grid would I be best to use? I got radGrid to work with a C# transpose (found online), this requires autogenerate columns, and it does not look like I could do inserts/edits inline with this.

I tried playing around with pivotGrid but could not get it displaying like I wanted. Perhaps I was missing something there.

Thanks in advance for any help

[Kostadin]

Hello,

I would recommend you to review the following blog post which describes how to use it and where your data are suitable to be used in RadPivotGrid or RadGrid. Additionally you could examine our live examples and our live documentation for detailed information about the provided features.

Regards,
Kostadin
Telerik