Sending parameters to ReportWriter

[Karmen]

Hello!

I would like to design a RDL report and fill it with the data that I always select.

To be more precise, is it possible to send parameters or the data itself to ReportWriter (I would like to avoid using RDLC format for now), so that I can pass that parameters to queries in datasets and if so, how?

I would be glad to receive any thoughts on how to achieve this functionality.

Regards, 

Karmen Gostiša

[Vinoth Srinivasan]

Hi Karmen, 

 

Thanks for contacting Syncfusion support. 

 

You can use ReportWriter’s  “SetParameters” API to specify values to the ReportParameters used in the report at code behind. Please refer to our Knowledge Base for more details on this. 

https://www.syncfusion.com/kb/7050/how-to-set-parameter-to-reportwriter 

 

We have also prepared a sample with RDL report for your reference, it can be downloaded from the following location. 

http://www.syncfusion.com/downloads/support/forum/127506/COMPAN~11853807844.ZIP 

 

Regards, 

Vinoth S. 

[Karmen]

Hi!

Thank you for your helpful answer. The solution does exactly what I need. But just for the side note - there is a bug in your sample. The line reportWriter.Save(fileName, format); and lines concerning MessageBox should be below IList parameters initialization and reportWriter.SetParameters(parameters) otherwise the parameter values do not have any impact.

Regards,

Karmen Gostiša

[Vinoth Srinivasan]

Hi Karmen, 

Sorry for the inconvenience. 

Yes, you have to set the parameter values before the Save() method in report writer to update the default parameter values. Please let us know if you require further assistance on this. 

Regards, 

Vinoth S. 

[abelardo silvas cortez]

Hi Karmen, 

Sorry for the inconvenience. 

Yes, you have to set the parameter values before the Save() method in report writer to update the default parameter values. Please let us know if you require further assistance on this. 

Regards, 

Vinoth S. 

Hello

I have a problem with a reference, it flags this error "can not convert from 'System.Collections.Generic.IList <Syncfusion.JavaScript.Models.ReportViewer.ReportParameter>' to 'System.Collections.Generic.IEnumerable <Syncfusion.Reports .EJ.ReportParameter> '"

I hope someone can help me please....

[Mageshyadav M]

Hi Abelardo, 

 

Can you confirm whether the below sample runs fine on your side, 

 

http://www.syncfusion.com/downloads/support/forum/127506/COMPAN~11853807844.ZIP  

 

In the above sample, we have passed the IList to IEnumerable collection only but we didn’t get any conversion error. Please find the snippet used, 

 

                IList<ReportParameter> parameters = new List<ReportParameter>(); 

                foreach (var parameter in reportWriter.GetParameters()) 

                { 

                    ReportParameter param = new ReportParameter(); 

 

                    param.Name = parameter.Name; 

 

                    param.Values.Add("Ottawa"); 

 

                    parameters.Add(param); 

 

                } 

 

                reportWriter.SetParameters(parameters); 

 

Otherwise typecast similar to below snippet 

 

reportWriter.SetParameters(parameters as IEnumerable<ReportParameter>); 

 

Regards, 

Mageshyadav.M 

[abelardo silvas cortez]

Hi Abelardo, 

 

Can you confirm whether the below sample runs fine on your side, 

 

http://www.syncfusion.com/downloads/support/forum/127506/COMPAN~11853807844.ZIP  

 

In the above sample, we have passed the IList to IEnumerable collection only but we didn’t get any conversion error. Please find the snippet used, 

 

                IList<ReportParameter> parameters = new List<ReportParameter>(); 

                foreach (var parameter in reportWriter.GetParameters()) 

                { 

                    ReportParameter param = new ReportParameter(); 

 

                    param.Name = parameter.Name; 

 

                    param.Values.Add("Ottawa"); 

 

                    parameters.Add(param); 

 

                } 

 

                reportWriter.SetParameters(parameters); 

 

Otherwise typecast similar to below snippet 

 

reportWriter.SetParameters(parameters as IEnumerable<ReportParameter>); 

 

Regards, 

Mageshyadav.M 

thanks for the reply!

I think the problem is in the type of data that does not match

Syncfusion.JavaScript.Models.ReportViewer.ReportParameter

with Syncfusion.Reports .EJ.ReportParameter

cree que sea un using? 

[Mageshyadav M]

Hi Abelardo, 

  

Thanks for your update.  

  

Sorry for suggesting sample in WPF based on platform chosen in forum. Yes, you need to pass Syncfusion.Reports.EJ.ReportParameter only to report writer setParameter method. 

  

Hope, the issue has been resolved on your side based on proper namespace reference.  

  

Regards, 

Mageshyadav.M