July 10, 2007 at 6:11 am
Hi,
I am new to the SQL Server 2005 reporting services. I need to know the difference between a report (.rdl) and report model (.smdl) woth respect to when they are used, what they can do etc...
Thanks in advance...
Regards,
Nitin
July 10, 2007 at 12:49 pm
http://technet.microsoft.com/en-us/library/ms156285.aspx
look for more resources on msdn they have a very good repository
July 11, 2007 at 11:52 am
The short is that a report is a report (sorry to be that obvious) and a report model is basically a pre-set schema that is published allowing the end users to create their own reports from that information.
Report models can be a bit complicated to set up, but once you do, the users can build their own reports with the report builder tool in the report manager that comes with reporting services.
July 12, 2007 at 6:50 am
My two cents; think of a report model as superview that defines all the possible joins in advance, so users just pick fields and RS automatically builds the query with the correct joins. In addition, a model provides a nice abstraction layer, so you can prettify column names there if needed, or you can mask underlying database complexity. Reports can be build against the database directly or the model using BIDS, end users can use Report Builder to build reports using the model only.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply