> We would like to take advantage of the Report Builder tool to provide
> end-user ad-hoc reporting. The database for the application can be
> different depending on how the client configures it (they can add various
> fields and data collection forms). At TechEd, I attended a session on
> Microsoft Dynamics AX 4.0 and its tight integration with Reporting
> Services/Report Builder. This is very much in line with what we'd like to
> do. I imagine the users adding a field (through our interface), setting a
> few properties, and then after some automated process occurs, they would be
> able to use Report Builder to access any data collected in that field.
>
> What we'd like to do is programmatically generate and maintain a report
> model based on how the individual install is configured. I've found some
> documentation that makes me believe this is possible, but I'm hoping someone
> can nudge me in the right direction. The ReportingServices2005 class has
> several model related methods (CreateModel) and I found the .xsd for the
> semantic model XML file
> (http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/SemanticModeling.xsd),
> but no real documentation on how to put together a Report Model document
> from scratch. Looking at the files generated from BIDS is somewhat
> overwhelming and I have no idea where I'd pull most of the information.
>
> Any help that can be provided would be greatly appreciated. Thanks!
> Russell
>
>