ASP.NET application with SSRS - Optimize the generation of PDF from the report
Budget: $30 – $250 USD
I have an ASP.NET application which generates several SSRS reports.
The app uses the reports in local processing mode: the reports are generated as RDLC, and the data is loaded into them through the dataTable and parameters. So the reports are not actually run on a SSRS server, and no actual connection to the database is made.
Before generating the report, the data is shown in a gridview on a form, for user to view / edit / etc.
Then that data is loaded into a DataTable and the feed to the report. The problem is, while the preparing of the datatable in my code is nearly instant when I start generating the reports (for preview in report viewer or render as PDF and send to client) it takes a very long time.
It was rather quick some time ago, when the report definition (RDLC) was in the format of SQL Server 2005.
However since I updated to newer versions (2008+) the report generation takes a lot of time.
Even for small data sets, tens of records it takes tens if seconds.
For large reports it is unusable.
I have datasets that load on the datagrid views with 30000 records (!!!) in seconds, but to generate the PDF it takes ages.
I need this to be optimized.
It should generate the PDF fast with both small sets and large sets (30k+ records)
The application is ASP.NET, but uses a framework that implements a Winforms-like interface (both UI and programatic) that runs in browser. So the coder needs to be comfortable with both Winforms programming and classic ASP.NET (not MVC)
The image attached is a section from the web page, even if it looks like WinForms
In the first phase I just want the generation of only one report to be optimized for PDF generation. If this task is completed successfully, the next task will be to implement the Report viewer in browser, and then to optimize all the rest of the reports.
The work will be done remotely over RDP on a VM in cloud.
The VM uses SSD storage and 16Gb Ram.
The coder doesn't need to download and setup anything - the VS solution is ready to run. So there will be no additional downtime for unproductive, administrative work.
Skill needed:
- the code - C# - Visual Studio 2019
- the reports solution - VS 2013 Business Intelligence
- DB - Sql Server 2017
- Programming skills: ASP.NET and WinForms
- Subversion - SVN
The app uses the reports in local processing mode: the reports are generated as RDLC, and the data is loaded into them through the dataTable and parameters. So the reports are not actually run on a SSRS server, and no actual connection to the database is made.
Before generating the report, the data is shown in a gridview on a form, for user to view / edit / etc.
Then that data is loaded into a DataTable and the feed to the report. The problem is, while the preparing of the datatable in my code is nearly instant when I start generating the reports (for preview in report viewer or render as PDF and send to client) it takes a very long time.
It was rather quick some time ago, when the report definition (RDLC) was in the format of SQL Server 2005.
However since I updated to newer versions (2008+) the report generation takes a lot of time.
Even for small data sets, tens of records it takes tens if seconds.
For large reports it is unusable.
I have datasets that load on the datagrid views with 30000 records (!!!) in seconds, but to generate the PDF it takes ages.
I need this to be optimized.
It should generate the PDF fast with both small sets and large sets (30k+ records)
The application is ASP.NET, but uses a framework that implements a Winforms-like interface (both UI and programatic) that runs in browser. So the coder needs to be comfortable with both Winforms programming and classic ASP.NET (not MVC)
The image attached is a section from the web page, even if it looks like WinForms
In the first phase I just want the generation of only one report to be optimized for PDF generation. If this task is completed successfully, the next task will be to implement the Report viewer in browser, and then to optimize all the rest of the reports.
The work will be done remotely over RDP on a VM in cloud.
The VM uses SSD storage and 16Gb Ram.
The coder doesn't need to download and setup anything - the VS solution is ready to run. So there will be no additional downtime for unproductive, administrative work.
Skill needed:
- the code - C# - Visual Studio 2019
- the reports solution - VS 2013 Business Intelligence
- DB - Sql Server 2017
- Programming skills: ASP.NET and WinForms
- Subversion - SVN