Solved

SQL Server Reporting Services - Customize Subscription Link

Posted on 2009-06-30
5
682 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
  • 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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

Suggested Solutions

This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou…
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

777 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