September 2010
Beginner to intermediate
424 pages
12h 17m
English
book
Knight's Microsoft® Business Intelligence 24-Hour Trainer: Leveraging Microsoft SQL Server® Integration, Analysis, and Reporting Services with Excel® and SharePoint®
by Brian Knight, Devin Knight, Adam Jorgensen, Patrick LeBlanc, Mike Davis
Content preview from Knight's Microsoft® Business Intelligence 24-Hour Trainer: Leveraging Microsoft SQL Server® Integration, Analysis, and Reporting Services with Excel® and SharePoint®
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,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
220
LESSON 24 Parameterizing Your rePorts
FIGURE 247
TRY IT
In this Try It you will alter the matrix report from the previous lesson to use parameters. You will
also give these parameters a list of available values and default values.
Lesson Requirements
In this lesson you will create a report that uses a matrix which uses parameters and default values.
You will need the AdventureWorks2008R2 database. This database is free from
www.codeplex.com.
You will also need to know the name of your SQL Server R2 instance. If it is your default instance
you can use LocalHost as the server name. You will also need the matrix report from the previous
lesson.
The download for this lesson, available at www.wrox.com, includes the queries
you need for this Try It.
Hints
Make a copy of the matrix report.
Do not use a shared dataset for this report.
Alter the queries to use parameters.
889633c24.indd 220 8/17/10 10:42:03 AM
Try It
221
Step-by-Step
1. Open the Project BI Trainer reports you created in the previous lesson.
2. Click the Sales by Region report in the Solution Explorer and press Ctrl+C and then Ctrl+V
to paste a copy of the report. A new report will appear, named Copy of SalesbyRegion.
3. Right-click this new report and select Rename. Rename the report SalesbyState.
4. Double-click ...
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.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.