ReportServer Forum

Johann

Member

Registered: 2022-05-30

Disable Editing in Grid Editor Reports

I would like to use the Grid Editor reports for their ability to filter and sort datasets easily, but do not want the user to be able to edit the underlying data. I understand it is possible to disable the adding and removing of records, and to set individual columns as not editable (https://reportserver.net/en/guides/admi … r-Reports/) but I cannot find an option to set the whole table as not editable. Moreover, I want the same configurations to apply to other Grid Editor reports as well and I do not want to have to copy and paste such configurations across reports to minimise duplicated code.

Is there a single method to disable any kind of edits (CRUD) without having to call multiple methods?

Last edited by Johann (2022-07-07 07:38:32)

IF_Eduardo

Administrator

Registered: 2016-11-01

Website

Re: Disable Editing in Grid Editor Reports

Hi Johann,

you have dynamic lists for this. Why do you want to use grid reports instead of dynamic lists? The most powerful filtering/sorting is available in dynamic lists.

Regards,
Eduardo

Johann

Member

Registered: 2022-05-30

Re: Disable Editing in Grid Editor Reports

Hi Eduardo,

Grid Reports seem to have a better user experience:

1. Grid Reports do not require the user to select which columns to display, which some find cumbersome when using Dynamic Lists.
2. Grid Reports also allow very convenient sorting of columns unlike Dynamic Lists, where users have to select the sorting method before previewing the report.

Regards,
Johann

IF_Eduardo

Administrator

Registered: 2016-11-01

Website

Re: Disable Editing in Grid Editor Reports

Hi Johann,

for both 1. and 2. : if you save the report as a variant, with the column and sorting configuration you need, the user doesn't have to change anything. Are you using variants or only base reports?

Regards,
Eduardo

Johann

Member

Registered: 2022-05-30

Re: Disable Editing in Grid Editor Reports

Hi Eduardo,

I am using base reports. The user would like to customise the sorting as and when they like to play around with the figures. Would this be possible with variants?

Regards,
Johann

IF_Eduardo

Administrator

Registered: 2016-11-01

Website

Re: Disable Editing in Grid Editor Reports

Hi Johann,

yes, you provide the basic configuration with variants and the user can modify them as needed. Just try them

Regards,
Eduardo

Johann

Member

Registered: 2022-05-30

Re: Disable Editing in Grid Editor Reports

Dear Eduardo,

Got it, thank you Eduardo!

Regards,
Johann

Johann

Member

Registered: 2022-05-30

Re: Disable Editing in Grid Editor Reports

Hi Eduardo,

Sorry, I'm not sure if I am understanding correctly. I created a default variant for a dynamic list and imported it into a teamspace. As a user, after opening the report from the teamspace how would they customise the columns or sort them? I understand these could be done under the "Configure list" section, but the users would like to be able to accomplish the same in the preview window itself:

Last edited by Johann (2022-07-19 07:14:31)

IF_Eduardo

Administrator

Registered: 2016-11-01

Website

Re: Disable Editing in Grid Editor Reports

Hi Johann,

... right click on the dynamic list

Regards,
Eduardo

Johann

Member

Registered: 2022-05-30

Re: Disable Editing in Grid Editor Reports

Hi Eduardo,

I see... Had no idea that was possible. Thanks so much!

Regards,
Johann