Using class as data source for End User Reporting (rdlc)
Posted on 2013-12-05
I have developed an application in VB.Net (VS 2008) that contains a number of reports. Currently these are all set as EmbeddedResource reports, which works fine.
I know I could also set the Reports as external to my application using the ReportPath option too, which got me thinking.
I would like the end user (at least one trained in report writing) to be able to modify or even create these RDLC files. I assume Visual Studio Report designer is the best tool for this (if there's a better one, please let me know).
That would be fine if the data sources were SQL Tables, but I use classes as Business Objects as my datasources. That means I create the Business Object programatically as pass it as the data source when using ReportViewer.
I could still do that as the modified RDCL files would still be called from within my application but how can the end user, when using Report Designer, access the Business Object 'schema'? I know they will need to come back within the application to preview the report with data but is there any way I can export the Data Source from my VB.NET project so the fields/members are available for report design outside of my project?
Hope that makes sense. Let me know if not.