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?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.