Setting an SSRS report title

As it exists at this point, the report title for our example refers to a non-existent report parameter called ReportName. We must change this to refer to a parameter that will correctly define the report title we want to use.

Note: Before doing this procedure, it would be a good idea to create the name string (fUserTaskReport) for the new report title. This allows you, in the Expressions Editor, to select the string from a list. To do this, while in Design Mode, from the Edit menu, select String and use the Strings dialog box to create the string.

To set the SSRS report title parameter:

  1. Change the report title element reference:
    1. In the UserTask.rdl [Design] workspace view, click to select the placeholder element in the upper left corner of the report.
      This placeholder element is displayed as [@ReportName].
    2. In the Properties sheet for this element, locate the General > Value field, which should display as: =Parameters!ReportName.Value
    3. Change this value to: =Parameters!fUserTaskReport.Value
      The report title now displays in the Design workspace view as [@fUserTaskReport].
  2. Create the report parameter to associate with the reference:
    1. In the Report Data panel, right-click Parameters and then select Add Parameter.
    2. In the Report Parameter Properties dialog box, set the general properties like this:
      • Name: fUserTaskReport
      • Prompt: fUserTaskReport_
        Note: The trailing underscore (_) is required for translatable string parameters.
      • Data type: Leave as Text
    3. On the Default Values tab, select Specify values.
    4. Click Add.
    5. In the Value field, specify fUserTaskReport.
    6. Click OK.
      Visual Studio adds fUserTaskReport to the list of available Parameters.