Friday, February 01, 2013 10:06 PM
Hi, I am using SQL Server 2008 R2 and SQL Server Reporting Services 2008 R2. In one of my reports I am using an URL Action for a field. This report is currently deployed on the development server (Dev URL: http://devversion.com/). When we deploy this report on production this URL will change to http://prodversion.com/. I was looking for a way that I could write an expression by getting the SQL Server server name and report use it dynamically rather than change it manually.
Thanks in advance.............
Saturday, February 02, 2013 2:37 AM
On you SQL Servers, create a dummy database with no tables, then define the following view :
CREATE VIEW vServerName AS SELECT @@ServerName AS ServerName
On your report, create a dataset that connects to that view. It will return a single record
with your server/instance name.
Sebastian Sajaroff Senior DBA Pharmacies Jean Coutu