I have a company logo that should appear in all the reports I create. I uploaded it to an Images folder on my SSRS server using Report Manager and then have modified my first report to refer to it using the External option then typing in the URL
This all works fine and the graphic displays in layout and preview mode in the BI editor and also when I deploy the report on that server.
My problem is, I would prefer that I use a variable instead of the server name DC2VTSTSV032. I have an environment variable that holds the server name on each server so I tried using ="http://"+%INGISSQLServer%+"/..." but it didn't like the reference to
the environment so I tried using +Mid(GLOBAL!ReportServerURL,8,12)+. That didn't work. I then tried specifying the original url enclosed in quotes after an equals and that didn't work either! I'm guessing that there may be an issue with the way some of the
special characters in my URL are treated when I use a literal string in quotes.
The issue is that I'd like to be able to deploy the reports to both this dev server and the production one without making any changes. For the moment, the dev environment should show the new company logo and production should show the old logo so I don't
View Complete Post