How to drilldown in SOAP-rendered reports

Hi,
we tried the SQLRS-ReportViewer from the
We changed the necessary things to get it to work with the new 2005 web
services. But now we wonder how we can handle drilldowns. In the 2000
versions of the web services there was an url-parameter showhidetoggle which
seemed to be the candidate. But we didn't get it to work. But now even this
parameter seems to have disappeared, and we are not able to find helping
documentaion.
Regards,
RalphThere is a ToggleItem API in the new ReportExecution web service. The
problem with it though is that it takes the id of the item to be expanded
but these IDs are known only when the report is rendered. It's like catch
22... You need the id to call ToggleItem but you cannot easily get it. If
you do some tracing of the incoming SOAP traffic, you will see what I mean.
So, to get this working, you need to parse the report HTML output to find
the image id which may look as follows
<IMG ID="7" BORDER="0"....
Then, when the user clicks you need to invoke ToggleItem passing the image
identifier. If this sounds like a brain surgery, use the VS.NET 2005 report
viewers and be done with it. They handle interactivity for you.
--
HTH,
---
Teo Lachev, MVP, MCSD, MCT
"Microsoft Reporting Services in Action"
"Applied Microsoft Analysis Services 2005"
Home page and blog: http://www.prologika.com/
---
"Ralph Watermann" <Ralph.Watermann@.webtelligence.net> wrote in message
news:%23W0uysb6FHA.268@.TK2MSFTNGP10.phx.gbl...
> Hi,
> we tried the SQLRS-ReportViewer from the
> We changed the necessary things to get it to work with the new 2005 web
> services. But now we wonder how we can handle drilldowns. In the 2000
> versions of the web services there was an url-parameter showhidetoggle
> which seemed to be the candidate. But we didn't get it to work. But now
> even this parameter seems to have disappeared, and we are not able to find
> helping documentaion.
> Regards,
> Ralph
>|||Hmm, we'd really like to use the report viewer control. But we need some
control on how the parameters are presented. How many in a row, logically
grouped together in a group box,... If we now use a report viewer control on
an asp.net page, i think the drilldown links will go to the old server-url
and our parameters disappear?
On the other hand we will have to use drill-through-links not directly to
another report, but trough an url and put together the path and parameters
on our own. And this will be a very long string where a lot of mistakes can
be done...
Is this the only way to get control over parameter layout?
"Teo Lachev [MVP]" <teo.lachev@.nospam.prologika.com> schrieb im Newsbeitrag
news:eaJw4ge6FHA.2888@.tk2msftngp13.phx.gbl...
> There is a ToggleItem API in the new ReportExecution web service. The
> problem with it though is that it takes the id of the item to be expanded
> but these IDs are known only when the report is rendered. It's like catch
> 22... You need the id to call ToggleItem but you cannot easily get it. If
> you do some tracing of the incoming SOAP traffic, you will see what I
> mean. So, to get this working, you need to parse the report HTML output to
> find the image id which may look as follows
> <IMG ID="7" BORDER="0"....
> Then, when the user clicks you need to invoke ToggleItem passing the image
> identifier. If this sounds like a brain surgery, use the VS.NET 2005
> report viewers and be done with it. They handle interactivity for you.
> --
> HTH,
> ---
> Teo Lachev, MVP, MCSD, MCT
> "Microsoft Reporting Services in Action"
> "Applied Microsoft Analysis Services 2005"
> Home page and blog: http://www.prologika.com/
> ---
> "Ralph Watermann" <Ralph.Watermann@.webtelligence.net> wrote in message
> news:%23W0uysb6FHA.268@.TK2MSFTNGP10.phx.gbl...
>> Hi,
>> we tried the SQLRS-ReportViewer from the
>> We changed the necessary things to get it to work with the new 2005 web
>> services. But now we wonder how we can handle drilldowns. In the 2000
>> versions of the web services there was an url-parameter showhidetoggle
>> which seemed to be the candidate. But we didn't get it to work. But now
>> even this parameter seems to have disappeared, and we are not able to
>> find helping documentaion.
>> Regards,
>> Ralph
>>
>|||So, just replace the toolbar then if you need more control over the Report
Viewer toolbar.
--
HTH,
---
Teo Lachev, MVP, MCSD, MCT
"Microsoft Reporting Services in Action"
"Applied Microsoft Analysis Services 2005"
Home page and blog: http://www.prologika.com/
---
"Ralph Watermann" <We.Want@.NoSpam.de> wrote in message
news:OcKGmPf6FHA.1276@.TK2MSFTNGP09.phx.gbl...
> Hmm, we'd really like to use the report viewer control. But we need some
> control on how the parameters are presented. How many in a row, logically
> grouped together in a group box,... If we now use a report viewer control
> on an asp.net page, i think the drilldown links will go to the old
> server-url and our parameters disappear?
> On the other hand we will have to use drill-through-links not directly to
> another report, but trough an url and put together the path and parameters
> on our own. And this will be a very long string where a lot of mistakes
> can be done...
> Is this the only way to get control over parameter layout?
> "Teo Lachev [MVP]" <teo.lachev@.nospam.prologika.com> schrieb im
> Newsbeitrag news:eaJw4ge6FHA.2888@.tk2msftngp13.phx.gbl...
>> There is a ToggleItem API in the new ReportExecution web service. The
>> problem with it though is that it takes the id of the item to be expanded
>> but these IDs are known only when the report is rendered. It's like catch
>> 22... You need the id to call ToggleItem but you cannot easily get it. If
>> you do some tracing of the incoming SOAP traffic, you will see what I
>> mean. So, to get this working, you need to parse the report HTML output
>> to find the image id which may look as follows
>> <IMG ID="7" BORDER="0"....
>> Then, when the user clicks you need to invoke ToggleItem passing the
>> image identifier. If this sounds like a brain surgery, use the VS.NET
>> 2005 report viewers and be done with it. They handle interactivity for
>> you.
>> --
>> HTH,
>> ---
>> Teo Lachev, MVP, MCSD, MCT
>> "Microsoft Reporting Services in Action"
>> "Applied Microsoft Analysis Services 2005"
>> Home page and blog: http://www.prologika.com/
>> ---
>> "Ralph Watermann" <Ralph.Watermann@.webtelligence.net> wrote in message
>> news:%23W0uysb6FHA.268@.TK2MSFTNGP10.phx.gbl...
>> Hi,
>> we tried the SQLRS-ReportViewer from the
>> We changed the necessary things to get it to work with the new 2005 web
>> services. But now we wonder how we can handle drilldowns. In the 2000
>> versions of the web services there was an url-parameter showhidetoggle
>> which seemed to be the candidate. But we didn't get it to work. But now
>> even this parameter seems to have disappeared, and we are not able to
>> find helping documentaion.
>> Regards,
>> Ralph
>>
>>
>|||Teo
Could you give me an example on how to call the ToggleItem method? Do I need
to call it together with LoadReport, SetExecutionParameters and Render? If
yes, in what order do I call it? I have experimented calling it in all kinds
of order but haven't been able to get it to work ...
BTW, I think I have found a better way to find the ID of the item that is to
be toggled - you can get it from the query string, like:
Request.QueryString["rs:ShowHideToggle"].
Any help would be much appreciated
mike
"Teo Lachev [MVP]" wrote:
> So, just replace the toolbar then if you need more control over the Report
> Viewer toolbar.
> --
> HTH,
> ---
> Teo Lachev, MVP, MCSD, MCT
> "Microsoft Reporting Services in Action"
> "Applied Microsoft Analysis Services 2005"
> Home page and blog: http://www.prologika.com/
> ---
> "Ralph Watermann" <We.Want@.NoSpam.de> wrote in message
> news:OcKGmPf6FHA.1276@.TK2MSFTNGP09.phx.gbl...
> > Hmm, we'd really like to use the report viewer control. But we need some
> > control on how the parameters are presented. How many in a row, logically
> > grouped together in a group box,... If we now use a report viewer control
> > on an asp.net page, i think the drilldown links will go to the old
> > server-url and our parameters disappear?
> >
> > On the other hand we will have to use drill-through-links not directly to
> > another report, but trough an url and put together the path and parameters
> > on our own. And this will be a very long string where a lot of mistakes
> > can be done...
> >
> > Is this the only way to get control over parameter layout?
> >
> > "Teo Lachev [MVP]" <teo.lachev@.nospam.prologika.com> schrieb im
> > Newsbeitrag news:eaJw4ge6FHA.2888@.tk2msftngp13.phx.gbl...
> >> There is a ToggleItem API in the new ReportExecution web service. The
> >> problem with it though is that it takes the id of the item to be expanded
> >> but these IDs are known only when the report is rendered. It's like catch
> >> 22... You need the id to call ToggleItem but you cannot easily get it. If
> >> you do some tracing of the incoming SOAP traffic, you will see what I
> >> mean. So, to get this working, you need to parse the report HTML output
> >> to find the image id which may look as follows
> >> <IMG ID="7" BORDER="0"....
> >>
> >> Then, when the user clicks you need to invoke ToggleItem passing the
> >> image identifier. If this sounds like a brain surgery, use the VS.NET
> >> 2005 report viewers and be done with it. They handle interactivity for
> >> you.
> >>
> >> --
> >> HTH,
> >> ---
> >> Teo Lachev, MVP, MCSD, MCT
> >> "Microsoft Reporting Services in Action"
> >> "Applied Microsoft Analysis Services 2005"
> >> Home page and blog: http://www.prologika.com/
> >> ---
> >> "Ralph Watermann" <Ralph.Watermann@.webtelligence.net> wrote in message
> >> news:%23W0uysb6FHA.268@.TK2MSFTNGP10.phx.gbl...
> >> Hi,
> >>
> >> we tried the SQLRS-ReportViewer from the
> >>
> >> We changed the necessary things to get it to work with the new 2005 web
> >> services. But now we wonder how we can handle drilldowns. In the 2000
> >> versions of the web services there was an url-parameter showhidetoggle
> >> which seemed to be the candidate. But we didn't get it to work. But now
> >> even this parameter seems to have disappeared, and we are not able to
> >> find helping documentaion.
> >>
> >> Regards,
> >> Ralph
> >>
> >>
> >>
> >>
> >
> >
>
>|||Mike,
From what I have found, you need to actually call the Render method twice.
I have not been able to get reproducible results using a single call to the
render method. Here is some code that works for me:
byte[] result = null;
string reportPath = "/Accounting/Monthly Revenue Projection
DrillDown";
string format = "IMAGE";
string historyID = null;
string devInfo =@."<DeviceInfo><OutputFormat>EMF</OutputFormat><StartPage>0</StartPage></DeviceInfo>";
ParameterValue[] parameters = new ParameterValue[1];
parameters[0] = new ParameterValue();
parameters[0].Name = "BillCycle";
parameters[0].Value = "305";
string encoding;
string mimeType;
string extension;
Warning[] warnings = null;
string[] streamIDs = null;
try
{
ExecutionInfo execInfo = new ExecutionInfo();
ExecutionHeader execHeader = new ExecutionHeader();
rs.ExecutionHeaderValue = execHeader;
execInfo = rs.LoadReport(reportPath, historyID);
rs.SetExecutionParameters(parameters, "en-us");
String SessionId = rs.ExecutionHeaderValue.ExecutionID;
System.Diagnostics.Debug.WriteLine("SessionID: {0}",
rs.ExecutionHeaderValue.ExecutionID);
result = rs.Render(format, devInfo, out extension, out encoding,
out mimeType, out warnings, out streamIDs);
System.Diagnostics.Debug.WriteLine("Stream IDs: " +
streamIDs.Length);
#region Apply Toggle Drilldown
bool resultToggle = false;
resultToggle = rs.ToggleItem("1236");
result = rs.Render(format, devInfo, out extension, out encoding,
out mimeType, out warnings, out streamIDs);
#endregion
execInfo = rs.GetExecutionInfo();
System.Diagnostics.Debug.WriteLine(string.Format("Execution date
and time: {0}", execInfo.ExecutionDateTime));
}
catch (SoapException e)
{
System.Diagnostics.Debug.WriteLine(e.Detail.OuterXml);
}
Jeff
"mikel" wrote:
> Teo
> Could you give me an example on how to call the ToggleItem method? Do I need
> to call it together with LoadReport, SetExecutionParameters and Render? If
> yes, in what order do I call it? I have experimented calling it in all kinds
> of order but haven't been able to get it to work ...
> BTW, I think I have found a better way to find the ID of the item that is to
> be toggled - you can get it from the query string, like:
> Request.QueryString["rs:ShowHideToggle"].
> Any help would be much appreciated
> mike
> "Teo Lachev [MVP]" wrote:
> > So, just replace the toolbar then if you need more control over the Report
> > Viewer toolbar.
> >
> > --
> > HTH,
> > ---
> > Teo Lachev, MVP, MCSD, MCT
> > "Microsoft Reporting Services in Action"
> > "Applied Microsoft Analysis Services 2005"
> > Home page and blog: http://www.prologika.com/
> > ---
> > "Ralph Watermann" <We.Want@.NoSpam.de> wrote in message
> > news:OcKGmPf6FHA.1276@.TK2MSFTNGP09.phx.gbl...
> > > Hmm, we'd really like to use the report viewer control. But we need some
> > > control on how the parameters are presented. How many in a row, logically
> > > grouped together in a group box,... If we now use a report viewer control
> > > on an asp.net page, i think the drilldown links will go to the old
> > > server-url and our parameters disappear?
> > >
> > > On the other hand we will have to use drill-through-links not directly to
> > > another report, but trough an url and put together the path and parameters
> > > on our own. And this will be a very long string where a lot of mistakes
> > > can be done...
> > >
> > > Is this the only way to get control over parameter layout?
> > >
> > > "Teo Lachev [MVP]" <teo.lachev@.nospam.prologika.com> schrieb im
> > > Newsbeitrag news:eaJw4ge6FHA.2888@.tk2msftngp13.phx.gbl...
> > >> There is a ToggleItem API in the new ReportExecution web service. The
> > >> problem with it though is that it takes the id of the item to be expanded
> > >> but these IDs are known only when the report is rendered. It's like catch
> > >> 22... You need the id to call ToggleItem but you cannot easily get it. If
> > >> you do some tracing of the incoming SOAP traffic, you will see what I
> > >> mean. So, to get this working, you need to parse the report HTML output
> > >> to find the image id which may look as follows
> > >> <IMG ID="7" BORDER="0"....
> > >>
> > >> Then, when the user clicks you need to invoke ToggleItem passing the
> > >> image identifier. If this sounds like a brain surgery, use the VS.NET
> > >> 2005 report viewers and be done with it. They handle interactivity for
> > >> you.
> > >>
> > >> --
> > >> HTH,
> > >> ---
> > >> Teo Lachev, MVP, MCSD, MCT
> > >> "Microsoft Reporting Services in Action"
> > >> "Applied Microsoft Analysis Services 2005"
> > >> Home page and blog: http://www.prologika.com/
> > >> ---
> > >> "Ralph Watermann" <Ralph.Watermann@.webtelligence.net> wrote in message
> > >> news:%23W0uysb6FHA.268@.TK2MSFTNGP10.phx.gbl...
> > >> Hi,
> > >>
> > >> we tried the SQLRS-ReportViewer from the
> > >>
> > >> We changed the necessary things to get it to work with the new 2005 web
> > >> services. But now we wonder how we can handle drilldowns. In the 2000
> > >> versions of the web services there was an url-parameter showhidetoggle
> > >> which seemed to be the candidate. But we didn't get it to work. But now
> > >> even this parameter seems to have disappeared, and we are not able to
> > >> find helping documentaion.
> > >>
> > >> Regards,
> > >> Ralph
> > >>
> > >>
> > >>
> > >>
> > >
> > >
> >
> >
> >|||Jeff
Thanks for your reply.
I did manage to get ToggleItem to work for HTML4.0 output with calling
Render only once (that is if you don't count the first call to Render to
display the report initially).
I noticed that in your example you were outputing your report to image. So,
since there is no ability for the user to toggle/untoggle items by clicking
on the report, I can see how would have to call Render twice. ToggleItem
needs to be called on an existing execution and will in fact fail if the
execution expires.
What I am having problems with now is trying to export the report to PDF in
its toggled state. No matter what I try (including calling Render twice), it
always comes back with all toggle items collapsed. Do you have any
suggestions on that?
"jgeerwm" wrote:
> Mike,
> From what I have found, you need to actually call the Render method twice.
> I have not been able to get reproducible results using a single call to the
> render method. Here is some code that works for me:
> byte[] result = null;
> string reportPath = "/Accounting/Monthly Revenue Projection
> DrillDown";
> string format = "IMAGE";
> string historyID = null;
> string devInfo => @."<DeviceInfo><OutputFormat>EMF</OutputFormat><StartPage>0</StartPage></DeviceInfo>";
> ParameterValue[] parameters = new ParameterValue[1];
> parameters[0] = new ParameterValue();
> parameters[0].Name = "BillCycle";
> parameters[0].Value = "305";
> string encoding;
> string mimeType;
> string extension;
> Warning[] warnings = null;
> string[] streamIDs = null;
> try
> {
> ExecutionInfo execInfo = new ExecutionInfo();
> ExecutionHeader execHeader = new ExecutionHeader();
> rs.ExecutionHeaderValue = execHeader;
> execInfo = rs.LoadReport(reportPath, historyID);
> rs.SetExecutionParameters(parameters, "en-us");
> String SessionId = rs.ExecutionHeaderValue.ExecutionID;
> System.Diagnostics.Debug.WriteLine("SessionID: {0}",
> rs.ExecutionHeaderValue.ExecutionID);
> result = rs.Render(format, devInfo, out extension, out encoding,
> out mimeType, out warnings, out streamIDs);
> System.Diagnostics.Debug.WriteLine("Stream IDs: " +
> streamIDs.Length);
> #region Apply Toggle Drilldown
> bool resultToggle = false;
> resultToggle = rs.ToggleItem("1236");
> result = rs.Render(format, devInfo, out extension, out encoding,
> out mimeType, out warnings, out streamIDs);
> #endregion
> execInfo = rs.GetExecutionInfo();
> System.Diagnostics.Debug.WriteLine(string.Format("Execution date
> and time: {0}", execInfo.ExecutionDateTime));
> }
> catch (SoapException e)
> {
> System.Diagnostics.Debug.WriteLine(e.Detail.OuterXml);
> }
> Jeff
> "mikel" wrote:
> > Teo
> >
> > Could you give me an example on how to call the ToggleItem method? Do I need
> > to call it together with LoadReport, SetExecutionParameters and Render? If
> > yes, in what order do I call it? I have experimented calling it in all kinds
> > of order but haven't been able to get it to work ...
> >
> > BTW, I think I have found a better way to find the ID of the item that is to
> > be toggled - you can get it from the query string, like:
> > Request.QueryString["rs:ShowHideToggle"].
> >
> > Any help would be much appreciated
> >
> > mike
> >
> > "Teo Lachev [MVP]" wrote:
> >
> > > So, just replace the toolbar then if you need more control over the Report
> > > Viewer toolbar.
> > >
> > > --
> > > HTH,
> > > ---
> > > Teo Lachev, MVP, MCSD, MCT
> > > "Microsoft Reporting Services in Action"
> > > "Applied Microsoft Analysis Services 2005"
> > > Home page and blog: http://www.prologika.com/
> > > ---
> > > "Ralph Watermann" <We.Want@.NoSpam.de> wrote in message
> > > news:OcKGmPf6FHA.1276@.TK2MSFTNGP09.phx.gbl...
> > > > Hmm, we'd really like to use the report viewer control. But we need some
> > > > control on how the parameters are presented. How many in a row, logically
> > > > grouped together in a group box,... If we now use a report viewer control
> > > > on an asp.net page, i think the drilldown links will go to the old
> > > > server-url and our parameters disappear?
> > > >
> > > > On the other hand we will have to use drill-through-links not directly to
> > > > another report, but trough an url and put together the path and parameters
> > > > on our own. And this will be a very long string where a lot of mistakes
> > > > can be done...
> > > >
> > > > Is this the only way to get control over parameter layout?
> > > >
> > > > "Teo Lachev [MVP]" <teo.lachev@.nospam.prologika.com> schrieb im
> > > > Newsbeitrag news:eaJw4ge6FHA.2888@.tk2msftngp13.phx.gbl...
> > > >> There is a ToggleItem API in the new ReportExecution web service. The
> > > >> problem with it though is that it takes the id of the item to be expanded
> > > >> but these IDs are known only when the report is rendered. It's like catch
> > > >> 22... You need the id to call ToggleItem but you cannot easily get it. If
> > > >> you do some tracing of the incoming SOAP traffic, you will see what I
> > > >> mean. So, to get this working, you need to parse the report HTML output
> > > >> to find the image id which may look as follows
> > > >> <IMG ID="7" BORDER="0"....
> > > >>
> > > >> Then, when the user clicks you need to invoke ToggleItem passing the
> > > >> image identifier. If this sounds like a brain surgery, use the VS.NET
> > > >> 2005 report viewers and be done with it. They handle interactivity for
> > > >> you.
> > > >>
> > > >> --
> > > >> HTH,
> > > >> ---
> > > >> Teo Lachev, MVP, MCSD, MCT
> > > >> "Microsoft Reporting Services in Action"
> > > >> "Applied Microsoft Analysis Services 2005"
> > > >> Home page and blog: http://www.prologika.com/
> > > >> ---
> > > >> "Ralph Watermann" <Ralph.Watermann@.webtelligence.net> wrote in message
> > > >> news:%23W0uysb6FHA.268@.TK2MSFTNGP10.phx.gbl...
> > > >> Hi,
> > > >>
> > > >> we tried the SQLRS-ReportViewer from the
> > > >>
> > > >> We changed the necessary things to get it to work with the new 2005 web
> > > >> services. But now we wonder how we can handle drilldowns. In the 2000
> > > >> versions of the web services there was an url-parameter showhidetoggle
> > > >> which seemed to be the candidate. But we didn't get it to work. But now
> > > >> even this parameter seems to have disappeared, and we are not able to
> > > >> find helping documentaion.
> > > >>
> > > >> Regards,
> > > >> Ralph
> > > >>
> > > >>
> > > >>
> > > >>
> > > >
> > > >
> > >
> > >
> > >|||OK. I have figured it out.
For anyone else that may be experiencing the same problem. If you render
your report as HTML4.0, then you toggle some report items, then if you want
to export the report to another format like PDF or image in its toggled
state, you need to:
1. Reuse the reference to ExecutionService that you have preserved in let's
say Session between calls
ReportExecution.ReportExecutionService rsExec =(ReportExecutionService)Session["rs"];
2. Set report parameters that you have also preserved between calls
rsExec.SetExecutionParameters((ReportExecution.ParameterValue[])
Session("reportParameterValues"], "en-us");
3. DO NOT call rsExec.ToggleItem - you are reusing the original report
execution, and if you call ToggleItem again this will have the effect of
untoggling the items that you have previously toggled
4. Set up device info and call Render as normal - Jeff's post 2 posts back
is a good example of how to.
"mikel" wrote:
> Jeff
> Thanks for your reply.
> I did manage to get ToggleItem to work for HTML4.0 output with calling
> Render only once (that is if you don't count the first call to Render to
> display the report initially).
> I noticed that in your example you were outputing your report to image. So,
> since there is no ability for the user to toggle/untoggle items by clicking
> on the report, I can see how would have to call Render twice. ToggleItem
> needs to be called on an existing execution and will in fact fail if the
> execution expires.
> What I am having problems with now is trying to export the report to PDF in
> its toggled state. No matter what I try (including calling Render twice), it
> always comes back with all toggle items collapsed. Do you have any
> suggestions on that?
>
> "jgeerwm" wrote:
> > Mike,
> >
> > From what I have found, you need to actually call the Render method twice.
> > I have not been able to get reproducible results using a single call to the
> > render method. Here is some code that works for me:
> >
> > byte[] result = null;
> >
> > string reportPath = "/Accounting/Monthly Revenue Projection
> > DrillDown";
> > string format = "IMAGE";
> > string historyID = null;
> > string devInfo => > @."<DeviceInfo><OutputFormat>EMF</OutputFormat><StartPage>0</StartPage></DeviceInfo>";
> >
> > ParameterValue[] parameters = new ParameterValue[1];
> > parameters[0] = new ParameterValue();
> > parameters[0].Name = "BillCycle";
> > parameters[0].Value = "305";
> >
> > string encoding;
> > string mimeType;
> > string extension;
> > Warning[] warnings = null;
> > string[] streamIDs = null;
> >
> > try
> > {
> > ExecutionInfo execInfo = new ExecutionInfo();
> > ExecutionHeader execHeader = new ExecutionHeader();
> >
> > rs.ExecutionHeaderValue = execHeader;
> >
> > execInfo = rs.LoadReport(reportPath, historyID);
> >
> > rs.SetExecutionParameters(parameters, "en-us");
> > String SessionId = rs.ExecutionHeaderValue.ExecutionID;
> >
> > System.Diagnostics.Debug.WriteLine("SessionID: {0}",
> > rs.ExecutionHeaderValue.ExecutionID);
> >
> > result = rs.Render(format, devInfo, out extension, out encoding,
> > out mimeType, out warnings, out streamIDs);
> >
> > System.Diagnostics.Debug.WriteLine("Stream IDs: " +
> > streamIDs.Length);
> >
> > #region Apply Toggle Drilldown
> >
> > bool resultToggle = false;
> >
> > resultToggle = rs.ToggleItem("1236");
> > result = rs.Render(format, devInfo, out extension, out encoding,
> > out mimeType, out warnings, out streamIDs);
> >
> > #endregion
> >
> > execInfo = rs.GetExecutionInfo();
> > System.Diagnostics.Debug.WriteLine(string.Format("Execution date
> > and time: {0}", execInfo.ExecutionDateTime));
> >
> > }
> > catch (SoapException e)
> > {
> > System.Diagnostics.Debug.WriteLine(e.Detail.OuterXml);
> > }
> >
> > Jeff
> >
> > "mikel" wrote:
> >
> > > Teo
> > >
> > > Could you give me an example on how to call the ToggleItem method? Do I need
> > > to call it together with LoadReport, SetExecutionParameters and Render? If
> > > yes, in what order do I call it? I have experimented calling it in all kinds
> > > of order but haven't been able to get it to work ...
> > >
> > > BTW, I think I have found a better way to find the ID of the item that is to
> > > be toggled - you can get it from the query string, like:
> > > Request.QueryString["rs:ShowHideToggle"].
> > >
> > > Any help would be much appreciated
> > >
> > > mike
> > >
> > > "Teo Lachev [MVP]" wrote:
> > >
> > > > So, just replace the toolbar then if you need more control over the Report
> > > > Viewer toolbar.
> > > >
> > > > --
> > > > HTH,
> > > > ---
> > > > Teo Lachev, MVP, MCSD, MCT
> > > > "Microsoft Reporting Services in Action"
> > > > "Applied Microsoft Analysis Services 2005"
> > > > Home page and blog: http://www.prologika.com/
> > > > ---
> > > > "Ralph Watermann" <We.Want@.NoSpam.de> wrote in message
> > > > news:OcKGmPf6FHA.1276@.TK2MSFTNGP09.phx.gbl...
> > > > > Hmm, we'd really like to use the report viewer control. But we need some
> > > > > control on how the parameters are presented. How many in a row, logically
> > > > > grouped together in a group box,... If we now use a report viewer control
> > > > > on an asp.net page, i think the drilldown links will go to the old
> > > > > server-url and our parameters disappear?
> > > > >
> > > > > On the other hand we will have to use drill-through-links not directly to
> > > > > another report, but trough an url and put together the path and parameters
> > > > > on our own. And this will be a very long string where a lot of mistakes
> > > > > can be done...
> > > > >
> > > > > Is this the only way to get control over parameter layout?
> > > > >
> > > > > "Teo Lachev [MVP]" <teo.lachev@.nospam.prologika.com> schrieb im
> > > > > Newsbeitrag news:eaJw4ge6FHA.2888@.tk2msftngp13.phx.gbl...
> > > > >> There is a ToggleItem API in the new ReportExecution web service. The
> > > > >> problem with it though is that it takes the id of the item to be expanded
> > > > >> but these IDs are known only when the report is rendered. It's like catch
> > > > >> 22... You need the id to call ToggleItem but you cannot easily get it. If
> > > > >> you do some tracing of the incoming SOAP traffic, you will see what I
> > > > >> mean. So, to get this working, you need to parse the report HTML output
> > > > >> to find the image id which may look as follows
> > > > >> <IMG ID="7" BORDER="0"....
> > > > >>
> > > > >> Then, when the user clicks you need to invoke ToggleItem passing the
> > > > >> image identifier. If this sounds like a brain surgery, use the VS.NET
> > > > >> 2005 report viewers and be done with it. They handle interactivity for
> > > > >> you.
> > > > >>
> > > > >> --
> > > > >> HTH,
> > > > >> ---
> > > > >> Teo Lachev, MVP, MCSD, MCT
> > > > >> "Microsoft Reporting Services in Action"
> > > > >> "Applied Microsoft Analysis Services 2005"
> > > > >> Home page and blog: http://www.prologika.com/
> > > > >> ---
> > > > >> "Ralph Watermann" <Ralph.Watermann@.webtelligence.net> wrote in message
> > > > >> news:%23W0uysb6FHA.268@.TK2MSFTNGP10.phx.gbl...
> > > > >> Hi,
> > > > >>
> > > > >> we tried the SQLRS-ReportViewer from the
> > > > >>
> > > > >> We changed the necessary things to get it to work with the new 2005 web
> > > > >> services. But now we wonder how we can handle drilldowns. In the 2000
> > > > >> versions of the web services there was an url-parameter showhidetoggle
> > > > >> which seemed to be the candidate. But we didn't get it to work. But now
> > > > >> even this parameter seems to have disappeared, and we are not able to
> > > > >> find helping documentaion.
> > > > >>
> > > > >> Regards,
> > > > >> Ralph
> > > > >>
> > > > >>
> > > > >>
> > > > >>
> > > > >
> > > > >
> > > >
> > > >
> > > >