Click here to monitor SSC
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-Enthusiastic
SSC-Enthusiastic (120 reputation)SSC-Enthusiastic (120 reputation)SSC-Enthusiastic (120 reputation)SSC-Enthusiastic (120 reputation)SSC-Enthusiastic (120 reputation)SSC-Enthusiastic (120 reputation)SSC-Enthusiastic (120 reputation)SSC-Enthusiastic (120 reputation)

Group: General Forum Members
Points: 120 Visits: 412
Comments posted to this topic are about the item A Versioning system for SSRS
Steph Locke
Steph Locke
SSC Veteran
SSC Veteran (229 reputation)SSC Veteran (229 reputation)SSC Veteran (229 reputation)SSC Veteran (229 reputation)SSC Veteran (229 reputation)SSC Veteran (229 reputation)SSC Veteran (229 reputation)SSC Veteran (229 reputation)

Group: General Forum Members
Points: 229 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 (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 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
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: 659
This is amazing, thanks!
Joffrey V
Joffrey V
Grasshopper
Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)

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

===============================
= Ignorance is the choice not to know =
===============================
sherifffruitfly
sherifffruitfly
SSC Journeyman
SSC Journeyman (76 reputation)SSC Journeyman (76 reputation)SSC Journeyman (76 reputation)SSC Journeyman (76 reputation)SSC Journeyman (76 reputation)SSC Journeyman (76 reputation)SSC Journeyman (76 reputation)SSC Journeyman (76 reputation)

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

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



Everything is awesome!
rud
rud
Forum Newbie
Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)

Group: General Forum Members
Points: 4 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 (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 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
SSC Journeyman
SSC Journeyman (89 reputation)SSC Journeyman (89 reputation)SSC Journeyman (89 reputation)SSC Journeyman (89 reputation)SSC Journeyman (89 reputation)SSC Journeyman (89 reputation)SSC Journeyman (89 reputation)SSC Journeyman (89 reputation)

Group: General Forum Members
Points: 89 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