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 programmatically
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.ReportingServices.ReportRendering" 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.ReportingServices.Report
Dim imgIt as new Microsoft.ReportingServices.Image
'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