#1 2019-02-12 12:43:06

Amar
Member
From: Montpellier (France)
Registered: 2019-02-12
Website

Hide or disable calculated fields, pre-filter and list configuration

Hello,

We would like to know if it is possible, during the execution of a variant, to hide or deactivate the options calculated fields, pre-filter and list configuration for all or part of the users?
On the other hand one would need to keep active parameter of the report and preview.

Thank you in advance for your help,
Amar

Offline

#2 2019-02-12 13:09:50

eduardo
Administrator
Registered: 2016-11-01
Website

Re: Hide or disable calculated fields, pre-filter and list configuration

Hi Amar,

which version exactly are you using (rsversion.properties)

Regards,
Eduardo

Offline

#3 2019-02-12 13:50:24

Amar
Member
From: Montpellier (France)
Registered: 2019-02-12
Website

Re: Hide or disable calculated fields, pre-filter and list configuration

hello Eduardo,

Actually, I forgot to be precise, we are in version RS3.0.5-6005 still in period of test.

Thank you in advance,
Amar.

Offline

#4 2019-02-12 15:23:54

eduardo
Administrator
Registered: 2016-11-01
Website

Re: Hide or disable calculated fields, pre-filter and list configuration

Hi Amar,

you can set the configuration-protection to true for the variant required. In 3.0.5, there is a (GUI) Bug and the configuration-protection can not be set in the browser. This will be fixed in 3.0.6 (released soon).

In the meanwhile, try this script:

import net.datenwerke.rs.core.service.reportmanager.ReportService
import net.datenwerke.rs.core.service.reportmanager.entities.reports.Report

ReportService reportService = GLOBALS.getInstance(ReportService.class)
Report report = reportService.getReportById(2078898) //your variant's id
report.setWriteProtection(true) //needed for configuration protection
report.setConfigurationProtection(true)

Remember to execute the script with the commit flag turned on (-c) to write the changes to the database.

Regards,
Eduardo

Offline

#5 2019-02-13 14:20:56

Amar
Member
From: Montpellier (France)
Registered: 2019-02-12
Website

Re: Hide or disable calculated fields, pre-filter and list configuration

Hello and thank you Eduardo,

I found in the forum the post "https://forum.reportserver.net/viewtopic.php?pid=5163" and we managed to activate the protection of variants.

What has bothered us in this solution is that we lose access to the report parameters. We wish to inhibit only calculated fields, prefilter and configuration list for all or part of our users (later advanced users will probably have access to it but not before being trained).

Do you have a solution for us?

Thanks in advance,
Amar.

Offline

#6 2019-02-13 14:34:45

eduardo
Administrator
Registered: 2016-11-01
Website

Re: Hide or disable calculated fields, pre-filter and list configuration

Hi Amar,

parameters are part of the variant configuration, that's why these are disabled for configuration-protected variants.

Why don't you just create a protected variant for the untrained users and another variant on the same report for the trained users?

Regards,
Eduardo

Offline

#7 2019-02-13 15:30:08

eduardo
Administrator
Registered: 2016-11-01
Website

Re: Hide or disable calculated fields, pre-filter and list configuration

Hi Amar,

you can also control the parameters via "user variable" parameter type: check https://reportserver.net/en/guides/admi … Variables/ and https://reportserver.net/en/guides/admi … arameters/ (User variable Enables to readout so-called user variables. User variables are discussed in detail in Chapter 8.)

In this case, parameters are controlled by the user variables, so disabling the parameter panel doesn't disrupt the parameter configuration for different users.

Regards,
Eduardo

Offline

#8 2019-02-18 07:59:11

Amar
Member
From: Montpellier (France)
Registered: 2019-02-12
Website

Re: Hide or disable calculated fields, pre-filter and list configuration

Hello and thank you Eduardo,

we will try to cope with the user variables.

Thank you again for your help and your responsiveness.

Regards,
Amar.

Offline

Board footer

Powered by FluxBB