(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.
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 ())
=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)
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
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
We use this code in report by embedding the report (or) store in a custom assembly which is used in the report.
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
IF p code = ‘20” then
IF Pcode = “40” then
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
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
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”
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
Explore SSRS Sample Resumes! Download & Edit, Get Noticed by Top Employers! Download Now!
|SCCM||SQL Server DBA|
|Team Foundation Server||BizTalk Server Administrator|
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.