Groups | Blog | Home
all groups > sql server reporting services > july 2006 >

sql server reporting services : How to resolve RS 2005 ReportExecutionService ToggleItem method problem


InvalidLastName
7/26/2006 12:33:36 PM
Hi,
This is a follow-up for my own post "RS 2005 ReportExecutionService =
ToggleItem method problem"
http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/b=
rowse_frm/thread/2fcb4ec23fbedbe1/cf24c952c6f1bc20?lnk=3Dst&q=3D&rnum=3D1=
#cf24c952c6f1bc20

Here is the fix. You need to add "<StreamRoot>...</StreamRoot>" into =
<DeviceInfo> then the toggleitem will start working.=20


For examples:=20
This won't work=20
string devInfo =3D =
@"<DeviceInfo><Toolbar>False</Toolbar><Section>1</Section><HTMLFragment>F=
al=ADse</HTMLFragment></DeviceInfo>";=20


But the next one will:
string devInfo =3D =
@"<DeviceInfo><StreamRoot></StreamRoot><Toolbar>False</Toolbar><Section>1=
</=ADSection><HTMLFragment>False</HTMLFragment></DeviceInfo>";=20



I didn't try other combination is DeviceInfo, however, I do notice the =
device info for html output described in BOL=20
http://msdn2.microsoft.com/en-us/library/ms155395.aspx are different to =
the real-world behaviors

For examples :
extracted from BOL=20
HTMLFragment=20
Indicates whether an HTML fragment is created in place of a full =
HTML document. An HTML fragment includes the report content in a TABLE =
element and omits the HTML and BODY elements. The default value is =
false. If you are rendering to HTML using the Render method of the SOAP =
API, you need to set this device information to true if you are =
rendering a report with images. Rendering using SOAP with the =
HTMLFragment property set to true creates URLs containing session =
information that can be used to properly request images. The images must =
be uploaded resources in the report server database. (ILN: I am seeing =
different behavior. no links will be rendered)=20


Toolbar=20
Indicates whether to show or hide the toolbar. The default of this =
parameter is true. If the value of this parameter is false, all =
remaining options (except the document map) are ignored. If you omit =
this parameter, the toolbar is automatically displayed for rendering =
formats that support it.=20


The Report Viewer toolbar is rendered when you use URL access to =
render a report. The toolbar is not rendered through the SOAP API. =
However, the Toolbar device information setting affects the way that the =
report is displayed when using the SOAP Render method. If the value of =
this parameter is true when using SOAP to render to HTML, only the first =
section of the report is rendered. If the value is false, the entire =
HTML report is rendered as a single HTML page. (ILN: I am seeing =
different behavior. I can always get first page if I set Section to 1 =
even Toolbar is off )=20

ReplacementRoot=20
The path used for prefixing the value of the href attribute of the =
A element in the HTML report returned by the report server. By default, =
the report server provides the path. You can use this setting to specify =
a root path for any hyperlinks in your report. (ILN: doesn't seem =
working at all)
=20


I am not quite what happens here. Are these bugs, or there are some =
undocumented valid combinations for DeviceInfo to work ?



stcheng NO[at]SPAM online.microsoft.com
7/27/2006 4:24:11 AM
Hello David,

Glad to hear from you again. As for this issue I've also replied you in
your former thread discussing on this issue. As I mentienod there, I would
suggest you also forward your finding to our product support engineer to
see whether they can help you find more information on this.

Sincerely,

Steven Cheng

Microsoft MSDN Online Support Lead


This posting is provided "AS IS" with no warranties, and confers no rights.


InvalidLastName
7/27/2006 9:21:13 AM
Thanks Steven. I will do that.


ILN


[quoted text, click to view]

AddThis Social Bookmark Button