1237
Chapter 55: Authoring Reports in Reporting Services
55
■ (^) Options: Provides source-specifi c options such as collation.
■ Filters: Enables the defi nition of fi lters on the data returned from the source.
Filters are run in-memory after the entire dataset has been returned and are often
used with report parameters to enable users to display a subset of the data without
querying the source a second time.
Since SSRS 2008 R2, datasets have had the capability of being created as shared datasets
and published as separate objects to the Report Manager. This enabled users, who might not
create a query for a drop-down list in a parameter to consume shared datasets in their own
reports, speeding development time.
Report Defi nition Language (RDL) Files
The report defi nition language fi les contain the layout of data fi elds, formatting, and other
design elements that make up the actual report. They have the fi le extension of .rdl.
Building a Report with the Report Wizard
Reports vary in complexity and required design time; however, you can create a quick
report by using the Report Wizard inside SSRS. it often speeds development time to get a
report foundation by using the wizard, which can then be modifi ed to any further require-
ments you have.Imagine that you are the report writer for Adventureworks. You have been tasked with
a simple report giving the contact information for all of the resellers of Adventureworks
products. You have worked out the following query from the AdventureworksDW database
to satisfy the requirements:SELECT dsr.ResellerName , dsr.Phone
,dsr.AddressLine1, dsr.AddressLine2, dg.City,
dg.StateProvinceCode , dg.EnglishCountryRegionName ,
dsr.AnnualSales
FROM DimReseller dsr
JOIN DimGeography dg ON dsr.GeographyKey = dg.GeographyKeyFIGURE 55-1
Query result for reseller contact info.c55.indd 1237c55.indd 1237 7/31/2012 10:28:04 AM7/31/2012 10:28:04 AM
http://www.it-ebooks.info