官术网_书友最值得收藏!

Expressions in layouts

Expression is an interesting capability that SSRS supports. They can be used not just in expressions but in every possible property that needs customization at run-time. This recipe will get us introduced to expressions, by implementing the most interesting feature of printing the alternate lines in different colors. We will use the layout template created in the previous recipe to implement this.

How to do it…

Expressions can be implemented in the report, as follows:

  1. On the template, select the node DetailRowStyle | FieldValueStyle.
  2. For the Background Color property, choose the Expression list:
  3. The expression window opens.
  4. Type the following expression in the expression window:
    =iif(RowNumber(Nothing)mod 3, "#e0e0e0", "#ffe0c0")
  5. Save the template and go back to the PktCustTransList report for a preview.
  6. The report should now appear with a different color on every third line when previewed.

How it works…

Expressions are powerful means through which you can manipulate the content and the formatting style of the report data. These are widely used across the report model to retrieve, calculate, display, group, sort, filter, parameterize, and format data. They are not just limited to the ones listed but apply to many properties. A precise definition would be that anywhere in the report if a drop-down list displays <Expression…> then expressions can be applied.

It creates a wide scope for manipulation, by providing access to the standard functions, data methods, fields, labels, and more. This can be compared to an Excel cell where a formula is evaluated to produce the data. Expressions are evaluated when the report is run, so the results can be seen through preview.

Here are a few sample expressions:

Expression syntax is based on Visual Basic and any syntax error is highlighted by a red color in the expression window. To know more about expressions, please refer http://msdn.microsoft.com/en-us/library/dd220516.aspx.

Tip

Many novice report designers tend to use the IIF() function to test the parameter expression for a True or False result, and then explicitly return a True or False result from the function. Since all expressions can return Boolean results, although this technique will work, it's redundant to use the IIF() function for this purpose. For example, the following expression could be used in place of the previous example:

=IIF(Parameters!ShowQuantity.Value = True, False, True)

The following example would be used to test the result of a non-Boolean value. By wrapping an expression containing a comparison operator in parentheses, we can cause the expression to return a Boolean result.

=(Parameters!ReportView.Label="Retail")
主站蜘蛛池模板: 灵山县| 晴隆县| 隆化县| 绥棱县| 曲周县| 广安市| 崇仁县| 原平市| 万年县| 仁布县| 多伦县| 中卫市| 湛江市| 绥棱县| 彭州市| 黄浦区| 宝鸡市| 桃源县| 汉沽区| 伊川县| 天门市| 东乌| 建昌县| 绥阳县| 庆元县| 泗水县| 洪江市| 郸城县| 襄樊市| 乐业县| 延川县| 吉木乃县| 平和县| 静海县| 扎囊县| 盐山县| 布尔津县| 牟定县| 清远市| 和田县| 桂东县|