CHAPTER 6 BUILDING REPORTS
Figure 6-14. Employee Listing report with hyperlink actionsAdditionally, when using dates, the default format includes the date and time values, even if there is
no time associated with the date. The hire date might look like this, for example: 10/20/2003 12:00:00
AM. By right clicking and selecting the Textbox Properties of the Hire Date cell, you can change the
format from the default to a more standard format. Change the format under the Number tab to
MM/DD/YYYY format, such as 10/20/2011, excluding any time value. The format code for this date is d
or you can enter MM/dd/yyyy.
Next, because you are returning detail records, with more than one per employee, you need to
group the detail row itself using the value of the Employee Name field. You can do this by right-clicking
the detail row grouping in the Row Groups area and selecting Group Properties. In the Group On
expression field, add the same trimmed employee name as shown in the previous code line. Now, when
you preview the report, you have your list of employees to which you can add hyperlink actions. Finally,
force a page break after this table so you can add a detailed table that will be used as a bookmark link. To
add a page break to a report, simply select the tablix, then right-click a column to get to the table
properties, as shown in Figure 6-15. On the General tab, select Add a Page Break After.