TextBox Properties in SSRS 2008

Working With TextBox Properties

Each and every cell in a text box
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
i.e.,

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)

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

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”
END IF
IF p code = ‘20” then
Return “RED”
END IF
IF Pcode = “40” then
Return “Green”
END IF
END Function.
Go go color section ie., Expression in party code box
= code. Get color (fields! Party code. Value)