Can I get URL for RS from database ReportServer?

Hi,
is there any way to get URL for RS from database ReportServer?
I looked through tables in this DB but didn't find anything helpful.
Thanks.
VictorDid you mean you want to know what URL the report server is using?
Check C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer\RSReportServer.config
"Victor" wrote:
> Hi,
> is there any way to get URL for RS from database ReportServer?
> I looked through tables in this DB but didn't find anything helpful.
> Thanks.
> Victor
>|||Thanks, it has it.
But I need this to find URLs for all Reporting Services on the network. So
maybe this is not the best method.
Any other ideas?
Victor
"David Bienstock" wrote:
> Did you mean you want to know what URL the report server is using?
> Check C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportServer\RSReportServer.config
> "Victor" wrote:
> > Hi,
> >
> > is there any way to get URL for RS from database ReportServer?
> >
> > I looked through tables in this DB but didn't find anything helpful.
> >
> > Thanks.
> > Victor
> >|||Download SQLH2 and its ReportingServices reports... neat stuff like
performance counters, uptime, and all in RS!
"Victor" wrote:
> Thanks, it has it.
> But I need this to find URLs for all Reporting Services on the network. So
> maybe this is not the best method.
> Any other ideas?
> Victor
> "David Bienstock" wrote:
> > Did you mean you want to know what URL the report server is using?
> >
> > Check C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> > Services\ReportServer\RSReportServer.config
> >
> > "Victor" wrote:
> >
> > > Hi,
> > >
> > > is there any way to get URL for RS from database ReportServer?
> > >
> > > I looked through tables in this DB but didn't find anything helpful.
> > >
> > > Thanks.
> > > Victor
> > >|||Thanks again. And again it won't work for me.
I need to do this during run time. I want to populate combo box on my form
with RS URLs even if there is only one RS on the network.
Victor
"David Bienstock" wrote:
> Download SQLH2 and its ReportingServices reports... neat stuff like
> performance counters, uptime, and all in RS!
> "Victor" wrote:
> > Thanks, it has it.
> >
> > But I need this to find URLs for all Reporting Services on the network. So
> > maybe this is not the best method.
> >
> > Any other ideas?
> >
> > Victor
> >
> > "David Bienstock" wrote:
> >
> > > Did you mean you want to know what URL the report server is using?
> > >
> > > Check C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> > > Services\ReportServer\RSReportServer.config
> > >
> > > "Victor" wrote:
> > >
> > > > Hi,
> > > >
> > > > is there any way to get URL for RS from database ReportServer?
> > > >
> > > > I looked through tables in this DB but didn't find anything helpful.
> > > >
> > > > Thanks.
> > > > Victor
> > > >

Can i add a back button on report view ?

Hi all:

I have a asp.net webpage , which has a button to point to a report (by using URL)

Now what i want is another way around , having a back button on report view page, so

that user can click back button to vew the web page.

Is that possible to do it in Report Service?

Thanks

Nick

Hi Nick,

While I would say using the back button in IE is the easy way, there is another way to add a button to a report. Take a look at the custom report item functionality of RS.

Informative link:

http://msdn.microsoft.com/msdnmag/issues/06/10/SQLServer2005/default.aspx