Dynamic SSRS report documentation via a ReportServer.dbo.Catalog query

  • Stan Kulp-439977

    SSCrazy Eights

    Points: 9948

    Rodan - Tuesday, March 21, 2017 9:24 AM

    te acountsreceivables part of the query is pretty odd...

    The webmin had not put in my latest update. It is in now. Try downloading the attachment again.

  • Tim Toennies

    SSC Veteran

    Points: 246

    I downloaded the zip file.  The rdl file contained in it has a date of 2/3/2017.

    I am still getting the same error:

    In the AcctRecMinTransDate TextBox there is this expression:  =Fields!AcctRecMinTransDate.Value & " through " & Fields!AcctRecMaxTransDate.Value
    But that is not retrieved in the ReportServerCatalogQuery Dataset which is the only Dataset in the report.

  • DougDurham

    Valued Member

    Points: 59

    Nice query! I couldn't make it run because of the various references to AccRec... , so I just manually edited the rdl to change all of those to empty strings.  Works great now!

  • o103452@rtrtr.com

    Ten Centuries

    Points: 1025

    This is a pretty helpful concept. Thanks
    Now, something like this for SSIS would be pretty neat as well. 😉

  • Stan Kulp-439977

    SSCrazy Eights

    Points: 9948

    o103452 - Tuesday, April 11, 2017 9:35 AM

    This is a pretty helpful concept. Thanks
    Now, something like this for SSIS would be pretty neat as well. 😉

    You would have to be running the SSIS packages from the SSISDB catalog.
    I have been looking into it, but you have to deploy entire projects instead of individual SSIS packages.

  • Gary Nease

    Old Hand

    Points: 357

    Not complaining, just an FYI for those who were alarmed by three minute duration...

    I tested it on a QA VM and it ran 10 minutes. 
    "A man's got to be aware of his limitations." ~ Detective Harold Francis Callahan


    Regards,

    Gary

  • SQLRNNR

    SSC Guru

    Points: 281210

    Nice job. I had just finished writing up a similar query for the same reasons. Integrating it into a report would be helpful.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • Stan Kulp-439977

    SSCrazy Eights

    Points: 9948

    Gary Nease - Tuesday, April 11, 2017 11:56 AM

    Not complaining, just an FYI for those who were alarmed by three minute duration...

    I tested it on a QA VM and it ran 10 minutes. 
    "A man's got to be aware of his limitations." ~ Detective Harold Francis Callahan

    I wrote this as a proof-of-concept. It can definitely be improved.

  • Gary Nease

    Old Hand

    Points: 357

    Thanks very much to you and Lowell for taking time to do this, and for publishing your efforts.  Again, no complaints about perf.  Even if I fail to improve it, it is a valuable tool.  And for me, it serves as a sort of Rosetta Stone for the metadata had not realized existed.  Kudos


    Regards,

    Gary

  • o103452@rtrtr.com

    Ten Centuries

    Points: 1025

    Stan Kulp-439977 - Tuesday, April 11, 2017 9:42 AM

    o103452 - Tuesday, April 11, 2017 9:35 AM

    This is a pretty helpful concept. Thanks
    Now, something like this for SSIS would be pretty neat as well. 😉

    You would have to be running the SSIS packages from the SSISDB catalog.
    I have been looking into it, but you have to deploy entire projects instead of individual SSIS packages.

    I mean, yea get metadata of each pkg that's deployed to the SSISDB (SS '12+). Tried some approaches posted by bloggers like Jamie Thompson and such but am unsuccessful thus far. 🙁

Viewing 10 posts - 16 through 25 (of 25 total)

You must be logged in to reply to this topic. Login to reply