Creating reports with a table data region
It's time to create your first report. The most basic of all reports is the table report. This is a row-by-row listing of information. In the process, we'll learn much about the SSDT report interface, including how to use many of the windows within SSDT.
Getting ready...
Before writing any reports, we first need a data source. With SQL Server 2016, Microsoft introduced an entirely new set of sample databases named Wide World Importers. You can find the announcement, along with download links, on the Microsoft website at
https://blogs.technet.microsoft.com/dataplatforminsider/2016/06/09/wideworldimporters-the-new-sql-server-sample-database/
. If you find that a lot to type, you can use the shortcut,
http://bit.ly/packtwwi
. Note that with bit.ly
, the URL is case sensitive, so be sure to enter it precisely as shown.
The Wide World Importers, samples actually contain two databases, WideWorldImporters
and WideWorldImportersDW
. The first is...