Questions tagged [ssrs-expression]
To set expression in SSRS Report. SSRS-Expressions are frequently used in SSRS Reports to control content and report appearance.
ssrs-expression
225
questions
0
votes
1
answer
172
views
How come SSRS Contains or Like Expression not working?
I'm using MS Power BI Report Builder, and I'm having trouble getting the "Contain" function to work with an IF statement. I was wondering if anyone could help me figure out what's wrong with ...
- 41
-1
votes
2
answers
186
views
Dynamically assign Dollar and percent sign to the Column value in SSRS expression
I have a column with the below sample data coming from the table , I am loading this data to SSRS report. I have to fomat the data based on Type column, if the type is dollar in the report it should ...
- 1,023
1
vote
1
answer
87
views
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}/{...
- 27
0
votes
0
answers
287
views
SSRS Currency Format IIF Expression
I'm trying to format the text box properties based off an expression, I have a field 'currencyID' and I'm trying to get it to change from £ to € if the value doesn't equal 1. So far I've got this but ...
-1
votes
1
answer
768
views
SSRS multiple IF expressions (SSRS Version Of a SQL CASE)
I'm really struggling to write an SSRS Expression, due to various permissions issues on DB's I can't do it in SQL which would take a few seconds... I need a text box expression to show either 20000, ...
1
vote
2
answers
275
views
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
=(...
- 327
0
votes
1
answer
218
views
Report field to display correct error message in ssrs
I have a dropdown with parameters Student Name and Student Id. When I select Student Name a textbox appears as below and have the submit button:
enter image description here
On clicking Student ID the ...
- 1
0
votes
1
answer
786
views
SSRS Expression to Sum value IIF YearMonth = Parameter
I hope someone would be able to assist\help.
I have a Tablix that I'm trying to populate with three separate (summed) values (Current Month, Current Year and Previous Year) from one field based on a ...
- 3
0
votes
1
answer
544
views
RDLC Report - Ordering in date is not working
I am trying to implement ordering by date in rdlc report. The data is filtered on the basis of from date and to date. I have also added header on the top of the report as 'Month Name' Details(e.g. Nov ...
1
vote
0
answers
112
views
(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 ...
- 11
0
votes
1
answer
2k
views
RDLC report - Duplicate data issue in grouping
I have a RDLC report in which I want grouping by username and status which has value open and closed. I am getting duplicate username when both the value of status is present for the username.
In the ...
0
votes
1
answer
655
views
SSRS Expression Split string in rows and column
I am working with SQL Server 2008 Report service. I have to try to split string values in different columns in same row in expression but I can't get the excepted output. I have provided input and ...
- 61
0
votes
1
answer
74
views
SSRS Expression "Count of Days with No dissatisfied Customers" Cannot get it working
I have to get a expression in my SSRS table that achieves the count of days with no dissatisfied customers.
Right now I have an expression like this:
=RunningValue(IIF(Fields!SATISFACTION_LEVEL.Value &...
- 1
0
votes
1
answer
614
views
SSRS report multiple concatenate
I'm trying to join two data sets in my SSRS table report. The problem is that I can only concatenate two columns in my lookup statement. The third is being ignored. I need to do more than two. how can ...
- 29
2
votes
1
answer
5k
views
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 ...
- 25