In this article, we learn about expression and text box property.
TEXT BOX PROPERTY
- Text box properties use to UI behavior. By using text box property we can change Font, Background color, Border, Fill, etc.
- In the SSRS report, We can change the background color and font color. Right-click on a column and goto text box property.
- In the Font option, we change the font, style color and so on.
- In the Fill option, we can change background color and image. We apply the same functionality to the remaining column.
- In the preview tab, we can view the project else we can run the project.
EXPRESSION
- The expression has the readymade formula. An expression is a value which evaluates the data which is display on a textbox.
- By using expression we display the sum of amount and this amount if greater than 20000 is shown in Green color otherwise shown as Red color.
- SSRS provides a toolbox that contains a Text box, Line, Maps, Charts, etc. Firstly drag and drop textbox in the Design view. Right-click on the textbox and select Expression.
- We set expression for the sum amount. In the Dataset if we double click on a value it sets the expression as we want.
- Again we right-click on textbox but here we select the textbox property. here we select Font because we want the font in a color. Goto fx option.
- Then we set expression for color and click on ok.
- Here the amount is greater than 20000 hence it shown in Green color.
- Here the amount is less than 20000 hence it shown in Red color.
- Now we add a column and that column displays the running date as well a total of the amount.
- Firstly we add a column. Rightclick on the Amount column click on Insert Column left or right.
- After adding column we set the background color in the Fill option as well set the expression.
- For better understanding, we insert another customer that is Ria. The total column displays the total amount.
Start with MSBI video as mentioned below to learn topic practically in-depth:
