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
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment