Programming Reports against using Report Builder

I am trying to find some reasons why it would be beneficial to program a report through .NET 2.0 by Generating Report Definition Language to enable users to create dynamic reports, which then can be published to the report server using reporting services web service INSTEAD of just simply using report builder for external users.

There must be situations when report builder is restricted to provide certain functionality which could be accomplished instead programming the report with RDL.

I would appreciate a quick response. Thank you

I a very astract view, the report builder does nothing else than composing the RDL which is created by the graphical modifications of the user in the GUI.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

Thanks,

But what can I do with programming RDL using Visual Studio 2005 which I cannot do with Report Builder, i.e. what functionality does report builder not support which can be acheived by programming RDL to create dynamic reports?

Programmatically generating a reporting model?

Is there documentation/examples on how to programmatically generate a report model (.smdl XML file)? The situation I'm in would make generating the model manually via Visual Studios difficult (would have to hire lots of people).

Any ideas or suggestions would be greatly appreciated.

One option is to download the XSD here and generate an object model from it:

http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/SemanticModeling.xsd