Wednesday, March 21, 2012

Reporting services on the web

Is it possible to put reporting services report (rdl) on web server that
does not have sqlserver (SqlServer is on the other machine)?
I am using reportviewer control, and this is working as iframe with http
address where is reporting service's web service installed but my customers
have not access to this machine.Yes you can. At the time of installation (Report server), for SQL instance
give the remote server instance (the name of the database server you want to
use).
"TomislaW" <tomislav147@.hotmail.com> wrote in message
news:ee4q5UJcEHA.384@.TK2MSFTNGP10.phx.gbl...
> Is it possible to put reporting services report (rdl) on web server that
> does not have sqlserver (SqlServer is on the other machine)?
> I am using reportviewer control, and this is working as iframe with http
> address where is reporting service's web service installed but my
customers
> have not access to this machine.
>
>|||Suhaib,
I don't think you answered the right question.
The answer is No. You cannot view the report with just the rdl. You
have to run the report through Reporting services. You can install
Reporting Services and point to another SQL database, but you cannot
run a report from the rdl alone using the reportviewer sample
application.
Hope that helps,
Eugene Kolovyansky
"Suhaib Khan" <skhan@.faicorp.com> wrote in message news:<OK8qBiLcEHA.4064@.TK2MSFTNGP09.phx.gbl>...
> Yes you can. At the time of installation (Report server), for SQL instance
> give the remote server instance (the name of the database server you want to
> use).
>
> "TomislaW" <tomislav147@.hotmail.com> wrote in message
> news:ee4q5UJcEHA.384@.TK2MSFTNGP10.phx.gbl...
> > Is it possible to put reporting services report (rdl) on web server that
> > does not have sqlserver (SqlServer is on the other machine)?
> >
> > I am using reportviewer control, and this is working as iframe with http
> > address where is reporting service's web service installed but my
> customers
> > have not access to this machine.
> >
> >
> >
> >|||No, with version 1.0. Yes, with the next version (SQL Server 2005). It will
incude a WinForm and ASP.NET control that will support stand-alone report
generation mode and will not require the Report Server.
--
Hope this helps.
---
Teo Lachev, MCSD, MCT
Author: "Microsoft Reporting Services in Action"
http://www.prologika.com
"Euge" <yevger@.yahoo.com> wrote in message
news:3f8e8a3d.0408121459.5298763d@.posting.google.com...
> Suhaib,
> I don't think you answered the right question.
> The answer is No. You cannot view the report with just the rdl. You
> have to run the report through Reporting services. You can install
> Reporting Services and point to another SQL database, but you cannot
> run a report from the rdl alone using the reportviewer sample
> application.
> Hope that helps,
> Eugene Kolovyansky
> "Suhaib Khan" <skhan@.faicorp.com> wrote in message
news:<OK8qBiLcEHA.4064@.TK2MSFTNGP09.phx.gbl>...
> > Yes you can. At the time of installation (Report server), for SQL
instance
> > give the remote server instance (the name of the database server you
want to
> > use).
> >
> >
> >
> > "TomislaW" <tomislav147@.hotmail.com> wrote in message
> > news:ee4q5UJcEHA.384@.TK2MSFTNGP10.phx.gbl...
> > > Is it possible to put reporting services report (rdl) on web server
that
> > > does not have sqlserver (SqlServer is on the other machine)?
> > >
> > > I am using reportviewer control, and this is working as iframe with
http
> > > address where is reporting service's web service installed but my
> > customers
> > > have not access to this machine.
> > >
> > >
> > >
> > >

No comments:

Post a Comment