How To Format Values In Reports In Sql Server 2008


show more Formatting values in reports provides you with in-depth training on Business. Taught by Simon Allardice as part of the SQL Server 2008 Essential Training show less
please wait ...

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 ...

Formatting values in reports
Video duration: 4m 17s 6h 54m Beginner

Viewers:

Formatting values in reports provides you with in-depth training on Business. Taught by Simon Allardice as part of the SQL Server 2008 Essential Training

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