Multimedia Library

rss All Multimedia (92) Gallery (31) Video (61)
Jun 25, 2014
Education

Session 3: Enhancing Reports with Interactive Features  

Running Time: 59 minutes | For users who access and view reports online most of the time, you can add interactive features to make it easier for them to use your reports. In this session, you'll learn how to allow the user to change the sort order of data, add tooltips, or make it possible to expand and collapse sections of your report. You'll also learn how to employ navigation aids to help the user easily move to information located in the same report or to access information contained in a related report or web page. For users who regularly print or export reports as PDF documents, you'll learn how the structure of a page depends on rendering and how to use various report properties that influence the layout of items on a page and pagination....More
Jun 25, 2014
Education

Session 1: Developing Reports  

Running Time: 65 minutes | In this session, you'll learn a variety of report development techniques that take advantage of the rich set of features available in Reporting Services. You'll start by learning how to work with report server projects in SQL Server Data Tools and how to manage report server project files and properties. Then you'll learn all the data source types you can use to display data in your report, how to connect to these data source types by creating data sources, and how to design queries for these data source types to create datasets. Next, you'll learn how to work with each type of report item, how to configure properties to control appearance and behavior of each report item, and how to work with properties specific to the tablix. Last, you'll learn how to enhance reports by adding calculations and using expressions to change properties dynamically....More
Jun 25, 2014
Education

Session 2: Visualizing Data  

Running Time: 57 minutes | Reporting Services includes a wide variety of options for displaying information as a data visualization. This session begins by describing how to work with chart controls and how to apply basic formatting to charts. A key performance indicator is a special type of data visualization that you can add to a report to monitor progress to goals. This session shows you the many options available for using a gauge as a key performance indicator and also how to use the indicator report item. In addition, you'll learn about working with spatial data in general, how to use the map wizard to create a map, and how to fine-tune the appearance of a map by configuring properties for the map....More

Digital Magazine Archives

Browse back issues of SQL Server Pro, from January 2007 through the last issue published in April 2014. Find the back issues here.

 

From the Blogs
business people around a table and laptop
Oct 9, 2014
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 10: Dynamic Detection Gotcha #3

You can interject a SQL Server Job Step into your Jobs and have this new/injected Job Step do some checking for you. Here's a look at everything that’s involved in such an approach....More
Man holding a piece of paper with the word GOTCHA
Oct 7, 2014
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 9: Dynamic Detection Gotcha #2 3

Given that a USE statement is parsed before code is actually run, there are a few options that could be used as a around when it comes to detecting whether or not code should be run....More
iceberg
Oct 2, 2014
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 8: Dynamic Detection Gotcha #1 1

Learn about why the option of dynamically detecting whether or not to run a SQL Server Job at execution time is quite a bit more problematic than you might think....More
SQL Server Pro Forums

Get answers to questions, share tips, and engage with the SQL Server community in our Forums.

Sponsored Introduction Continue on to (or wait seconds) ×