Trying to take the result from a report on RS exported as XML via URLSyntax
Ex.
http://servername/ReportServer?/folder/reportName&customerName=customerName&rs:Command=Render&rs:Format=XML
This example renders a XML-document, trying to use Microsoft.XMLHTTP, ASP to
get the data from server.
Sample:
-set xml=server.createObject("Microsoft.XMLHTTP")
-xml.open "GET", XMLURL, false
-xml.send
-xml.responseText
No problems so far, the document is there.
Is there anyone out there who can tell me how to use XSLT serverside
together with above XML.
best regards
Kjell BrandesKjell,
You can assign XSLT using the Data Output tab (Data Transform field) on the
report properties.
--
Hope this helps.
----
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
----
"Kjell Brandes" <kjell@.brandes.tv> wrote in message news:e2gMQDtqEHA.556@.
tk2msftngp13.phx.gbl...
> Trying to take the result from a report on RS exported as XML via
URLSyntax
> Ex.
>
http://servername/ReportServer?/folder/reportName&customerName=customerName&rs:Command=Render&rs:Format=XML
>
> This example renders a XML-document, trying to use Microsoft.XMLHTTP, ASP
to
> get the data from server.
> Sample:
> -set xml=server.createObject("Microsoft.XMLHTTP")
> -xml.open "GET", XMLURL, false
> -xml.send
> -xml.responseText
> No problems so far, the document is there.
> Is there anyone out there who can tell me how to use XSLT serverside
> together with above XML.
> best regards
> Kjell Brandes
>
Showing posts with label exported. Show all posts
Showing posts with label exported. Show all posts
Tuesday, March 20, 2012
Saturday, February 25, 2012
please help.. exported excel something wrong
HI,
when I export to excel that consist of hierarchy(five leavels),
the exported excel show me only two levels.
I want to make whole levels of Web form leavels in exported excel.
as same as I can see the Web form. (hierarchy!!)
what can I do? what's the problem?Is the toggle positoned right above the toggled items or you have other
report items between them? Could you share the rdl, please?
--
Nico Cristache [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"woo" <woo@.discussions.microsoft.com> wrote in message
news:D3272A59-059D-42AC-A2D9-317F4BC034D8@.microsoft.com...
> HI,
> when I export to excel that consist of hierarchy(five leavels),
> the exported excel show me only two levels.
> I want to make whole levels of Web form leavels in exported excel.
> as same as I can see the Web form. (hierarchy!!)
> what can I do? what's the problem?
>
when I export to excel that consist of hierarchy(five leavels),
the exported excel show me only two levels.
I want to make whole levels of Web form leavels in exported excel.
as same as I can see the Web form. (hierarchy!!)
what can I do? what's the problem?Is the toggle positoned right above the toggled items or you have other
report items between them? Could you share the rdl, please?
--
Nico Cristache [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"woo" <woo@.discussions.microsoft.com> wrote in message
news:D3272A59-059D-42AC-A2D9-317F4BC034D8@.microsoft.com...
> HI,
> when I export to excel that consist of hierarchy(five leavels),
> the exported excel show me only two levels.
> I want to make whole levels of Web form leavels in exported excel.
> as same as I can see the Web form. (hierarchy!!)
> what can I do? what's the problem?
>
Subscribe to:
Posts (Atom)