{"id":67,"date":"2011-02-27T15:15:00","date_gmt":"2011-02-27T15:15:00","guid":{"rendered":"\/lisa\/post\/2011\/02\/27\/What-a-difference-a-year-and-a-job-change-make.aspx"},"modified":"2021-08-30T13:14:55","modified_gmt":"2021-08-30T20:14:55","slug":"what-a-difference-a-year-and-a-job-change-make","status":"publish","type":"post","link":"https:\/\/spacefold.com\/lisa\/2011\/02\/27\/what-a-difference-a-year-and-a-job-change-make\/","title":{"rendered":"What a difference a year, and a job change, make"},"content":{"rendered":"

I honestly cannot believe that I started to work on xmlRSDocs in November 2009<\/a> and, only now, have gotten the whole thing squared away.<\/p>\n

But there it is.\u00a0 I did just enough work for my real-life need-at-the-time, and put it aside.<\/p>\n

Now real life\u00a0requirements have\u00a0prodded me back into harness on this project, so I’ve spent all my free time for the past month doing a pretty thorough job on xmlRSDocs 2008.\u00a0 The docs<\/a>\u00a0are now up-to-date, and the revamped download<\/a>\u00a0for xmlRSDocs contains full source, samples, and deployment bits.<\/p>\n

A changed focus<\/h2>\n

In this version, there’s no longer an RDLDocumenter Designer tool, because Custom Properties can now be dealt with through Report Builder and Report Designer\u00a0standard UI. If you don’t know how to, or don’t know why you would want to, use Custom Properties to add documentation to a report, you can read the docs<\/a>\u00a0for some of my thoughts about the type of custom documentation I think RDLs ought to have.<\/p>\n

But don’t worry about that immediately.\u00a0 It turns out that what people (including me) really need and want is simply good, customizable access to the native contents of an RDL.\u00a0 We simply don’t have this, out-of-the-box, and we really need it.<\/p>\n

What’s in it for [you and] me<\/h2>\n

Consider this scenario: you want to make a change in a stored procedure or a view, and you want to be certain of what impact this change will have.\u00a0 What do you do?<\/p>\n

In SQL Server Management Studio, you can right-click on an object and check its dependencies.\u00a0 Right?<\/p>\n

Well, no.\u00a0\u00a0You’re going to get information\u00a0about intra-database dependencies, sure. But SQL Server Management Studio isn’t going to look any further than it can see…\u00a0 and it can’t see your SSRS reports.<\/p>\n

When I joined the Santa Rosa City Schools District<\/a>, I entered an environment that had literally hundreds of SSRS reports deployed in production servers, most of which had multiple datasets.\u00a0 Whether the datasets were driven by embedded SQL, stored procedures, or semantic models, none of these datasets were “visible” using standard means.<\/p>\n

Recently, I was trying to figure out the source of an occasional deadlock in a critical database, the one that serves as the source for all these datasets.\u00a0I realized that I absolutely, positively had to include reporting dependencies in the “universe” of code I was looking at, to understand performance issues, resource contention, etc.<\/p>\n

Before you say “why are reports pointed at a transactional database?” … don’t get me started.\u00a0 Just take it as read: 350+ of them are<\/strong>, whether we like it or not.<\/p>\n

I needed clear visibility into the statements and procedures driving those datasets.\u00a0 I also decided I wanted an easy way to list the entities and objects within embedded SQL statements “buried” in RDLs,\u00a0to augment\u00a0the dependency lists I could get by rightclicking in SQL Management Studio.<\/p>\n

It was already possible to do what I wanted to do using xmlRSDocs, without enhancements.\u00a0 But\u00a0it took a tedious and lengthy pull of all the RDLs from the server using RS Scripter<\/a>, and then rearranging the scores of folders of RDLs so that they’d all be available for parsing and loading.\u00a0 It became abundantly, and somewhat\u00a0painfully, clear to me that\u00a0there was lots more that xmlRSDocs could, and should, do to help.<\/p>\n

So I abandoned the idea that I was ever going to update the Custom Report Item for design-time use — which was cool to do once, but wasn’t at all practical and isn’t even necessary any more. I\u00a0rolled up my sleeves to concentrate on creating an SSIS package that would do everything I actually needed.<\/p>\n

\"\"<\/p>\n

The new package uses SOAP access to grab each RDL from a ReportServer catalog.\u00a0 It processes each RDL according to the proper namespace (because these reports have been created over a very long time span, some are 2005, some are 2008, and some soon will be 2010).\u00a0 As the original package did, it allows you to save the doc.XML results to disk and also to load the documentation to an “RDL Doc” database of your choice.<\/p>\n

As before, it offers you the change to publish or “export” your documentation by invoking an SSRS report — using URL Access for this action — at the end of its run.\u00a0 In this delivery, I’ve included a bare-bones-but-usable RDL and some fancy parsing to support it, so that the “export” provides a list of all the entities and procedures on which the RDLs you’ve documented depend.\u00a0 Of course, you can still use any RDL you choose, and do much more exciting things if you need them, you can still create any schema you like for your xmlRSDocs database, etc, but this is a pretty good base.<\/p>\n

TestHarness got revamped with new features, too. This winForm application is now renamed xmlRSDocsHarness, because it turns out to be pretty useful on its own, not just as a teaching tool to help you understand the xmlRSDocs idea.<\/p>\n

\"\"<\/p>\n

Enjoy.<\/p>\n

Now to\u00a0get\u00a0cracking on that dependency sleuthing…<\/p>\n","protected":false},"excerpt":{"rendered":"

I honestly cannot believe that I started to work on xmlRSDocs in November 2009 and, only now, have gotten the whole thing squared away. But there it is.\u00a0 I did just enough work for my real-life need-at-the-time, and put it aside. Now real life\u00a0requirements have\u00a0prodded me back into harness on this project, so I’ve spentRead more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5,6,7,10,11],"tags":[],"class_list":["post-67","post","type-post","status-publish","format-standard","hentry","category-reporting","category-sql-server","category-ssis","category-xml-xslt","category-xmlrsdocs"],"_links":{"self":[{"href":"https:\/\/spacefold.com\/lisa\/wp-json\/wp\/v2\/posts\/67","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/spacefold.com\/lisa\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/spacefold.com\/lisa\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/spacefold.com\/lisa\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/spacefold.com\/lisa\/wp-json\/wp\/v2\/comments?post=67"}],"version-history":[{"count":2,"href":"https:\/\/spacefold.com\/lisa\/wp-json\/wp\/v2\/posts\/67\/revisions"}],"predecessor-version":[{"id":388,"href":"https:\/\/spacefold.com\/lisa\/wp-json\/wp\/v2\/posts\/67\/revisions\/388"}],"wp:attachment":[{"href":"https:\/\/spacefold.com\/lisa\/wp-json\/wp\/v2\/media?parent=67"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/spacefold.com\/lisa\/wp-json\/wp\/v2\/categories?post=67"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/spacefold.com\/lisa\/wp-json\/wp\/v2\/tags?post=67"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}