Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 690
  • Last Modified:

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
0
jlingg
Asked:
jlingg
  • 3
  • 2
1 Solution
 
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
 
rob_farleyCommented:
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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now