Command: GetRptParams

 

List parameters of a report.

 

SSRS Version:

 

2000, 2005 (N), 2005 (I), 2008 (N), 2008 (I),2008r2(N), 2008r2(I), 2012(N), 2012(I), Azure

 

(N)=Native

(I)=Integrated

 

 

Syntax

 

 getRptParams  Report|Folder [/D][/S]

 

Parameters

 

 [/D]        Detailed information about parameters

 [/S]        Sub folder.

 

 

Examples

 

 

List the report parameters for the report global sales

 

getRptParams "global sales"

 

 

List the report parameters for all reports in the sales folder

 

getRptParams sales

 

 

sample output:

 

 

Report: Global sales

Path:   \

 

------|----------|-------------|---------|-------|-----------------------

Allow | Nullable | Valid Value | Value   | Multi | Name

Blank |          | Query Based | Type    | Value |

------|----------|-------------|---------|-------|-----------------------

False | False    | False       | String  | False | Country

------|----------|-------------|---------|-------|-----------------------

 

 

 

 

List the report parameters for all reports in the sales folder and sub folders

 

getRptParams sales /s

 

 

Detailed parameter information for the global sales report.

 

getRptParams "global sales" /d

 

 

sample output

 

\>getrptparams "global sales" /d

 

Parameter Name:             Country

Parameter Prompt            Country

Parameter Type:             String

Allow Blank:                False

Nullable:                   False

Multivalue:                 False

Valid Values query based:   False

Default Values query based: False

State:                      MissingValidValue

 

 

Remarks

 

•

 

See Also

 

 

 GetRptParams        - Get report parameters

 SetRptParams        - Set report parameter value.