Interactive reports

Is there a way to insert reports with interavtive features in my custom web
application?
I cannot use url access provided with the SQL Reporting Services.
I need to render an OLAP Report with drill down features.I am curious about this as well -> we are integrating a portfolio of reports
into our web app, several of them are dynamic (expand / hide) report
sections.
We have a report parameter page (assembled with SOAP calls) and a seperate
page which reads parameters from url and makes the SOAP call. We are trying
to avoid direct access to the ReportServer so that users do not have "direct"
access to the Web Service.
However, when a direct report is called, the external users are prompted to
login in order to see the + / - images. When they fail, the links are broken
and they cannot toggle open the report sections because the images link
directly to the ReportSever via Url Access.
Can I inject a custom url into the + / - links so that I can redirect the
user to my web app page to call for the opened report? Is there an easier
way to do this?
"massimo" wrote:
> Is there a way to insert reports with interavtive features in my custom web
> application?
> I cannot use url access provided with the SQL Reporting Services.
> I need to render an OLAP Report with drill down features.
>
>|||If you are talking about embedding a report into your asp.net page, then yes
you can. You will find a sample application at: C:\Program Files\Microsoft
SQL Server\MSSQL\Reporting Services\Samples\Applications\ReportViewer
This solution, when compiled will produce the DLL file in Bin directory. You
need to add a reference to this in your project and add the component
(ReportViewer) to the tool box in VS.
Regards,
KS
"massimo" wrote:
> Is there a way to insert reports with interavtive features in my custom web
> application?
> I cannot use url access provided with the SQL Reporting Services.
> I need to render an OLAP Report with drill down features.
>
>|||Yes, I have accomplished this, but we want our reports to have toggle items
while avoiding URLAccess altogether. Is this possible?
"saleek" wrote:
> If you are talking about embedding a report into your asp.net page, then yes
> you can. You will find a sample application at: C:\Program Files\Microsoft
> SQL Server\MSSQL\Reporting Services\Samples\Applications\ReportViewer
> This solution, when compiled will produce the DLL file in Bin directory. You
> need to add a reference to this in your project and add the component
> (ReportViewer) to the tool box in VS.
> Regards,
> KS
> "massimo" wrote:
> > Is there a way to insert reports with interavtive features in my custom web
> > application?
> >
> > I cannot use url access provided with the SQL Reporting Services.
> > I need to render an OLAP Report with drill down features.
> >
> >
> >|||Hi,
I think it is possible. You can see a live demo of MS Reporting
Services on Internet from www.gmsbv.nl / www.reportportal.com and test
the MS Reporting Services reports with paramters by your self. You
even can transfer to OLAP reports and slice and dice.
Regards, Marco
www.gmsbv.nl
"briberry" <briberry@.discussions.microsoft.com> wrote in message news:<029E1873-67A1-4EE8-B433-B4D7F3F27C74@.microsoft.com>...
> Yes, I have accomplished this, but we want our reports to have toggle items
> while avoiding URLAccess altogether. Is this possible?
> "saleek" wrote:
> > If you are talking about embedding a report into your asp.net page, then yes
> > you can. You will find a sample application at: C:\Program Files\Microsoft
> > SQL Server\MSSQL\Reporting Services\Samples\Applications\ReportViewer
> >
> > This solution, when compiled will produce the DLL file in Bin directory. You
> > need to add a reference to this in your project and add the component
> > (ReportViewer) to the tool box in VS.
> >
> > Regards,
> >
> > KS
> >
> > "massimo" wrote:
> >
> > > Is there a way to insert reports with interavtive features in my custom web
> > > application?
> > >
> > > I cannot use url access provided with the SQL Reporting Services.
> > > I need to render an OLAP Report with drill down features.
> > >
> > >
> > >