Skip to Content
Microsoft® SQL Server 2012 Unleashed
book

Microsoft® SQL Server 2012 Unleashed

by Ray Rankins, Paul T. Bertucci, Chris Gallelli, Alex T. Silverstein
December 2013
Intermediate to advanced
1872 pages
153h 31m
English
Sams
Content preview from Microsoft® SQL Server 2012 Unleashed

Using Datasets

Every meaningful report relies on at least one dataset. In SSRS terms, a dataset is simply an abstraction of some set of source data generated by a query and used within a report. Datasets remember the data structure of the queries whose output they contain (the fields, field names, field data types, collation, case sensitivity, and so on). Datasets also store the underlying query used to derive report data from a data source and are aware of any parameters needed to obtain that data—for example, in cases where the underlying data source is a stored procedure.

Every data-bound control on your report needs a dataset from which it will be populated at report (and query) execution time. In SSDT, datasets are listed in the Report Data ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Microsoft® SQL Server 2008 R2 Unleashed

Microsoft® SQL Server 2008 R2 Unleashed

Ray Rankins, Paul Bertucci, Chris Gallelli, Alex T. Silverstein
Inside Microsoft® SQL Server® 2008: T-SQL Programming

Inside Microsoft® SQL Server® 2008: T-SQL Programming

Dejan Sarka Itzik Ben-Gan Greg Low, Roger Wolter, Ed Katibah, and Isaac Kunen

Publisher Resources

ISBN: 9780133408539Purchase book