{"id":21,"date":"2018-07-18T11:52:00","date_gmt":"2018-07-18T11:52:00","guid":{"rendered":"\/lisa\/post\/2018\/07\/18\/yaps-about-ssrs-branding.aspx"},"modified":"2018-07-18T11:52:00","modified_gmt":"2018-07-18T11:52:00","slug":"yaps-about-ssrs-branding","status":"publish","type":"post","link":"https:\/\/spacefold.com\/lisa\/2018\/07\/18\/yaps-about-ssrs-branding\/","title":{"rendered":"YAPS about SSRS Branding"},"content":{"rendered":"

Last time<\/a> I posted (and I can’t believe it was several months ago), I indicated that I was done with writing about branding because it’s so much easier in 2016 – and it is.<\/p>\n

Except…<\/h3>\n

In the past couple of weeks I’ve had to downgrade a couple of servers from Enterprise to Standard Edition, including a server hosting SSRS 2016.  I used these instructions<\/a>, btw, which really work, although I’ve scripted and saved out every piece of server information\/config I could think of, each server, just in case.<\/p>\n

Until doing so, I hadn’t realized that the Standard Edition doesn’t have the nice branding capability found in Enterprise.  It’s actually documented<\/a> that the feature isn’t supported in Standard, I just hadn’t noticed.  But I did, when I downgraded this instance.  See?<\/p>\n

\"\"<\/p>\n

Except…<\/h3>\n

The astute among you may notice that, although the tab is missing, and although I didn’t do anything to make this happen, the custom branding still appears to be in place, in the second screen shot. <\/p>\n

… Hmmm.<\/h3>\n

Gives you something to think about.  Although downgrading requires you to be very fastidious about keeping to the same folders for your replacement\/downgraded installation, I doubt that this has anything to do with customized files left on disk by the Enterprise uninstall.<\/p>\n

It’s far more likely to be due to my use of the same ReportServer database after the downgrade.  Take a look at the contents of the Catalog table, and you’ll see that my uploaded zipfile from the Enterprise installation remains in the table:<\/p>\n

\"\"<\/p>\n

… as do the contents of the zip file, as additional rows.  The ParentID for DUoC.zip is still UniversalBrand.  And the UniversalBrand rows’ Property XML points to the DUoC.zip record, I guess, as the in-use branding:<\/p>\n

\"\"<\/p>\n

… so it looks to me that, if you put the proper contents into a ReportServer db, even without downgrading, you can have custom branding according to the new\/zipfile packaging system in SSRS 2016.<\/p>\n

What else is possible?<\/h3>\n

I wonder if I could brand a Developer instance and then use that ReportServer catalog for a branded Standard instance?<\/p>\n

Hmm.. maybe this is one of the reasons that upgrading a Developer instance is no longer supported to anything but an Enterprise edition.  As recently as 2014, this was not the case.  Here, look for yourself<\/a> at the difference.<\/p>\n

I hope somebody writes and tells me, if you’ve played with this.<\/p>\n","protected":false},"excerpt":{"rendered":"

Last time I posted (and I can’t believe it was several months ago), I indicated that I was done with writing about branding because it’s so much easier in 2016 – and it is. Except… In the past couple of weeks I’ve had to downgrade a couple of servers from Enterprise to Standard Edition, includingRead 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,12],"tags":[],"class_list":["post-21","post","type-post","status-publish","format-standard","hentry","category-reporting","category-sql-server","category-yaps"],"_links":{"self":[{"href":"https:\/\/spacefold.com\/lisa\/wp-json\/wp\/v2\/posts\/21","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=21"}],"version-history":[{"count":0,"href":"https:\/\/spacefold.com\/lisa\/wp-json\/wp\/v2\/posts\/21\/revisions"}],"wp:attachment":[{"href":"https:\/\/spacefold.com\/lisa\/wp-json\/wp\/v2\/media?parent=21"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/spacefold.com\/lisa\/wp-json\/wp\/v2\/categories?post=21"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/spacefold.com\/lisa\/wp-json\/wp\/v2\/tags?post=21"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}