Generating reports on fly

Hello,

SRS 2005 provides functionality for loading and rendering reports on fly using LoadReportDefinition and Render methods defined in ReportExecutionService webservice.

I was wondering if the same/similar behaviour can be accomplished in Reporting Services 2000.

Thanks in advance,

Kobi

LoadReportDefinition API was introduced in 2005 for the Report Builder. With SSRS 2000 you have to explicitly upload the report defnition.

generating report in web form

i would like to ask if using the Render() function is the ONLY way to get the
report in the web?(exclude the url access)
how about SOAP? how to use SOAP to generating report in web?
by the way, is render() a method which comes from SOAP?
i am confuse about it...please help
thanks in advanceHi Jason:
Render is part of the web service (aka SOAP) API.
There are other methods you can come up with to get a report to the
web. For instance, you could set up a report subscription and have the
report delivered to a network share. A web site could map to the same
network share and make the reports available.
--
Scott
http://www.OdeToCode.com
On Mon, 20 Sep 2004 21:05:01 -0700, "Jasonymk"
<Jasonymk@.discussions.microsoft.com> wrote:
>i would like to ask if using the Render() function is the ONLY way to get the
>report in the web?(exclude the url access)
>how about SOAP? how to use SOAP to generating report in web?
>by the way, is render() a method which comes from SOAP?
>i am confuse about it...please help
>thanks in advance|||hi Scott,
thanks you very much for helping me...i have make a web reference to the
reportservice.asmx...like the online book said...does it mean that i am
already using SOAP?
mmm i think for the method you mentioned i think thats more or less the same
as URL access right? i think that may not be useful for me cos i would like
to have report like invoice with a partiular number chosen by the user.
So...constant delivery may not be useful(subscription is set in the report
server right?)
once again...ths for helping....
"Scott Allen" wrote:
> Hi Jason:
> Render is part of the web service (aka SOAP) API.
> There are other methods you can come up with to get a report to the
> web. For instance, you could set up a report subscription and have the
> report delivered to a network share. A web site could map to the same
> network share and make the reports available.
> --
> Scott
> http://www.OdeToCode.com
> On Mon, 20 Sep 2004 21:05:01 -0700, "Jasonymk"
> <Jasonymk@.discussions.microsoft.com> wrote:
> >i would like to ask if using the Render() function is the ONLY way to get the
> >report in the web?(exclude the url access)
> >
> >how about SOAP? how to use SOAP to generating report in web?
> >by the way, is render() a method which comes from SOAP?
> >
> >i am confuse about it...please help
> >thanks in advance
>|||Hi jason:
Yes - if you have a web reference you are already using SOAP.
It doesn't sound as if having a report delivered would fit what you
need to do.
--
Scott
http://www.OdeToCode.com
On Mon, 20 Sep 2004 23:07:04 -0700, "Jasonymk"
<Jasonymk@.discussions.microsoft.com> wrote:
>hi Scott,
>thanks you very much for helping me...i have make a web reference to the
>reportservice.asmx...like the online book said...does it mean that i am
>already using SOAP?
>mmm i think for the method you mentioned i think thats more or less the same
>as URL access right? i think that may not be useful for me cos i would like
>to have report like invoice with a partiular number chosen by the user.
>So...constant delivery may not be useful(subscription is set in the report
>server right?)
>once again...ths for helping....
>"Scott Allen" wrote:
>> Hi Jason:
>> Render is part of the web service (aka SOAP) API.
>> There are other methods you can come up with to get a report to the
>> web. For instance, you could set up a report subscription and have the
>> report delivered to a network share. A web site could map to the same
>> network share and make the reports available.
>> --
>> Scott
>> http://www.OdeToCode.com
>> On Mon, 20 Sep 2004 21:05:01 -0700, "Jasonymk"
>> <Jasonymk@.discussions.microsoft.com> wrote:
>> >i would like to ask if using the Render() function is the ONLY way to get the
>> >report in the web?(exclude the url access)
>> >
>> >how about SOAP? how to use SOAP to generating report in web?
>> >by the way, is render() a method which comes from SOAP?
>> >
>> >i am confuse about it...please help
>> >thanks in advance
>>

Generating a value list using PATH mode

I am attempting to get data using the "for xml path" and would like to list my data in child elements. I can render the data in the format that I would want but instead of creating child elements I am left with HTML like character codes around my element name (&lt and &gt).

I am following the example outlined in http://msdn2.microsoft.com/en-us/library/ms189885.aspx section C. The example unfortunately even shows the &lt and &gt symbols. I am missing something obvious here? Any help would be greatly appreciated.

Are you using a nested query? If so add the TYPE directive to the FOR XML e.g.

Code Snippet

SELECT ProductModelID as "@.ProductModelID",

Name as "@.ProductModelName",

(SELECT ProductID as "data()"

FROM Production.Product

WHERE Production.Product.ProductModelID =

Production.ProductModel.ProductModelID

FOR XML PATH ('')

) as "@.ProductIDs",

(

SELECT Name as "ProductName"

FROM Production.Product

WHERE Production.Product.ProductModelID =

Production.ProductModel.ProductModelID

FOR XML PATH (''), TYPE

) as "ProductNames"

FROM Production.ProductModel

WHERE ProductModelID= 7 or ProductModelID=9

FOR XML PATH('ProductModelData')

that way the XML is not escaped.