[Solved] How? If I have one recording by cell

[Manon Girard]

Good morning,
I would like to know what is the best approach to feed my spreadsheet with your control RadGrid.

I need to build a grid to check the permissions of my roles.
------------------------------------
  Rights |  RoleA  | RoleB | RoleZ      <-Table of Roles
-------------------------------------

  RightA |    X    |       |    X 
-------------------------------------
  RightB |         |   X   |     
-------------------------------------
  RightC |    X    |       |    X 
-------------------------------------

The data structure is simple. We have 3 tables.
Table of Roles  (Header columns) 
Table of Rights (Header rows)
And a table relationship between Rights and Roles
Table RightRolesAllow (1) right --> (n) roles

Each cell is a record in the table RightRolesAllow
I have a checkbox in each cell except the first column which is a static text, in order to create or delete a record in the table RightRolesAllow.

Can I take a declarative approach, or do I build everything by programming.  

Thanks 

[Princy]

Hi,

Go through the following demo link.
Displaying pivot data

Princy.