change email link in subscription

how can i change the link from http://servername/... to http://ipaddress/...
in the subscription email? Right now I don't have dns setup yet so I would
like to you ip address instead but the email sent out with the
http://servername/... link. Please adviceYou could try changing the urlroot element in RSReportServer.config.
Mike G.
"John R" <JohnR@.hotmail.com> wrote in message
news:%238SXzDLFFHA.2052@.TK2MSFTNGP09.phx.gbl...
> how can i change the link from http://servername/... to
> http://ipaddress/... in the subscription email? Right now I don't have dns
> setup yet so I would like to you ip address instead but the email sent out
> with the http://servername/... link. Please advice
>

Change Data Souce

How to change shared data source in dinamic mode by parameters?
If you have a sample, please send me a link.
Thanks.
Helder Flores
Sinatecno TIYou can not change the data source in SQL 2k... however you can use linked
servers, etc and create the query on the fly, which gives you the ability to
dynamically change from one server to the next ie in the data set
if @.reportparamtype=1
select * from dbo.table1
else
select * from mylinkedserver.pubs.dbo.table1
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
(Please respond only to the newsgroup.)
I support the Professional Association for SQL Server ( PASS) and it's
community of SQL Professionals.
"Helder Flores" <helderflores@.discussoes.microsoft.com> wrote in message
news:1F5F4C61-F3FE-4D6F-88CC-6D676EA9B8E6@.microsoft.com...
> How to change shared data source in dinamic mode by parameters?
> If you have a sample, please send me a link.
> Thanks.
> Helder Flores
> Sinatecno TI
>|||It's a good way to solve this problem. Thanks Wayne.
--
Helder Flores
CEO - Sinatecno TI
"Wayne Snyder" wrote:
> You can not change the data source in SQL 2k... however you can use linked
> servers, etc and create the query on the fly, which gives you the ability to
> dynamically change from one server to the next ie in the data set
> if @.reportparamtype=1
> select * from dbo.table1
> else
> select * from mylinkedserver.pubs.dbo.table1
>
> --
> Wayne Snyder MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> (Please respond only to the newsgroup.)
> I support the Professional Association for SQL Server ( PASS) and it's
> community of SQL Professionals.
> "Helder Flores" <helderflores@.discussoes.microsoft.com> wrote in message
> news:1F5F4C61-F3FE-4D6F-88CC-6D676EA9B8E6@.microsoft.com...
> > How to change shared data source in dinamic mode by parameters?
> > If you have a sample, please send me a link.
> >
> > Thanks.
> >
> > Helder Flores
> > Sinatecno TI
> >
>
>