|
web
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Generate reports programmatically with reporting services & SQL server 2005I 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 Hi,
Didnt sql server 2005 add a Report server project and report server wizard to the business intelligence projects in vs 2005? Ken ------------------------ Show quoteHide quote "Martin Widmer" <martin.wid***@businessnet.de> wrote in message news:dqi7nr$qoa$1@nntp.init7.net... > 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 > > > Hi Ken
"Ken Tucker [MVP]" <vb***@bellsouth.net> schrieb im Newsbeitrag Yes exactly. But I don't want to create reports using a wizard. I need to news:ui68GE2GGHA.2012@TK2MSFTNGP14.phx.gbl... > Hi, > > Didnt sql server 2005 add a Report server project and report server > wizard to the business intelligence projects in vs 2005? create the report programmatically. 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
When I get the image from the file the file remains locked
Process that copies a prn file to a network printer under username ListView SortKey Dynamic variable/object name reference. how to do in VB.NET? Problem with DataAdapter Fill method, Ithink Unsigned types and CLS-compliance Is MDI child open or not? controls collection VB.Net Setup Project Attaching controls in runtime... |
|||||||||||||||||||||||