Friday, February 17, 2012

Drilldowns with SOAP rendering or SSRS 2005?

We are running SSRS with SQL Server 2000 and are working on developing an
ASP.NET application that would use SOAP web access to render the reports.
However, I was wondering how this works with linked or drill down reports,
which we are thinking will be an important part of our design.
Has anyone done this successfully? How does it work? Normally, the
reportingservice.render method is called, but I read about an issue that
occurs when a drill down report is encountered. Apparently the user is
redirected to the Report Manager, as there is no way to tell the Report
Server that the drill down destination should be mapped to the calling
application. I also read that there may be something better for this in SQL
Server 2005, but I wonder when we should expect that?
Can anyone shed some light on this issue?
Thanks,
nickpupwell i ve been using SSRS 200 with SQL Server 2000 n ASP.Net for my
reports n i had the same problem of handling linked n toggle reports
as far as linked reports r concerned those were settled by changing the
path of the linked report to my application's webpage that shows the
specified linked report with parameters in URL through JUMP TO URL
PROPERTY however i couldnt resolve the toggled report problem i tried
but couldnt succeed if u get the idea plz let me know as well|||I will - thanks.
"** Spirits **" wrote:
> well i ve been using SSRS 200 with SQL Server 2000 n ASP.Net for my
> reports n i had the same problem of handling linked n toggle reports
> as far as linked reports r concerned those were settled by changing the
> path of the linked report to my application's webpage that shows the
> specified linked report with parameters in URL through JUMP TO URL
> PROPERTY however i couldnt resolve the toggled report problem i tried
> but couldnt succeed if u get the idea plz let me know as well
>

No comments:

Post a Comment