Alternate to SSRS? Server side report generation in windows app?

Question

I wish to generate the report in server without using the SSRS. Is there any report engine which returns the report in HTML or any other format (like pdf,xml,.) to the client. I would like to consume the resultant report from web and windows application. The report engine should take care of pagination and it should return only the records that belong to current page.

satheesh kumar · Answer

Hi Niki Thanks. I am having more than 10000 records in so many tables and the databases are different (SQL server and oracle). I don't like to use SSRS due to licensing. If I would like to show only 10 to 20 records in a report page I need to hold all the records in memory(dataset) of client machine in case of windows app. I am accessing the report from windows & web application. would like to optimize the report generation so I like to move the report generation process to a centric server (for eg. web service)  which should take care of report generation based on the input parameters and return me the report alone with the features like pagination export to various forms. Hope somebody will help me.

Nilanka Dharmadasa · Answer

Use crystal reports.