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
>

Drilldowns

I have a list of items. Some of the items would be a good candidate for the
drilldowns because the item name is the same. How can I only enable the
items with the same item name to be group together with a drilldown?I am not sure I truly understand your question, but I'll give this a stab
Create a grouping within your table. and Group on the name. Add the Name
field to the group header row. Select the Detail row and set the visibility
hidden to true, and choose the textbox with the group value (from the group
header) as the toggle item.
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"David" wrote:
> I have a list of items. Some of the items would be a good candidate for the
> drilldowns because the item name is the same. How can I only enable the
> items with the same item name to be group together with a drilldown?|||I created a sample RDL which does what you want, and posted it on
www.msbicentral.com, it is in the downloads section
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"David" wrote:
> I have a list of items. Some of the items would be a good candidate for the
> drilldowns because the item name is the same. How can I only enable the
> items with the same item name to be group together with a drilldown?