Reports not rendering

[Joe Samraj]

Hi,

   We have rendered the reports using ejReportViewer bold reports. for some reason the parameters entered on the report viewer control is not passed back to the report. Basically the report is always rendered as empty.

   I have attached the Report Service Code,rdl file and the html file. I'm using BoldReports.Net.Core 2.2.34.

Thanks,

Joe

Attachment: Support_a2c49080.zip

[Vinoth Srinivasan]

Hi Joe, 

We have validated the shared files at our end and found that you are using EJ1 ReportViewer scripts at client and using Bold Reports packages in WebAPI service application. So, we request you to use Bold Reports on both client and server application and you can refer the below help documentation to pass parameter to reportviewer from API controller. 

https://documentation.boldreports.com/angular/report-viewer/report-parameters/#set-parameters-in-web-api-controller 

Regards, 

Vinoth S. 

[Joe Samraj]

Thanks for your reply Vinoth.

Actually we are using Angular JS. So I think we can use the jQuery component to display the SSRS report. Do you have any sample file which contains the library needs to be added in the client side (jQuery) and passing parameter to SSRS report?

Thanks,

Joe

[Joe Samraj]

Hi Vinoth,

   I have made the changes in the client file. But still the I have the same issue.

Regards,

Joe

Attachment: ssrs_poc__Phantom_JSBoldReports_57d849cc.zip

[Vinoth Srinivasan]

Hi Joe, 

Actually we are using Angular JS. So I think we can use the jQuery component to display the SSRS report. Do you have any sample file which contains the library needs to be added in the client side (jQuery) and passing parameter to SSRS report?

We did not consider AngularJS for Bold Reports, since it’s in LTS from July 1st 2018 onwards. Please refer the below forum.  https://docs.angularjs.org/misc/version-support-status  So, we suggest you use our JavaScript control in your AngularJS application and you can refer the below online forum for using the jQuery control in an AngularJS application.   Reference Link: How to use jQuery in AngularJS application  Also, you can refer the below help links to initialize our JavaScript ReportViewer and  CSS/Scripts.  https://documentation.boldreports.com/javascript/report-viewer/display-ssrs-rdl-report-in-javascript-application/#adding-report-viewer-widget  https://documentation.boldreports.com/javascript/report-viewer/display-ssrs-rdl-report-in-javascript-application/#refer-scripts-and-css

I have made the changes in the client file. But still the I have the same issue.

We have tried to pass the parameter from client to ReportViewer and it has been working fine. Please find the below snap for your information.    Please find the below API controller project we have used to validate this from below link.  https://www.syncfusion.com/downloads/support/forum/154750/ze/ReportViewerAPI628436227.zip  Note : You can find the previously shared “Test.rdl” in resources folder and change the DataSource connection to run the report.  You can modify and share the above API project if you still face any issue.

 

Regards, 

Vinoth S. 

[Joe Samraj]

Vinoth thanks for looking into this. The file you have given is working. When I change the below lines in the API,

 System.IO.FileStream reportStream = new System.IO.FileStream(basePath + @"\Resources\" + reportOption.ReportModel.ReportPath + ".rdl", System.IO.FileMode.Open, System.IO.FileAccess.Read);

            reportOption.ReportModel.Stream = reportStream;

            reportOption.ReportModel.ReportServerCredential = new System.Net.NetworkCredential("*****", "*****");

            reportOption.ReportModel.DataSourceCredentials.Add(new DataSourceCredentials("<datasourcename>", "*****", "*****"));

and changed the client file as below,

reportPath: "QA",

reportPath: "QA/Test"     (Path of the file in report server)

It is not working now.

Thanks,

Joe

Attachment: Support_Syncfusion_b04998c.zip

[Vinoth Srinivasan]

Hi Joe, 

Could you please confirm the version of SSRS report server you are using. Since pure .Net Core project will support only SSRS 2017 and above server. Also, share the screen snapshot and console error with us to validate this further. 

Regards, 

Vinoth S. 

[Joe Samraj]

Hi Vinoth,

   We are using SSRS 2017. I have attached the console errors. Actually we have created a incident for this issue (Incident ID: 279271). Shall we have a call and share screen to debug this?

Regards,

Joe

Attachment: SSRS_Error_dc6ff159.zip

[Vinoth Srinivasan]

Hi Joe, 

As per the meeting now you are able to send the parameter from client to ReportViewer and report has been rendering properly based on the parameter. 

Regards, 

Vinoth S. 

[Joe Samraj]

Thanks Vinoth for your help. One question. The API is publicly accessible is there any authentication needs to be implemented for that? do you have any example/documentation for that?

Thanks,

Joe

[Vinoth Srinivasan]

Hi Joe, 

Could you please provide more details on which API you are asking and it will be helpful for us to provide the solution. 

Regards, 

Vinoth S. 

[Joe Samraj]

Hi Vinoth,

   The .Net Core API project which we create.

Thanks,

Joe

[Vinoth Srinivasan]

Hi Joe, 

You can include authentication for .NET Core in our Report Viewer API as suggested from framework. 

https://docs.microsoft.com/en-us/aspnet/core/security/authentication/?view=aspnetcore-3.1 

You can refer the below article for using authorization with Report Viewer API  requests. 

https://documentation.boldreports.com/embedded-reporting-tools/faq/add-authorization-header-for-report-service/ 

Regards, 

Vinoth S.