Is there other control like ReportViewer control to avoid security problems

Hello Friends
i am using ReportViewer Control to view the SQL REPORT in the aspx page
its working fine and i am able to view the reports..
Now The problem is that
ReportViewer needs direct access to the Database Server
(i mean to say, we need to give the serverURL(database) to the
reportviewer )
but at my client place the web application is installed on one
server(which is configured to public IP) and the database is on other
server(which is not publicIP)
So when i try to view the report from my web application i am getting
error "page not Found"
can any one please tell me the way to view the reports in my web page
with other than reportviewer.. which gives the same functionality and
which can overcome these sort of security issues
thanx
anil...Not sure if it's a bad practice but before I knew about the ReportViewer I
used an <iframe> and displayed it in that...
It worked fine and should help you with your problem.
Regards
--
http://dotnet.org.za/stanley
"anil" wrote:
> Hello Friends
> i am using ReportViewer Control to view the SQL REPORT in the aspx page
> its working fine and i am able to view the reports..
> Now The problem is that
> ReportViewer needs direct access to the Database Server
> (i mean to say, we need to give the serverURL(database) to the
> reportviewer )
> but at my client place the web application is installed on one
> server(which is configured to public IP) and the database is on other
> server(which is not publicIP)
> So when i try to view the report from my web application i am getting
> error "page not Found"
> can any one please tell me the way to view the reports in my web page
> with other than reportviewer.. which gives the same functionality and
> which can overcome these sort of security issues
> thanx
> anil...
>|||Hello Stan, thanx for the info
i would like to know some more info reg.
by using <iframe> how can i redirect the request to the database
server...
do u have any idea.. or examples pls let me know ..
thanx & regards
Stan wrote:
> Not sure if it's a bad practice but before I knew about the ReportViewer I
> used an <iframe> and displayed it in that...
> It worked fine and should help you with your problem.
> Regards
> --
> http://dotnet.org.za/stanley
>
> "anil" wrote:
> > Hello Friends
> >
> > i am using ReportViewer Control to view the SQL REPORT in the aspx page
> > its working fine and i am able to view the reports..
> >
> > Now The problem is that
> >
> > ReportViewer needs direct access to the Database Server
> > (i mean to say, we need to give the serverURL(database) to the
> > reportviewer )
> > but at my client place the web application is installed on one
> > server(which is configured to public IP) and the database is on other
> > server(which is not publicIP)
> > So when i try to view the report from my web application i am getting
> > error "page not Found"
> >
> > can any one please tell me the way to view the reports in my web page
> > with other than reportviewer.. which gives the same functionality and
> > which can overcome these sort of security issues
> >
> > thanx
> > anil...
> >
> >|||IFrame will have the same problem. You need to use webservices in your web
app. Or, using VS 2005 web control (which itself uses web services) supports
this configuration.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"anil" <kumar.vanaparthy@.gmail.com> wrote in message
news:1130364685.976063.324410@.g43g2000cwa.googlegroups.com...
> Hello Stan, thanx for the info
> i would like to know some more info reg.
> by using <iframe> how can i redirect the request to the database
> server...
> do u have any idea.. or examples pls let me know ..
> thanx & regards
>
> Stan wrote:
>> Not sure if it's a bad practice but before I knew about the ReportViewer
>> I
>> used an <iframe> and displayed it in that...
>> It worked fine and should help you with your problem.
>> Regards
>> --
>> http://dotnet.org.za/stanley
>>
>> "anil" wrote:
>> > Hello Friends
>> >
>> > i am using ReportViewer Control to view the SQL REPORT in the aspx page
>> > its working fine and i am able to view the reports..
>> >
>> > Now The problem is that
>> >
>> > ReportViewer needs direct access to the Database Server
>> > (i mean to say, we need to give the serverURL(database) to the
>> > reportviewer )
>> > but at my client place the web application is installed on one
>> > server(which is configured to public IP) and the database is on other
>> > server(which is not publicIP)
>> > So when i try to view the report from my web application i am getting
>> > error "page not Found"
>> >
>> > can any one please tell me the way to view the reports in my web page
>> > with other than reportviewer.. which gives the same functionality and
>> > which can overcome these sort of security issues
>> >
>> > thanx
>> > anil...
>> >
>> >
>