Generate reports programmaticall y with reporting services & SQL server 2005

[Martin Widmer]

Hi guys

I am looking for the best way to generate new reports with reporting
services for SQL server 2005. The reports will be generated programmaticall y
from a .Net VB application. So far I see the only way to do it is to feature
my objects (text blocks, pictures, tables drawn from excel and databases
etc.) with a "render to RDL"- function and thus create an RDL definition of
the report, then push that one to the server using the reporting web
service.

I found though on the MSDN site the
"Microsoft.Repo rtingServices.R eportRendering" name space, which seems to be
there for extending the reporting services features. Instead of writing code
to produce RDL, isn't there a way to use that object model to create a new
report using something like this?:

Dim repIt as new Microsoft.Repor tingServices.Re port
Dim imgIt as new Microsoft.Repor tingServices.Im age

'Adjust properties of image here, and load it

repIt.Add(imgIt )

'More of the same

'Deploy and use the report

Am I thinking totally wrong, or how could I do more elegant than producing
RDL with my application? I prefer to use the proper object model than
producing RDL.

I am happy for any hints in this matter.

Martin

[Ken Tucker [MVP]]

Hi,

Didnt sql server 2005 add a Report server project and report server
wizard to the business intelligence projects in vs 2005?

Ken
------------------------
"Martin Widmer" <ma***********@ businessnet.de> wrote in message
news:dq******** **@nntp.init7.n et...

Hi guys

I am looking for the best way to generate new reports with reporting
services for SQL server 2005. The reports will be generated
programmaticall y
from a .Net VB application. So far I see the only way to do it is to
feature
my objects (text blocks, pictures, tables drawn from excel and databases
etc.) with a "render to RDL"- function and thus create an RDL definition
of
the report, then push that one to the server using the reporting web
service.

I found though on the MSDN site the
"Microsoft.Repo rtingServices.R eportRendering" name space, which seems to
be
there for extending the reporting services features. Instead of writing
code
to produce RDL, isn't there a way to use that object model to create a new
report using something like this?:

Dim repIt as new Microsoft.Repor tingServices.Re port
Dim imgIt as new Microsoft.Repor tingServices.Im age

'Adjust properties of image here, and load it

repIt.Add(imgIt )

'More of the same

'Deploy and use the report

Am I thinking totally wrong, or how could I do more elegant than producing
RDL with my application? I prefer to use the proper object model than
producing RDL.

I am happy for any hints in this matter.

Martin

[Martin Widmer]

Hi Ken

"Ken Tucker [MVP]" <vb***@bellsout h.net> schrieb im Newsbeitrag
news:ui******** ******@TK2MSFTN GP14.phx.gbl...

Hi,

Didnt sql server 2005 add a Report server project and report server
wizard to the business intelligence projects in vs 2005?

Yes exactly. But I don't want to create reports using a wizard. I need to
create the report programmaticall y. And I wonder if there is a way using the
report object model for that. I could do it by simply creating a RDL file by
code, but using objects is more elegant :)

Martin