Solved

SQL Server Reporting Services - Customize Subscription Link

Posted on 2009-06-30
5
686 Views
Last Modified: 2012-05-07
I have several SSRS reports that I have subscriptions setup for. There is an option to include a link to the report along with the subscription email.  This link works when you are on a machine in the same domain as the report but does not when you are outside of that domain because it does not include the domain.com in the link.  Is it possible to modify this link?  If so, where and how do you do it?

Original Link.
http://db1-sea/ReportServer_DYNAMICSDEV?%2fSalesReport1%2fa+MTD+Sales+By+Category&rs%3aParameterLanguage=en-US

Desired Link.
http://db1-sea.domain.com/ReportServer_DYNAMICSDEV?%2fSalesReport1%2fa+MTD+Sales+By+Category&rs%3aParameterLanguage=en-US
0
Comment
Question by:jlingg
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 15

Expert Comment

by:rob_farley
ID: 24922326
You should check your virtual directory details in Reporting Services Configuration Manager. The ReportServer_DYNAMICSDEV virtual directory will be listening on a website (like IIS, but not), and Windows will identify how people connect to that. You should be able to configure that website to describe itself with .domain.com included.

I don't have a copy of SSRS2008 with me today, so if you have trouble doing this, let me know and I'll check on another machine of mine.

Rob
0
 
LVL 1

Author Comment

by:jlingg
ID: 24927868
Thanks Rob,
I am having trouble finding this, so if you can check on your other machine that would be very helpful.

thanks
Jason
0
 
LVL 15

Expert Comment

by:rob_farley
ID: 24941611
Ok... run Reporting Services Configuraito Manager (2008, right?)

Then pick Web Service URL on the left.

Then hit Advanced on the right.

Hit Edit, and provide a Host Header.

Of course, this should be a host header through which external users will get directed to your SSRS server.

Rob
0
 
LVL 1

Author Comment

by:jlingg
ID: 24952031
I may be doing something wrong but here is what I did.

1. set the host header to db1-sea.coreoncology.com - It said "the URL was successfully updated" or something.  And the URL shows the entire FQDN now.

2. Reset the www publishing service and the SSRS service.  

3. You can access the URL with either FQDN or the server name only (inside the domain)

3. It still sends out the link without the FQDN.
0
 
LVL 15

Accepted Solution

by:
rob_farley earned 500 total points
ID: 24957489
Hmm... I thought that would've got the link going out correctly.

My next step would be to use profiler to see how it's querying Reporting Services to get that information. Presumably it's in the database somewhere, and if we can see where, then we may have some control over it.

I'll see if I can have a look some time, although I'm somewhat busy today.

Rob
0

Featured Post

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Audit has been really one of the more interesting, most useful, yet difficult to maintain topics in the history of SQL Server. In earlier versions of SQL people had very few options for auditing in SQL Server. It typically meant using SQL Trace …
After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

627 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question