Top "Ssrs-expression" questions

To set expression in SSRS Report.

Report Builder 3.0 SWITCH expression DEFAULT/ELSE

I am trying to display a different logo based on the users franchise number. Parameter = UserFranNr If the value <&…

reporting-services expression reporting reportbuilder3.0 ssrs-expression
SSRS Formula or expression to change NaN to 0

I am using the following expression to work out a percentage: =Fields!Days.Value/Sum(Fields!Days.Value, "Date_month_…

reporting-services expression nan ssrs-expression iif-function
WHERE clause in SSRS expression

What's the syntax for inserting a WHERE clause in an SSRS expression? I am using BIDS 2008. =Sum(Fields!QuantityToShip.Value) …

ssrs-2008 where-clause ssrs-expression stackedbarseries
convert integer value to string and if it fails set "##" - SSRS

I have below line in crystal report formula, It means that if string conversion failed it will print ##. CStr({rptReport;1.…

reporting-services ssrs-expression
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,…

reporting-services ssrs-2008 ssrs-grouping ssrs-expression
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: …

reporting-services parameters ssrs-2008 ssrs-expression
How to set visibility expression in SSRS?

I am using SSRS 2008 with a tablix. I want to make one of my rows visible, when field value = 1 and …

tsql ssrs-2008 visibility ssrs-expression
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, …

reporting-services ssrs-2008 ssrs-2012 ssrs-expression
Using AND in Switch Expression in SSRS 2008

Below is my code I use in the Color Expression in SSRS 2008 to change the color of the text. =Switch(…

reporting-services switch-statement ssrs-2008 ssrs-expression
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") …

reporting-services expression hidden row-number ssrs-expression