The Report Model
One of the biggest hurdles for nondatabase professionals to overcome when creating reports is the creation of the dataset. Unless data is being pulled from a ready-made view or stored procedure, dataset creation is going to involve the creation of a SQL SELECT statement with all the INNER JOINs and WHERE clauses that go along with it. For those who want to get the full benefits of the Reporting Services environment, becoming conversant in the SQL dialect is worthwhile. For others who would rather spend time on analyzing data than learning the ins and outs of the GROUP BY, and who would rather concentrate on aiding their organizations than becoming intimate with UNION queries, there is the Report Model.
The Report Model provides ...
Get Microsoft SQL Server 2005 Reporting Services, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
