To set expression in SSRS Report. SSRS-Expressions are frequently used in SSRS Reports to control content and report appearance.
By this tag, user can get specific answer to SSRS Expression. It can help to solve SSRS Report Error/Issue.
Questions tagged [ssrs-expression]
225 questions
1
vote
1 answer
I need to convert this Crystal formula into SSRS Expression:
select {t_item_master.reorder_qty}
case 5:
({t_hu_detail.loaded_qty}*.5)
case 3:
ROUND({t_hu_detail.loaded_qty}/{t_item_master.reorder_qty}+.17)
case 4:
ROUND({t_hu_detail.loaded_qty}/{t_item_master.reorder_qty}+.25)
case 6:
…
Richa Bharti
- 27
- 2
1
vote
2 answers
Sum Fields in SSRS
I have two cloumns in ssrs
1. Column10
Expression(column1 + column2 + column 3)
2. Column11
Expression(column4 + column5 + column 6)
Now I want to subtract column 11 from column 10
I am doing now
=(Fields!column1.Value) + (Fields!column2.Value) +
…
Virender Thakur
- 327
- 3
- 12
1
vote
0 answers
(SSRS v.15) How do I obtain a group's each individual totals outside of the group?
My query includes 4 groups. Category > Type > Activity > Nature > detailPrice.
I have the report built with 4 different List Items stacked into each other. Each list is one of the four groups. The detailPrice is a table (pink).Each of the 4 groups…
snowyphoenix
- 7
- 1
1
vote
1 answer
Bold Specific Values in Expression in SSRS
I'm trying to make multiple values "Bold" within an expression when the value contains "x". Html Placeholder properties doesn't meet my need and I'm struggling to get it working with the below as there are multiple statements in my…
DHorse1984
- 15
- 1
- 4
1
vote
1 answer
LAST WHERE clause in SSRS expression
For the visibility of some fields, i want to check if a field has a specific value.
Right now i'm using this visibility expression:
=IIF (Sum(IIF(Fields!TagName.Value = "Option1" , Fields!Val.Value, 0), "ParamDataset") > 0, true, false)
If option1…
Seb
- 839
- 8
- 13
1
vote
1 answer
how to calculate Average of hour and Minutes in SSRS report
How can i caluculate average HH:MM in SSRS Report.I am getting data with below query
select O.ORDERNUM, Cast(DateAdd(s, AVG(CAST(DateDiff( s, '00:00', cast(DROPTIME as time(0))) AS INT)), '00:00' ) as Time(0)) AS ATIME
FROM ORDE_…
A.Goutam
- 3,422
- 9
- 42
- 90
1
vote
1 answer
SSRS expression IIF() and sum
I have this error message that pops up when trying to run a report. It is a SSRS Report for Dynamics AX 2012.
System.Web.Services.Protocols.SoapException: The Visibility.Hidden expression for the text box ‘Textbox183’ has a scope parameter that is…
LD9
- 11
- 2
1
vote
2 answers
How can I get From a SSRS DataSet Row the Value Where Condition is True
I have a DataSet called Reporting that include TagName, Value and DateTime.
Now my question: In my SSRS Report I have a TextBox where I want the Value of a TagName.
For Example: I have TagName called: "TT101" with the Value 21.
So my TextBox should…
Darren G
- 193
- 2
- 9
1
vote
3 answers
Conditional Formatting a textbox
I'm using ReportBuilder
Below is an expression to change the background color based on a value in a cell. I would like to add a new condition to the existing expression to change textbox22 if it has 'N/A' in it to Light Green …
Clem_Fandango
- 254
- 2
- 18
1
vote
1 answer
Date format in SSRS Expression
I am trying to change the date format for one of my field to dd/MM/yyyy but every time I used the below expression I get dd/MM/yyyy as the value in the cell instead of changing the format.
The data source that I am using is Teradata.
Expression…
Priyanka2304
- 200
- 3
- 16
1
vote
2 answers
Replacing an output in SSRS with another value
I have a table with 2 columns, TutorInitials and TargetGrade. Where a user does not have a grade, we need to replace it with the grade given to a different user. e.g:
TutorInitials TargetGrade
1 A
2 B
3
4 …
Rob
- 59
- 8
1
vote
1 answer
In SSRS, how to include first row from different dataset in tablix?
I am creating a report, the purpose of which is to print a letter to many different people. Obviously each person's name, email, etc. will be different. For this I am using a list, which I understand uses a tablix.
Now inside each letter I also need…
Grant W
- 27
- 6
1
vote
1 answer
Report Builder not showing IIF result
I'm trying to modify a Report Builder report (Visual Studio 2013) and it's not displaying four expressions. The following field is coded like this and works just great!
=First(Microsoft.VisualBasic.Interaction.IIF(Fields!ISPASS.Value = "Y", "YES",…
Craig
- 175
- 1
- 3
- 18
1
vote
2 answers
SSRS Reporting Expression to Split Full Name Field
I've been trying to get this to behave with no luck.
The database base field only has FULL NAME field, which includes Middle initials on some cases and no middle initials in some other cases.
I've been trying to display LastName, FirstName by using…
user3571153
- 129
- 1
- 9
1
vote
3 answers
SSRS Parse Date Error in SSRS Expression
Any idea why getting an #Error using the code below when the field fp_firstshifttimein does not contain value. But when the field contains value, it works.
=IIF(IsDate(Fields!fp_firstshifttimein.Value),…
dalday
- 31
- 1
- 6