sql server reporting services: Hi,

the rs utility is good, but the script is compiled at every usage.
does it possible to compile a script 1 time and keep the compiled version?

for the moment I bypass this problem by creating my own program.
any idea?

thanks.

Jerome.

Hello Jerome,

The rs utility does instantiate a few objects for you and calls methods on
the RS SOAP interface. But yes each time you run it, it gets compiled first
into .NET IL before being executed.

If you write your own .NET program that calls methods on the RS SOAP
interface then you'd have to instatiate some of the objects yourself - like
the Report Service. Its not difficult to convert RS Script to a VB.NET
program that you can compile into a .NET assembly.

Chapter 9¾ of our book : "Hitchhiker's Guide to SQL Server 2000 Reporting
Services" covers this content.

Peter Blackburn
Windows Server Systems - SQL Server MVP
Hitchhiker's Guide to SQL Server Reporting Services
http://www.sqlreportingservices.net


[quoted text, click to view]

On Sun, 14 Nov 2004 21:49:50 -0000, "Peter Blackburn
\(www.sqlreportingservices.net\)"
[quoted text, click to view]

Hi Peter,

I just love the idea of chapter 9¾. :)

Andrew Watt

Hello Andrew - you'll probably love our Voldemort Basic.NET quips in that
chapter too!

Peter


[quoted text, click to view]