Monday, March 12, 2012

Possible to use Reporting Services w/o Sql Server?

This is a very simple question which very probably has an obvious answer.

Is there any way to make use of the rendering facilities that Reporting Services offers without having to install SQL Server? The way that I'm planning to use RS is by supplying an XML Data file and reporting from that. I never plan to report from a database of any kind.

I haven't been able to find any evidence that I will be able to do what I'm asking for, but it seems reasonable that if Microsoft supports XML files as a datasource, that maybe the meta-data and configuration data that RS uses could also be stored in XML files.

Thanks,
Ken

Simple answer: Yes.

Check out this episode of MSDN.TV: http://msdn.microsoft.com/msdntv/episode.aspx?xml=episodes/en/20050616SQLServerBW/manifest.xml|||Daniel --

Thank you for that information. That may very well be the best answer to my problem.

The only thing that could make this situation better is if there were some classes (instead of a windows forms control per se) that I could use to do all of the functions of the report viewer control. I am constructing a COM object which is to take an RDL file, XML file (housing the report data), export format, and destination of export file. The COM object is to then programatically process the report, apply the data to the reprot, export the report to the specified format, and finally dump the file to its final destination. Ultimately I am hoping that I can use a Microsoft class that will process the report and give me a stream of bytes representing the report in the export format of my choosing.

If I could do all of that -- preferably without connecting to Reporting Services or the report viewer controls -- I think that I could craft a very fitting solution.

Thanks,
Ken

No comments:

Post a Comment