execute RDL dynamically...

I know you can create RDL programatically...but is it possible to execute
the RDL on a report server without having to publish it to the server? I
want to be able to generate some RDL on the fly and execute it on the report
server and display the report to a user. Thanks for any help!!
Sunish AbrahamNo, you cannot (with RS 2000). VS 2005 (controls ship with VS 2005 and work
with RS 2005) will have a web and winform control that can run in local
mode, you give it a dataset and the report and away it goes.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Sunish Abraham" <sunisha@.comcast.net> wrote in message
news:eTf3Ye7sFHA.904@.tk2msftngp13.phx.gbl...
>I know you can create RDL programatically...but is it possible to execute
>the RDL on a report server without having to publish it to the server? I
>want to be able to generate some RDL on the fly and execute it on the
>report server and display the report to a user. Thanks for any help!!
> Sunish Abraham
>|||Hi Bruce!
Thanks for the quick response! Is what you are saying is that you can
generate RDL and a dataset and execute the report using the dataset without
having to "publish" the report to the reporting server? Is this control
part of the SQL2005 RS samples (if so what is the name of the control)?
Thanks again!!
Sunish
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:%23JJWAx7sFHA.2592@.TK2MSFTNGP09.phx.gbl...
> No, you cannot (with RS 2000). VS 2005 (controls ship with VS 2005 and
> work with RS 2005) will have a web and winform control that can run in
> local mode, you give it a dataset and the report and away it goes.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Sunish Abraham" <sunisha@.comcast.net> wrote in message
> news:eTf3Ye7sFHA.904@.tk2msftngp13.phx.gbl...
>>I know you can create RDL programatically...but is it possible to execute
>>the RDL on a report server without having to publish it to the server? I
>>want to be able to generate some RDL on the fly and execute it on the
>>report server and display the report to a user. Thanks for any help!!
>> Sunish Abraham
>>
>|||It is part of Widbey. They were there with the last beta but I am not sure
on whether or not there were any problems with it. Anyway, these controls do
not ship with RS, only with VS.
In local mode you don't even have to have a server around. The controls work
with a RS server if you have one but you also have the option of using the
controls in local mode.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Sunish Abraham" <sunisha@.comcast.net> wrote in message
news:ODG8nv9sFHA.3460@.TK2MSFTNGP10.phx.gbl...
> Hi Bruce!
> Thanks for the quick response! Is what you are saying is that you can
> generate RDL and a dataset and execute the report using the dataset
> without having to "publish" the report to the reporting server? Is this
> control part of the SQL2005 RS samples (if so what is the name of the
> control)? Thanks again!!
> Sunish
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:%23JJWAx7sFHA.2592@.TK2MSFTNGP09.phx.gbl...
>> No, you cannot (with RS 2000). VS 2005 (controls ship with VS 2005 and
>> work with RS 2005) will have a web and winform control that can run in
>> local mode, you give it a dataset and the report and away it goes.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Sunish Abraham" <sunisha@.comcast.net> wrote in message
>> news:eTf3Ye7sFHA.904@.tk2msftngp13.phx.gbl...
>>I know you can create RDL programatically...but is it possible to execute
>>the RDL on a report server without having to publish it to the server? I
>>want to be able to generate some RDL on the fly and execute it on the
>>report server and display the report to a user. Thanks for any help!!
>> Sunish Abraham
>>
>>
>|||I see that there is a ReportViewer subdirectory under the VS.NET install
directory which contains compiled files (Microsoft.ReportViewer.Common.dll,
Microsoft.ReportViewer.WebForms.dll,
Microsoft.ReportViewer.WinForms.dll)...are these the controls that you are
referencing? Is there documentation on how to use these controls? Thanks!
Sunish
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:uYFFMy9sFHA.1568@.TK2MSFTNGP10.phx.gbl...
> It is part of Widbey. They were there with the last beta but I am not sure
> on whether or not there were any problems with it. Anyway, these controls
> do not ship with RS, only with VS.
> In local mode you don't even have to have a server around. The controls
> work with a RS server if you have one but you also have the option of
> using the controls in local mode.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Sunish Abraham" <sunisha@.comcast.net> wrote in message
> news:ODG8nv9sFHA.3460@.TK2MSFTNGP10.phx.gbl...
>> Hi Bruce!
>> Thanks for the quick response! Is what you are saying is that you can
>> generate RDL and a dataset and execute the report using the dataset
>> without having to "publish" the report to the reporting server? Is this
>> control part of the SQL2005 RS samples (if so what is the name of the
>> control)? Thanks again!!
>> Sunish
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:%23JJWAx7sFHA.2592@.TK2MSFTNGP09.phx.gbl...
>> No, you cannot (with RS 2000). VS 2005 (controls ship with VS 2005 and
>> work with RS 2005) will have a web and winform control that can run in
>> local mode, you give it a dataset and the report and away it goes.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Sunish Abraham" <sunisha@.comcast.net> wrote in message
>> news:eTf3Ye7sFHA.904@.tk2msftngp13.phx.gbl...
>>I know you can create RDL programatically...but is it possible to
>>execute the RDL on a report server without having to publish it to the
>>server? I want to be able to generate some RDL on the fly and execute
>>it on the report server and display the report to a user. Thanks for
>>any help!!
>> Sunish Abraham
>>
>>
>>
>|||Sorry, I don't know much more that what I have told you.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Sunish Abraham" <sunisha@.comcast.net> wrote in message
news:OtOVKJ%23sFHA.664@.tk2msftngp13.phx.gbl...
>I see that there is a ReportViewer subdirectory under the VS.NET install
>directory which contains compiled files (Microsoft.ReportViewer.Common.dll,
>Microsoft.ReportViewer.WebForms.dll,
>Microsoft.ReportViewer.WinForms.dll)...are these the controls that you are
>referencing? Is there documentation on how to use these controls? Thanks!
> Sunish
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:uYFFMy9sFHA.1568@.TK2MSFTNGP10.phx.gbl...
>> It is part of Widbey. They were there with the last beta but I am not
>> sure on whether or not there were any problems with it. Anyway, these
>> controls do not ship with RS, only with VS.
>> In local mode you don't even have to have a server around. The controls
>> work with a RS server if you have one but you also have the option of
>> using the controls in local mode.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Sunish Abraham" <sunisha@.comcast.net> wrote in message
>> news:ODG8nv9sFHA.3460@.TK2MSFTNGP10.phx.gbl...
>> Hi Bruce!
>> Thanks for the quick response! Is what you are saying is that you can
>> generate RDL and a dataset and execute the report using the dataset
>> without having to "publish" the report to the reporting server? Is this
>> control part of the SQL2005 RS samples (if so what is the name of the
>> control)? Thanks again!!
>> Sunish
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:%23JJWAx7sFHA.2592@.TK2MSFTNGP09.phx.gbl...
>> No, you cannot (with RS 2000). VS 2005 (controls ship with VS 2005 and
>> work with RS 2005) will have a web and winform control that can run in
>> local mode, you give it a dataset and the report and away it goes.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Sunish Abraham" <sunisha@.comcast.net> wrote in message
>> news:eTf3Ye7sFHA.904@.tk2msftngp13.phx.gbl...
>>I know you can create RDL programatically...but is it possible to
>>execute the RDL on a report server without having to publish it to the
>>server? I want to be able to generate some RDL on the fly and execute
>>it on the report server and display the report to a user. Thanks for
>>any help!!
>> Sunish Abraham
>>
>>
>>
>>
>