Stack Overflow
Stack Overflow

Questions tagged [ssrs-expression]

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.

225 questions
0
votes
1 answer

SSRS reporting using labels in expressions

I am trying to produce a table - a count of responders by gender and site ID. Instead of getting Site_ID out as 1, 2, 3 and Gender as 0, 1 on the graph I'm trying to recode Gender as Male / Female and Site_ID as Site 1, Site 2, Site 3, etc. How can…
user3569565
  • 1
  • 1
0
votes
1 answer

IF IS nothing then count

I want to create statement such as =IIf(IsNothing(Fields!Amount.Value)),0,(Sum(Fields!Amount.Value)/1) but from some reason it does not work. It should check value if it is null. If it's null, just enter 0, if it is not null, just make the…
DNac
  • 2,663
  • 8
  • 31
  • 54
0
votes
1 answer

SSRS expression giving error with iif condition

I have this expression for a text box in a SSRS report =IIF((Fields!Spot.Value = True), "SPOT", MonthName(Fields!Codes_MonthFromIDfk.Value,true).ToUpper().ToString() & "-" &…
RookieAppler
  • 1,517
  • 5
  • 22
  • 58
0
votes
3 answers

WHERE clause in SSRS expression for max function

I have for example a query with return something as it route value 1 3 2 2 3 4 4 5 5 1 then I need to put in 2 textbox the max and the min route so in sql this would be select top 1 route from table where value=(select…
angel
  • 4,474
  • 12
  • 57
  • 89
0
votes
2 answers

Adding Fields into an expression in an SSRS 2008 report

Thank you in advance for taking your time to answer my question. I am having trouble with expressions in the SSRS reporting system. The Field I am adding required fields from the dataset I provided in the report, however when I try to preview the…
user2174391
  • 3
  • 1
  • 2
0
votes
1 answer

Convert average(decimal) into years, months and days

I have been doing some calculation and able to find my solution but I want to go back to convert my average(587.3) into years, months and days. I'm using (ssrs 2008) for reporting. I have my avg(Fields!XXX.Value)to calculate the average inside my…
makoz
  • 61
  • 1
  • 3
  • 13
0
votes
1 answer

SUM based on boolean range

I really need help summing values based on a range (in an SSRS expression). I have a dataset that pulls accounts and money values. SELECT acct, location, amt FROM Table I need help creating an expression for a tablix. I'd like to sum the amt values…
dp3
  • 1,607
  • 4
  • 19
  • 28
0
votes
3 answers

SSRS Variable Expression - Sum, Sum, Scope?

I'm trying to write an expression for a variable (not parameter), so that I can use/reference it to do a calculation in another textbox. I have multiple datasets, and I need the SUM(SUM(Fields!amount.Value)) for each of these datasets. I am then…
dp3
  • 1,607
  • 4
  • 19
  • 28
0
votes
2 answers

SSRS Creating an Expression with unkown column names

I have a stored procedure that returns three columns worth of data to our SSRS report. The stored procedure does not alias two of those columns, so they are returned unnamed. Here is an example of what the return dataset might look like: [FundName] …
StoriKnow
  • 5,738
  • 6
  • 37
  • 46
-1
votes
1 answer

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, 30000, 40000, 60000 depending on the value in…
GandalfTheFoolish
  • 3
  • 4
-1
votes
1 answer

Nested IIF in SSRS Expressions

Is this correct syntax for nested IIF ? Do I need to use Switch ? ... = IIF ( Fields!FUN.Value.IndexOf ("GU") OR Fields!FUN.Value.IndexOf("HA") ,IIF (Fields!JobType = "min" ,IIF(Fields!Van > 0 , IIF(Fields!Complete.Value >…
Swara
  • 15
  • 7
-1
votes
1 answer

Parameter filter SSRS Expression Dataset

I have a dataset created from an expression that takes parameters from 3 other datasets. I need to add a parameter to this that allows the user to input a value, and then the dataset will add that value to the where clause to filter the results…
user1949329
  • 207
  • 1
  • 2
  • 11
-1
votes
1 answer

Calculation in SSRS based on Parameter

I am trying to create a finance report based on date range parameters selected. There are 35 hours available each week. If a person selects 2 weeks in the date parameters we want to calculate 35*2 as total hours available. Is there a calculation…
Erin
  • 9
  • 5
-1
votes
1 answer

string format with JOIN inside SSRS expression

I am using an SSRS expression to format the result of a string like this based on a condition = IIf(my_condition,"All active items",JOIN (Parameters!SelectedBooks.label,"
")) This will make the resultant string comes on next lines…
Sebastian
  • 4,625
  • 17
  • 76
  • 145
-1
votes
3 answers

SSRS Count Record Based on Field Value (Status) in a Group

I have the data table below: --> Click here for the picture. I want to add new column and count how times an employee is present in the office something like this: --> Click here for the picture. How can I count it in expression given that I have…
dalday
  • 31
  • 1
  • 6
1 2 3
…
14
15