ReportServer Forum

Kritsanapong

Member

Registered: 2024-07-17

Setting report variant parameter via scripting

Hi,

I am trying to import Jasper Report Schedulers into Report Server.

I have a number of schedulers for a Jasper report where each scheduler is providing different parameters, such as client IDs, to the same report and sent to different clients.
I understand that within Report Server, I would need to create a report and one variant per client where each variant would contain the parameters for each particular client. Then I would need to create one scheduler for each variant to send the reports to each client.

Using the scripting feature, I was able to create a report and a variant. However, I am struggling with setting the parameter to each variant as it seems the parameters are not persisted.

Could you provide guidance on how to correctly assign parameter values to a variant?

The code I used to unsuccessfully assign parameters to a variant is shown below

    def reportParameterService = GLOBALS.getInstance(ReportParameterService);
    def reportService = GLOBALS.getInstance(ReportService);

    def report = reportService.getNodeByPath(reportUnitURI);
    def variantReport = ((JasperReport)report).createNewVariant(report)
    variantReport.setName(label);

    for (item in parameterMap) {
        def definition = variantReport.getParameterDefinitionByKey(item.key);
        if (definition != null) {
            def instance = variantReport.getParameterInstanceFor(definition);
            if (definition.getMode() == Mode.Single) {
                def parameter_value = item.value.get(0);
                def instance_value = new DatasourceParameterData();
                instance_value.setKey(parameter_value);
                instance_value.setValue(parameter_value);
                instance.setSingleValue(instance_value);

                // Tried persisting the ParameterInstance, merging the ParameterDefinition and merging the ReportVariant with no success
                reportParameterService.persist(instance);
                reportParameterService.merge(definition);
                reportService.merge(variantReport);
            } else if (definition.getMode() == Mode.Multi) {
                def instance_value_list = new ArrayList();
                for (parameter_value in item.value) {
                    def instance_value = new DatasourceParameterData();
                    instance_value.setKey(parameter_value);
                    instance_value.setValue(parameter_value);
                    instance_value_list.add(instance_value);
                }
                instance.setMultiValue(instance_value_list);

                // Tried persisting the ParameterInstance, merging the ParameterDefinition and merging the ReportVariant with no success
                reportParameterService.persist(instance);
                reportParameterService.merge(definition);
                reportService.merge(variantReport);
            }
        } 
    }