Solved

How to version SQL Reports.

Posted on 2013-06-25
4
309 Views
Last Modified: 2016-02-11
I currently have a report project of around 60 reports. These reports are used by 2 different client companies, though they are deployed at different times and they are organised differently on each of the report servers. My issue is usually trying to determine what version of the report is on either server.

The date stamps can be helpful, but often I find if there has been a large gap in deployment between companies, the underlying backend data may not be compatible with new uploaded reports.

We keep the source files in SVN, which are obviously versioned for its purposes...but I would like to be able to version individual rdl files, so when I view them on the report server, I can look at some type of metadata that gives me a version number. I DO NOT wish to put versioning in the report name or in the description field.

Has anyone got some good ideas how I can do this.
0
Comment
Question by:Milkus1
  • 2
4 Comments
 
LVL 37

Expert Comment

by:ValentinoV
ID: 39277052
That is indeed something that's missing in the RDL implementation.  In SSIS packages there's a property called VersionBuild which gets increased with every save.  That's very useful for purposes such as yours.  Unfortunately SSRS does not have that.

So, as it's not build in the only option that I see is to implement it yourself somehow.  It could be as easy as adding a small textbox in a footer with a hardcoded version number.  Of course that means that you need to change that number manually each time you change the report.  Annoying, but it should work.

Perhaps it's an option to use the SVN version number?  Although I guess that would mean you need to know the next version before you check it in, hmm, might be chicken/egg issue...
0
 
LVL 6

Accepted Solution

by:
Dulton earned 250 total points
ID: 39282355
I have used this solution myself and it works beautifully.... in fact I took it a little further and setup my report of these 'versions' to include a link where I could download any one of the historical versions of the report.


http://www.sqlservercentral.com/articles/Reporting+Services+(SSRS)/94119/
0
 

Author Closing Comment

by:Milkus1
ID: 39283127
Not sure if I can get my DBAs to agree to it, but looks like a start. All will need is to add an incremental version number and it should be well on the way.
0
 
LVL 37

Expert Comment

by:ValentinoV
ID: 39283546
Interesting trigger usage in that article!
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SSIS Conditional Split 7 38
Learning SQL Reporting Services 2014 1 37
database level memory cache..? 8 31
Substring works but need to tweak it 12 10
Lessons learned during ten years of interviewing for SQL Server Integration Services (SSIS) and other Extract-Transform-Load (ETL) contract roles and two years of staff manager interviewing contractors.
My client sends data in an Excel file to me to load them into Staging database. The file contains many sheets that they have same structure. In this article, I would like to share the simple way to load data of multiple sheets by using SSIS.
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question