From the course: SQL Server 2008 Essential Training

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Formatting values in reports

Formatting values in reports - SQL Server Tutorial

From the course: SQL Server 2008 Essential Training

Start my 1-month free trial

Formatting values in reports

I'm a big fan of an incremental approach to writing reports in Report Builder. Start slowly, get something working, and then add things to it. So right now we do have this report working and it's drawing information from three different tables, but there is a little bit I could do to this. Total Due is basically being output right now just as a money column. There is no currency formatting and it could do with some. I don't really need FirstName and LastName to be separated into two columns here. So I'm going to go back to the homepage of Reporting Services and then select the drop-down button to edit this in Report Builder. Changing the formatting of a report and changing the entire layout is very easy, even after you've saved it for the first time. So again, back to this report, selecting any of these cells here will highlight the field that we're using and allow us to tweak it, allow us to change the font, allow us to change the background color. However, some of the options can be…

Contents