CHAPTER 13 CREATING REPORTS USING REPORT BUILDER 1.0, 2.0, AND 3.0You will want to resize the cells in the Matrix so that the Service_Type records do not wrap. If you
click the View tab, there is a selection for Ruler. Click the Ruler button and size the Service_Type cell to
be two inches. Before running the report, let’s change all of the parameters to allow NULL values. To set
the parameters to accept NULL values, simply double click the parameters and enable the checkbox
labeled Allow null value. You can see the previewed report taking shape (Figure 13-56) by clicking the
Preview button, available on the Home and View tabs.
Note You may have to set the parameters to allow NULL values in your report if you do not want to have to
enter parameter values. By default, if the parameter value is allowed NULL values, the report will generate with all
data returned from the execution of the stored procedure.
Figure 13-56. Preview of Report Builder 2.0 report