SQL Server Reporting Services - Customize Subscription Link

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
LVL 1
jlinggAsked:
Who is Participating?
 
rob_farleyConnect With a Mentor Commented:
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
 
rob_farleyCommented:
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
 
jlinggAuthor Commented:
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
 
rob_farleyCommented:
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
 
jlinggAuthor Commented:
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
All Courses

From novice to tech pro — start learning today.