SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


A Versioning system for SSRS


A Versioning system for SSRS

Author
Message
DavidKBennett
DavidKBennett
SSC-Addicted
SSC-Addicted (433 reputation)SSC-Addicted (433 reputation)SSC-Addicted (433 reputation)SSC-Addicted (433 reputation)SSC-Addicted (433 reputation)SSC-Addicted (433 reputation)SSC-Addicted (433 reputation)SSC-Addicted (433 reputation)

Group: General Forum Members
Points: 433 Visits: 419
Comments posted to this topic are about the item A Versioning system for SSRS
Steph Locke
Steph Locke
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1065 Visits: 870
Downloaded the pack and I'm going to give it a whirl this evening - if it works, it'll be fabulous :-) Great stuff!
shahzadalam
shahzadalam
Forum Newbie
Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)

Group: General Forum Members
Points: 7 Visits: 18
It seems very good solution according to the requirements you mentioned and there can be one more enhancements that is to replace trigger with Change Tracking, that will reduce the impact of trigger as well. But I would recommend this if there are lot of users and lot of reports are being frequently modified or created.
Alex Friedman
Alex Friedman
Old Hand
Old Hand (321 reputation)Old Hand (321 reputation)Old Hand (321 reputation)Old Hand (321 reputation)Old Hand (321 reputation)Old Hand (321 reputation)Old Hand (321 reputation)Old Hand (321 reputation)

Group: General Forum Members
Points: 321 Visits: 673
This is amazing, thanks!
Joffrey V
Joffrey V
Valued Member
Valued Member (52 reputation)Valued Member (52 reputation)Valued Member (52 reputation)Valued Member (52 reputation)Valued Member (52 reputation)Valued Member (52 reputation)Valued Member (52 reputation)Valued Member (52 reputation)

Group: General Forum Members
Points: 52 Visits: 211
Looks very interesting this, definitely going to have look at this. Well done!

===============================
= Ignorance is the choice not to know =
===============================
sherifffruitfly
sherifffruitfly
SSChasing Mays
SSChasing Mays (610 reputation)SSChasing Mays (610 reputation)SSChasing Mays (610 reputation)SSChasing Mays (610 reputation)SSChasing Mays (610 reputation)SSChasing Mays (610 reputation)SSChasing Mays (610 reputation)SSChasing Mays (610 reputation)

Group: General Forum Members
Points: 610 Visits: 427
Cool - I hadn't considered source control for report builder content.
Dana Medley
Dana Medley
SSCarpal Tunnel
SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)

Group: General Forum Members
Points: 4076 Visits: 1707
Nicely done. I'm going to try it out as soon as I get a chance.



Everything is awesome!
rud
rud
SSC-Enthusiastic
SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)

Group: General Forum Members
Points: 116 Visits: 44
i've had a few issues where the xml conversion throws error "Illegal XML character. Had to adjust the query to this:
INSERT INTO ReportServer.dbo.VersionStore
( ItemId ,
Name ,
ModifiedDate ,
ModifiedBy ,
InsertedDate ,
Def

)
SELECT ItemID ,
Name ,
ModifiedDate ,
u.UserName ,
GETDATE() InsertedDate ,
CONVERT(XML, ContentFinal) AS ContentXML
FROM dbo.Catalog c
INNER JOIN Users U ON u.UserID = c.ModifiedByID
OUTER APPLY ( SELECT CONVERT(VARBINARY(MAX), [Content]) AS CONTENTVar
) t1
OUTER APPLY ( SELECT CASE WHEN LEFT(ContentVar, 3) = 0xEFBBBF
THEN CONVERT(VARBINARY(MAX), SUBSTRING(ContentVar,
4,
LEN(ContentVar)))
ELSE ContentVar
END AS Content2
) t2
OUTER APPLY ( SELECT CASE WHEN RIGHT(Content2, 1) = 0x00
THEN CONVERT(VARBINARY(MAX), LEFT(Content2,
LEN(Content2)
- 1))
ELSE Content2
END AS ContentFinal
) t3
WHERE Content IS NOT NULL
AND Type != 3
AND ItemID IN (
SELECT c.ItemID
FROM Catalog C
LEFT OUTER JOIN ( SELECT v1.ItemID ,
MAX(v1.modifiedDate) modifiedDate
FROM VersionStore V1
GROUP BY ItemID
) V ON C.ItemID = v.ItemID
WHERE Content IS NOT NULL
AND ( v.itemID IS NULL
OR v.modifiedDate != c.ModifiedDate
) )
draggs
draggs
Forum Newbie
Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)

Group: General Forum Members
Points: 7 Visits: 30
Great work; this is a great real-time tracking system. I did something similar but to avoid touching the SSRS system I created a type two reporting dimension. Not real-time, but only a one day lag.
Clifton Collins
Clifton Collins
Say Hey Kid
Say Hey Kid (667 reputation)Say Hey Kid (667 reputation)Say Hey Kid (667 reputation)Say Hey Kid (667 reputation)Say Hey Kid (667 reputation)Say Hey Kid (667 reputation)Say Hey Kid (667 reputation)Say Hey Kid (667 reputation)

Group: General Forum Members
Points: 667 Visits: 194
Using Visual Studio with VSS, TFS or Visual SVN to design your reports provides a method of versioning individual reports or an entire project/solution of reports. Couple this with rsbuild for package and deployment and it is simple to deploy a new or previous version of a report or entire project/solution of reports.

If you are on a budget, check out VS Express 2010 or 2012 with TFS express.
[/url]

and rsbuild.
[url=http://rsbuild.codeplex.com/]


Clifton G. Collins III
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum







































































































































































SQLServerCentral


Search