Filter data and Add parameters to a report SQL Server SQL Server


show more Filtering data and adding parameters to a report means you are setting limits on how many rows of useful data you bring out of your SQL Server database. This training video helps you learn how to go into a dataset and tell the server what information you need, as well as how to narrow that information into a usable dataset for a report. show less
please wait ...

Filtering data and adding parameters to a report

So we've started grouping together data in a couple of different ways-- matrixes and tables--but we haven't filtered anything yet. We haven't restricted the amount of rows we're bringing back from the database from any of these tables, so let's do that now. Creating a new report. You should be getting familiar with this general process. We first need the data source. And I do this multiple times because it is a good idea to start to get very familiar with the different things you're asked for every time you create a data source. We will get into sharing them a little more further down the line.

So I'll connect to my SQL 2012 Server and go to AdventureWorksLT. It doesn't really matter which one I'm going to; I just need some data to play with. Back into Datasets, let's add a new one. I could be descriptive with this. I want to show products, but not just all products, products by category. The name of course does nothing special, but it will allow us t...

Filtering data and adding parameters to a report
Video duration: 5m 35s 3h 44m Advanced

Viewers:

Filtering data and adding parameters to a report means you are setting limits on how many rows of useful data you bring out of your SQL Server database. This training video helps you learn how to go into a dataset and tell the server what information you need, as well as how to narrow that information into a usable dataset for a report.

Subjects:
Developer IT
Software:
SQL Server
Author:
please wait ...