Summary of SQL Server reporting services development skills

[Expression]

1. Truncation
= IIF (LEN (Fields! Coursewarename. Value)> 10, left (Fields! Coursewarename. Value, 10), Fields! Coursewarename. value)

 

2. line-by-line color change
= IIF (rownumber (nothing) mod 2, "# fffbe9", "White ")

 

3. Convert your number to text
= Code. expandprice (Fields! Amount. value ,".")

 

4. Extract the IP address or server name
= Mid (globals! Reportserverurl, 8, instr (9, globals! Reportserverurl, "/")-8)

 

5. If you want to display 20 rows on each page, add a group to your report. It has the following expression. Select page break at the end option for the group.
= Int (rownumber (nothing)-1)/20)

 

6. Implementation: Expression of the structure percentage of the value:
Value = IIF (sum (Fields! Ed. value, "projectname") = 0, 0, sum (Fields! Ed. Value)/sum (Fields! Ed. value, "projectname "))

 

7. Implementation: When the value is 0, it is not displayed (white). If the value is smaller than 0, it is red; otherwise, it is black.
Color = IIF (sum (Fields! Ed. Value) = 0, "White", IIF (sum (Fields! Ed. Value) <0, "Red", "black "))

 

8.:Set row numberRownumber

Set the expression content of the cell to display the row number:= Rownumber (nothing)Note:NothingIndicates a dataset or group.NothingIs the default value of the dataset.

 

[Report url]

 

The report URL contains the Web server name, the virtual directory name of the Report Server, and the fully qualified report name. (The fully qualified name contains the report path and uses the report's

The name ends .)

For example: http: // server/virtualroot? % 5B/pathinfo % 5d & Prefix: Param = Value % 5B & Prefix: Param = Value % 5D... n]

Common prefixes and parameter names:

1. RC: toolbar = true/false display/do not show Toolbar

2. RS: command = render: present the report

3. RS: format = pdf (Doc, XLS) Export report format

4. RC: parameters = true/false display/do not show the parameter selection area of the toolbar

5. @ parameter = value directly transmits the parameter value