Monday, March 26, 2012

Reporting Services Rendering

We use Reporting Services for most of our reporting needs internally. However, we do have several products that we ship out into the field that run off local databases. These applications require reporting but often are not big enough for SQL Server and rarely run on a server with IIS.

Since MS has made .RDL an open xml standard does anyone know if there are any client rendering engines being developed? We would like the ability to develop all of our reports in .RDL and have them rendered in Reporting Services or in our standalone apps that run off MSDE or Access. Currently this is not possible. But, I think that someone could write a client renderer (like Crystal Reports has) to allow the use of .RDL files off a local data source without SQL Server and Web Services.

Thanks for any info on the subject.

SmokeAs far as I understand it, the .rdl files can only be put onto a SQL Server. Basically, it seems that Microsoft wants to give you the ability to access those reports through just about anything (ASP.Net, jsp pages) that can connect to an XML web service, but the actual files themselves are proprietary to just SQL Server boxes with the reporting services installed. Have you ever thought about creating those reports on a server and connecting to them through those programs across the internet and encrypting them?

No comments:

Post a Comment