Is the report model only used by report builder?

Is the report model only used by report builder? Can it be used by report project in Development Studio? Then I don't need to writing SQL for all the regular reports. Like Cognos report studio, I can use model to create some regular reports. Do I have to writing SQL to create report in Development Studio?
LVL 1
adamyAsked:
Who is Participating?
 
Megan BrooksConnect With a Mentor SQL Server ConsultantCommented:
If you have a report model that you like then you can use it in Report Designer. In fact, you can download the RDL from a report created with Report Builder and work with it in Report Builder.
When you create a report Data Source, one of the options for "Type" is "Report Model." See this article for details:
http://msdn.microsoft.com/en-us/library/ms345238.aspx
This information is for SSRS 2008. I believe it is basically the same for SSRS 2005 but I am not certain.
0
 
Megan BrooksSQL Server ConsultantCommented:
Sorry, that was supposed to read "...from a report created with Report Builder and work with it in Report Designer."
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.