Home  >  Blog  >   MSBI  > 

TextBox Properties in SSRS 2008

Rating: 5
  1. Share:
MSBI Articles

Working With TextBox Properties  

  • Each and every cell in a text box
  • The text box is having below properties

(a) fx Expression → here we write expressions to display the data according to the expression in the column

Ex:- party income increment by 121
Sol:-  rt click on selected column → In expression window → Set expression for: value → = fields! Party income value *12/100

The below options properties we use an expression

If you would like to become an SSRS (SQL Sercertified professional, then visit Mindmajix - A Global online training platform:"SSRS Training and Certification Course". This course will help you to achieve excellence in this domain.


Expression Items:
Expression Items

Statement:- Many reports
Date functions:- =Today () → displays current data
Adding months:- = Date Add (“D”, 6, today ())
= Date Add (“M”, 6, Today ())
= Date Add (“Y” 6, Today ())
Display year of the date:-  = year (today ())

String functions:

=fields! Party name. value & VBCRLF → Enter char & Fields! Partyloc.val
Length of a string:
= LEN (Fields! Party name.value)
=right (fields! Party name.value, len (fields ! party name.value)

-(Inser(Fields! Part name.value, “”))

EG:- VINAY/HYD à o/p :- 9-6=3 of Right  i-e., HYD
=CSTR (Fields! Party name. value, “”) àIt converts into string (i.e, it changes the numeric value from one position to another position (i.e, left to right & vice versa)

Frequently Asked MSBI Interview Questions & Answers

Decision Expressions:

IIF:- IIF (condition. , )
SWITCH:-  SWITHC (condition, stmt1, cond2, stmt 2, cond.3, stmt3,
NOTHING:- It is NULL value in visual basic
Row Number:- Displays the row number of a row in the report

 MindMajix YouTube Channel

Report Functions:

SUM;-  It totals the values in grouping and data regions. This function can be useful in the header (or) footer in the table
=SUM (fields lines total.value, “party income”)

Page Header & Footer Functions:

a) Built in functions.
b) First / last / sum …Etc

Page Break Expression:

EG:- Required a page break for a group for every 25 rows
=INT (RowNumber (Nothing) -1) /25

Custom Code

We use this code in report by embedding the report (or) store in a custom assembly which is used in the report.

Custom functions:

There are many functions available in reporting services but still if we want to write a custom function we can write

EG:- Adding a function call get coloured and using it
Sol:- Report Menu à Report properties à CODEà
Public Function Get color (By VAL P code GS string) as string.
IF p Code = “10” then
Return “YELLOW”
IF p code = ‘20” then
Return “RED”
IF Pcode = “40” then
Return “Green”
END Function.
Go go color section ie., Expression in party code box
= code. Get color (fields! Party code. Value)

Related Page: How To Create Drill Down Report In SSRS 2008

TextBox Properties

a) General
Name: Partycode
Value: patycode
Tool tip → Options
b) Number → Here it set number and date formatting option
c) Alignment → Horizontal & vertical alignment with left and right  side padding options
d) Font
e) Border
f) Fill → It changes the background color, images …etc
Ex:- Displaying different background colors for different party code values
Sol:- IIF (fields! Party code. Value <=20, “red”, “Green”
g) Visibility
h) Interactive Sort: → It does interactive sorting on the column based on the user action
Click the option → enable interactive sort on this text box → detail row.
Sort by : party name
Click ok.

Explore SSRS Sample Resumes! Download & Edit, Get Noticed by Top Employers! Download Now!

List of Related Microsoft Certification Courses:

 SSIS  Power BI
 SSAS  SQL Server
 SharePoint  BizTalk Server
 Team Foundation Server  BizTalk Server Administrator


Join our newsletter

Stay updated with our newsletter, packed with Tutorials, Interview Questions, How-to's, Tips & Tricks, Latest Trends & Updates, and more ➤ Straight to your inbox!

Course Schedule
MSBI TrainingJun 03 to Jun 18
MSBI TrainingJun 06 to Jun 21
MSBI TrainingJun 10 to Jun 25
MSBI TrainingJun 13 to Jun 28
Last updated: 30 May 2023
About Author
Remy Sharp
Ravindra Savaram

Ravindra Savaram is a Content Lead at Mindmajix.com. His passion lies in writing articles on the most popular IT platforms including Machine learning, DevOps, Data Science, Artificial Intelligence, RPA, Deep Learning, and so on. You can stay up to date on all these technologies by following him on LinkedIn and Twitter.

Recommended Courses

1 /15