Reporting tool with angular 5 and .net Core 2

Question

I am trying to build my first application using angular 5 and .NET core 2; The application is created in visual studio 2017 as one empty website based on .Net core 2; I am using angular 5 for the client-side, and to maintain data-access, security, authorization ... I am creating Web API controllers using .Net core 2 which will be called from angular; What I still don't know is how to create reports which requirements are the below:

1. Reports are textual and they can contain sub-reports or images;
2. They should be created in server side as some of them should be saved on the webserver
3. They should be exported as images or PDF files
4. They should be also displayed on HTML page whether they were saved or not on the webserver: so there should be a way to revert back to angular 5 and display those reports on the browser
5. Please note that I have no SQL Database but Oracle 11G, which I guess in this way I have to create a data-set and fill it, then this dataset will be used in the report.

Before, I used to create RDLC or crystal reports with all the above, and I could run new tab from server side to display my reports; But now things are more complicated and new... So any hint is more than appreciated.

Answer 1

I have a simple idea will fix your problem. If you want with Crystal reports or SSRS:

1. Generate a new Web Form project that uses Crystal Report Viewer.
2. The new project has only two pages: Index.aspx, Report.aspx.
3. Index.aspx will receive report id and additional parameters of the report.
4. Index.aspx will open Report.aspx after internal processing.
5. Once the page Report.aspx is viewed, user can view, navigate and print the report.

If you want to use SSRS, you'll replace Crystal report.

This solution will cost you nothing except hosting the Web Form project on a server.

Hope this solution fix your problem.