sql server reporting services: We would like to support Report Builder / Report Models in our application,
and we know that Report models are generated from SQL Server relational or
Analysis Services multidimensional databases. Based on our superficial
understandings of report models, it seems that we should be able to create an
entity based on more than one source table/view with or without security
filters and even give it a friendly name. Is this correct? If so, is it
possible to create a report model programmatically?

If not programmatically, we would want more help with how to create a report
model in details. The current tutorial in the SQL Server Books online is
actually not detailed enough (most of the time it guides us to accept the
defaults).

Hi,

Welcome to use MSDN Managed Newsgroup!

From your descriptions, I understood you would like to whether it is
possible to create a report model programmatically. If I have misunderstood
your concern, please feel free to point it out.

I think BOL contains two useful articles for your reference

How to: Create a Model Using Report Manager
http://msdn2.microsoft.com/en-us/library/ms159118.aspx

How to: Create a Report Model Using the Model Designer Wizard
http://msdn2.microsoft.com/en-us/library/ms156284.aspx

Also, this article explains the major components of Microsoft Reporting
Services' ad-hoc architecture and semantic model, and walks you through an
end-to-end example that demonstrates how to author, manage, and deliver
ad-hoc reports.

Generate Ad-hoc Reports with Microsoft Reporting Services 2005
http://www.devx.com/dbzone/Article/28047

Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!


Sincerely yours,

Michael Cheng
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.