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
7
votes
1 answer
Show or Hide SSRS column based on specific parameter value
I am having trouble showing/hiding a column based on parameter value chosen.
How my report is set up:
Parameter: ImportStatus --ImportStatus parameter has three values you can choose from: M, V, E
If I choose ImportStatus value = 'M', then I want…
NonProgrammer
- 1,337
- 2
- 23
- 53
7
votes
2 answers
How to display yesterdays date in SSRS expression
In one of the column name, I need to display yesterday's date like - September 4,2014
I used DateAdd("d",-1,Today()) function to display,but it is displaying like - 9/4/2014 12:00:00 AM.
How can i get the above format like - monthname,dd,YYYY ?
SqlLearner
- 763
- 8
- 23
- 37
6
votes
1 answer
Expression to remove carriage return in SSRS
I am struggling to get an expression to work in SSRS.
I have an address block stored in an Oracle database with carriage return characters.
An example is the data stored in the database is:
123 Anywhere…
Jay P
- 71
- 1
- 4
6
votes
1 answer
What is the difference between Today() and Now() in SSRS?
Is there a difference between Today() and Now()?
When I searched online for date expressions I noticed that both are used quite frequently to retreive the same information. Which expression should I be using?
Today() and Now() in a report:
krynil
- 233
- 2
- 5
- 18
6
votes
1 answer
SSRS Row Number within table excluding hidden rows
I use the following expression to obtain a row number for a table in SSRS:
=RunningValue(CountDistinct("Table1"),Count,"Table1")
I also use an expression for the row visibility property. Lets just say that the Visibility expression…
Cooper Cripps
- 205
- 2
- 6
- 14
4
votes
1 answer
SSRS BIDS expression Show/Hide image based on passed through parameter
Is it possible to have an image available if a certain field is selected, in this case the parameter is @employeename, I only want the image that has been placed on the report to display if a certain value is true.
What is the syntax, field i am…
JsonStatham
- 9,770
- 27
- 100
- 181
4
votes
2 answers
SSRS. How to hide blank/empty column via expression?
I need to hide column if all rows in column is empty (blank).
In this case col3 should be hidden, because no values in column.
col1 col2 col3
v1 v4
v2
v3
I'm using following expression on columns Hidden property:
=IIF(Fields!Test5.Value =…
Stanislovas Kalašnikovas
- 9,203
- 4
- 32
- 59
4
votes
2 answers
Expression in SSRS not working as expected
I have an SSRS report which I want to sum values of a field, but only if the value of another field is equal to 1, as I have made the report output a row number for each row. Bascially, I'm trying to sum the distinct values to come up with a total.…
kyle_13
- 1,173
- 6
- 25
- 47
3
votes
2 answers
Filter member properties in Query Designer using MDX
How can I filter two member properties using MDX?
Currently I have the following solution. It works but I'm sure an MDX query would be much more efficient.
The Dataset in Query Designer has the following MDX to include the member properties as…
krynil
- 233
- 2
- 5
- 18
3
votes
1 answer
SSRS Dynamic Columns grand total required to be copied and use the same in another calculation
I am working on a matrix report where we need to calculate the Year to date variance between the last year and current year for each category group. Now I have generated the Grand total for the current year and previous year for each category. Now I…
Sandeep T
- 421
- 8
- 22
3
votes
2 answers
isnull in SSRS expressions
How to use this formula in ssrs-expression
=NOT(isnull({Command.AAID})) or NOT(isnull({Command.HDomain}))
or NOT(isnull({Command.Adomain}))
Thanks.
user3438498
- 211
- 3
- 11
- 21
3
votes
1 answer
SSRS Passing Parameters in an Action Expression based on contents of grid/cell
In my main table, I have a fairly complex query pulling 2 kinds of data and displaying them in one grid. Currently, if the user clicks on a value, they will be able to drill down into a breakdown of the data they clicked on. The problem is that I…
tvoytko
- 93
- 1
- 6
3
votes
2 answers
Add N/A if all fields are blank SSRS Expression
I have a number of fields in one column of my table. I have it if field1 is blank display field2 and so on, What i trying to do now is if all fields are blank display N/A.
What i have tried below;
=IFF(ISNothing(Fields!field1.Value) &…
AndroidAL
- 1,111
- 4
- 15
- 35
3
votes
2 answers
SSRS Expression To Remove Leading 0 In Date
My report displays the date time as "Friday, May 08, 2015" but I'd like to remove the 0 in the date field if the value is a single digit.
Should I use an expression to handle this? And if so, could I get some help on the expression?
Thanks,
MISNole
- 992
- 1
- 22
- 48
3
votes
1 answer
Hiding (or Displaying) Rows in SSRS Based off a Field Value
I'd like to only display certain rows on my report using SSRS if the field value of EMID=3 or EMID=Null. Or if it would be easier, to hide rows where EMID in (1,2)
I right + clicked the row -> Row Visibility -> Show or Hide Based on an Expression…
MISNole
- 992
- 1
- 22
- 48