SSRS Dynamic Boundaries

Question

I have the following output bound to the SSRS table:

ID    Name            Value

1     Assets           100
2     Liabilities      200
3     Expenses         300
4     Loans            400
5     TOTAL           1000

For the last line (TOTAL), which is the total sum of the above lines, as well as part of the result, I want to set the border conditionally as follows:

• Upper bound: dotted
• Lower bound: double puncture

The last line in the report should look something like this:

----------------
TOTAL   1000
================

Rate your entries.

Answer 1

Unfortunately, SSRS does not have a double option, but you can use conditional formatting in the text box to control the border.

With your data:

I have a simple table:

, , Name:

Top:

=IIf(Fields!Name.Value = "TOTAL", "Dashed", "None")

:

=IIf(Fields!Name.Value = "TOTAL", "Double", "None")

( ) :

, , MSDN:

Double Line Reporting Service

, 3pt , Preview. Excel .