Introducing XMLRSDocs and RDLDocumenter

by Lisa Nicholls Fri, August 03 2007 08:04

I mentioned that I've been working on a SQL Server Reporting Services utility... I've now posted the docs for this tool as a Spacefold article. They're not done, but they're copiously illustrated and give a good idea of what it is and does.

So what is it, anyway?

  • XMLRSDocs is an idea: documentation for reports should be done the same way, as much as possible, and with the same facility, as developers have when creating documentation for class libraries and other application components.

I started with XML Comments as a model:

You ought to be able to extract some standard documentation into a usable XML schema, from any RDL or RDLC, and you ought to be able to use XML to decorate any RDL or RDLC with custom documentation elements, to be extracted at the same time if they are present.  It would be pretty easy to put the extraction process into a standard post-build step for reports, similar to how XML Comments are extracted when you build your class libraries.

Then I added to this idea, in a way that ought to be applicable to class libraries, so other people are probably doing it:

The extracted XML documentation should be easy to insert into a SQL database, so you could Do More Stuff to it.

Then I added a bit more, in a way particularly nice for reports:

Once you have your Reporting Services documentation data in database form... you should be able to get your documentation out as Reporting Services reports, as a base output format. (Duh, right?)

  • RDLDocumenter is an implementation of the idea: it's a lot of SQL Server and .NET technologies, used together, to make this possible.

You can use RDLDocumenterDesigner, the ReportDesigner add-on part of RDLDocumenter, to add notes to your report and its elements while you're working on it.  That seemed to be the make-or-break requirement to allow folks to document reports with ease. It wouldn't do to have them run the RDL or RDLC through a separate process, like a form or a wizard in which you could see the various elements of the RDL exposed and have a chance to add notes to them.  Such a form interface would allow a more elaborate UI, but it wasn't a fluent way of working. Besides, discovering more about this process was a significant motivation for working on RDLDocumenter in the first place.  As explained in my earlier post, I was trying to show how certain tasks were pretty standard when writing the design-time and run-time components of a reporting tool, no matter what the toolset.

But it turns out that, at least in the current state of the art, there are also some critical limitations in creating a ReportDesigner add-on that are worth discussing, too (and I hope to do that soon).  Plus, a design-time tool for a single report just wasn't clarifying the end-to-end documentation process that one would want.  Suppose you created some sort of processing hook that would run when the report was saved or closed in the Designer; how did this material get put together with documentation for other reports? And so on.

I ended up creating an external form as a prototype for and demonstration of the end-to-end process, and an SSIS package for a demonstration of using it in a production mode.  The various tasks in the process are also broken out as simple VBS scripts you could chain together or incorporate in some other form of processing, if you like.

While creating these external pieces, I faced a bunch of interesting challenges related to RS reporting in general. I'm hoping that the code in these pieces will serve as illustration of a whole bunch of FAQs one sees on RS forums: how do you switch between report definitions in a ReportViewer control? how do you bind datasources to a report dynamically for a ReportViewer.LocalReport? what kind of code is good for downloading a report  from a Reporting Services instance, without user interface? and so on.

We'll see how it goes...  

Tags: , , , , ,

Reporting | SQL Server | XML/XSLT | xmlRSDocs

Comments (8) -

5/3/2009 4:17:31 AM #

Luxury Travel Destinations

That is excellent stuff indeed, even though im on my first stage of XML learning but still its would be really handy.

Luxury Travel Destinations United States

5/5/2009 10:51:02 PM #

latest hindi movies

Im actively involved with XML projects so this was really helpful for me!

thank you guys for the excellent resource!

latest hindi movies United States

7/1/2009 3:49:12 PM #

Wicker

I cant figure out how it works, i was trying to work out with xml feeds but with no luck. Anyway...

Wicker Italy

7/1/2009 4:04:09 PM #

>L<

Hi there,

I haven't upgraded RDL Documenter to RS 2008 -- could that be your problem?  Not for lack of interest -- just lack of time <sigh>.

>L<

9/17/2009 1:17:42 AM #

HSA

I am an XML novice but I think I understand this. Thanks

HSA United States

1/21/2010 7:40:33 AM #

Shannon Yeaman

I am not an expert on this matter, but after learning your article, my understanding has developed considerably. I googled it about this matter and I guess many people will agree with your blog. I don’t know what to say except that I have enjoyed reading. I need to bookmark this web site so I can comeback and read more posts. Keep up the good work.

Shannon Yeaman United States

3/7/2010 4:44:53 PM #

Cabling Company New York

Thanks for the info.  It was even helpful for a beginner to XML.

Cabling Company New York United States

3/8/2010 4:38:50 AM #

vincere al gioco del Blackjack

I am having a question about document map on SQL Server 2005 Reporting Services. I found one problem with the values retrived for the document level. That is, the values are not distinct, they are duplicate for the document level.  Is it possible for us to get the distinct values for a particular document level? Hope my question is clear for your help.Thank you very much in advance for your help and advices. I am looking forward to hearing from you.

vincere al gioco del Blackjack Serbia and Montenegro (Former)