Skip to Main Content
Microsoft® SQL Server 2005 Reporting Services
book

Microsoft® SQL Server 2005 Reporting Services

by Michael Lisin, Jim Joseph
March 2006
Beginner to intermediate content levelBeginner to intermediate
480 pages
11h 17m
English
Sams
Content preview from Microsoft® SQL Server 2005 Reporting Services

Chapter 10. Report Parameters

In This Chapter

• Setting Up Parameters

• Parameter Properties

• Data-Driven Parameters

• Parameters and Data Sources

• Expressions with Parameters

• Dynamic SQL with Parameters

• Parameter Dependencies

• Example Using MultiSelect

Report-level parameters can serve a number of functions, including the following:

• Manipulating report data

• Connecting related reports together

• Varying report layout and presentation

Parameters are used to pass information to a report to influence report processing. For example, a parameter can serve as a condition in a WHERE of a query that generates the report’s data set. Parameters are relatively easy to set up and are very flexible.

Report parameters can be presented to the ...

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 Reporting Services Unleashed

Microsoft® SQL Server™ 2008 Reporting Services Unleashed

Michael Lisin, Jim Joseph, Amit Goyal

Publisher Resources

ISBN: 0672327996Purchase book