Creating a Generic Reporting Engine/Server

[Rahul]

Hi All,
I am trying to create an Reporting engine/server which my applications
will connect to and get the reports out. Now this needs to do request
handling like if 2 many users are connected to the Server it needs to
process few concurrent and make others wait for their turn..

Now i can create an console application or a service which will use
threading to do all these tasks but my question is how to make it a bit
scalable and robust so that it can handle huge request without bringing
the server down or itself.

I might need to use this engine for an web based application for big
reporting server in that case you can understand the number of request
it will get.

Any ideas are welcome.

Thanks,
Rahul

 

[Andy]

Perhaps you should invest in Sql Server 2005 Reporting Services.

 

[Rahul]

Hi Andy,
Thanks for getting back.. I would love to use SQL Server RS.. But
unfortunately I am creating a Reporting software..So we wont be able to
use SQL's services. Needs to be something like Crystal. They have their
own reporting engine and I would like to create one for me..

Hoep you understand the requirement better,

Thanks again
Rahul