From the course: SQL Server: Reporting Services
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Sort records in a table - SQL Server Tutorial
From the course: SQL Server: Reporting Services
Sort records in a table
You might have noticed that the reports that I've built so far have all displayed records in a seemingly random order. Here in the Sales Summary report, my month values are all scrambled up. And if I had pressed the back button to go back to the report where we need to select the year, these year values are out of sequence as well. The order that the records or the report display in is dictated by the index as in storage of the data back in the original database unless we specify otherwise in the design of the report. Because our data set queries don't include an order by clause when we're pulling the data out, we need to tell the table objects how we want the records sorted. To fix up these reports we need to first open them up in Report Builder. Let's start with the Year Report. Then I'm going to select the table and press the button here in the upper left hand corner or press the Escape key on your keyboard to switch over to the Tablets Properties. Next I'll click on the Properties…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.