Changing report parameter visibility or making it look like dropdown list instead of textbox

[Osman]

Hi 

I have RDL file which is deployed to SSRS server. (I attached the report)

I configured my Web Api to connect to SSRS server to get and render the report. When the report is rendered its appearance looks like in below link.

Report Appearance

Please notice that report parameter named as "Param" appears as a text box. It is because I have not set "Available Values" for "Param" report parameter before I deployed to SSRS.

Here my question is, can I dynamically set the "Available Values" for any report parameter I want before the report is rendered in my ReportApiController. So then, the report would appear with "Param" parameters and parameter shall be rendered as combo box with the list of values that I dynamically set.

Thank you

Attachment: SalesAnalysis_9449e46d.zip

[Yuvaraj Devarajan]

Hi Osman, 

Sorry for the delay.  

We can dynamically edit the report RDL file in code behind and add the available value of the parameter in WebAPI and render the modified RDL file in our ReportViewer. Please find the below KB documentation for more information,  

https://www.syncfusion.com/kb/7083/how-to-edit-a-report-at-runtime   

Regards, 

Yuvaraj D. 

[Osman]

Thanks for the response. Yes, this approach indeed solved my issue. 

The only problem I see with this approach is the performance overhead of additional serialization and de-serialization cost.

With this approach report flows is pretty much like the following.

Download RDL -> Deserialize RDL -> Serialize RDL-> SF Deserialize RDL Stream -> SF RDL Rendering

Without my intervention, if I provide the RDL path to Syncfusion then 

SF Download RDL -> SF Deserialize RDL -> SF RDL Rendering

So additional steps highlighted with the red had to be done with this approach. So that slows down the performance of the report rendering.

Regards.

[Yuvaraj Devarajan]

Hi Osman, 

We have already provided this approach in our upcoming Essential studio release by passing the Deserialized value directly in WebAPI method using “ReportDefinition” as like as below code example. We have planned to release on next week.  

WebAPI: 

        public void OnInitReportOptions(ReportViewerOptions reportOption) 

        { 

            reportOption.ReportModel.ReportDefinition 

             

        } 

Regards, 

Yuvaraj D. 

[Osman]

Ok, this is great news. Thanks for the reply.

[Yuvaraj Devarajan]

Hi Osman, 

Thanks for the update. As promised earlier, the feature will be included in our upcoming Essential studio release.   

Regards, 

Yuvaraj D.