Last post Oct 14, 2017 09:50 AM by VitaliyMF
Oct 02, 2017 04:04 PM|sajilprasad|LINK
I am planning to develop a web application which needs to be hosted in windows server 2012 R2 VPS Server. I have used SAP crystal reports and faced so many issues (memory related mainly) and do not want to proceed with that.
I am asking for a better solution which will help me to generate custom reports in memory efficient way. I need the reports to take input parameters and produce the reports accordingly as like in crystal reports. The report should also have the facility
to put header and footer images, hiding the data using custom formula etc.
Please can you refer a good tool which will be easy to integrate in VS as well as get easily hosted. I am looking something similar to Crystal reports which needs to be light weighted and if possible with charts support (optional).
Oct 06, 2017 02:43 AM|Zhi Lv - MSFT|LINK
I suggest you could try to use the RDLC Reports to display the report. Please check the following link:
Besides, you could also try to use some JQuery data table plugin to display the report data
such as: JQuery DataTable plugin: https://datatables.net/
Oct 14, 2017 09:50 AM|VitaliyMF|LINK
What kind of reports you need? If this is summary reports like pivot tables (crosstabs) / pivot charts take a look to
PivotData Toolkit for .NET - this is C# components that could be easily integrated into any ASP.NET app (either WebForms, MVC5 or MVC Core). This library allows you to perform data aggregation
on database level (with GROUP BY) and you don't need to load all dataset into memory; you can apply any custom calculations you need. Also, you can check PivotData Microservice - this is ready-to-use mini-ROLAP server that can be configured with JSON config
and provide all report-generation functions with simple web API.