How to handle pivot table with editable feature

Hi,
I have the following table structure in MSSQL.
image

How to present it like below with data editable? User can input the data in table and then insert into above table structure.
image

I strongly suggest that you deal with that on the client, for example using the DevExpress or the FastReport components (yes, FastReport also has a pivot table).

1 Like

Hi,

I’d created a new memory table on client-side, created required fields, put data to it, assigned a grid.

finally, I’d put data back to original table and commit data to server.

note: this table should have RemoteFetchEnabled = False.

1 Like

Hi,

I contacted to DevExpress but their answer doesn’t solve my question at this moment. Thanks for your testing my case. Could you provide your sample solution for my reference?

Thanks,
Timothy

Hi,

I haven’t created testcase - just described how it should work and steps for implementing this solution

Noted.