I want to create an editable grid using sql query. Like this
in the rows there are files and in the columns there are the package names. If we tick a cell then the file will be included in the corresponding package. For example in the image above if I tick the cell corresponding row test1.txt and column 22000 then test1.txt file will be included in the package 22000.
Similarly if we untick any cell then the file will be removed from the package.
I have files and packages table. I have tried an interactive report for pivoting but there I am not able to edit the cell.(Tick and untick can be done using 1 and 0 too where 1 means tick, 0 means untick). And if i use an interactive grid then i am able to edit the cell but i am not able to pivot.
Any guidance will be highly appreciated.
Thanks
Hritik