The string parameter allows for a text value to be input by a report consumer in a text box.


In addition to the to the common attributes available to all parameter types the following additional attributes are available:


  • Is Value Required
    • Defines whether a user must enter a field value before executing the report.  Click here to read more about the "Is Value Required" attribute.
  • Value
    • Assigns a default value to the field


Usage in SQL Command Text
A single variable will be declared as VARCHAR(MAX) in the auto-generated section and can be used as a standard SQL variable.  In the below example a string parameter with a programmatic name of "ReportName" has been added to the report and is utilized within the SQL as a LIKE clause to search on ReportName.

 
The generated SQL when executing a report containing a string parameter type is shown below: