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: Expression with IIF in Join throws error

I have a field with below expression: =join(iif(Parameters!FUP_Letter.Value = 1, "Yes", "No"), ", ") When the report is loaded the field only says '#Error' instead of 'Yes, No', 'Yes' or 'No' When I remove the IIF clause from this expression the…
Gravinco
  • 687
  • 1
  • 9
  • 28
0
votes
1 answer

SSRS IIF statements expressions for conditional date formatting (BETWEEN)

I want to do a conditional format on date ranges. So if the date begin/end range (selected in the parameters @Begin and @End) is between 5 and 7 days, display "week", if between 28 days and 31 days, display "Month", everything else, show "X days",…
dragonfury
  • 5
  • 3
0
votes
1 answer

SSRS. Specify dynamic links to reports via expression

I'm creating report with Visual Studio 2013. Here will be 1 report with links to other reports. Report with links to other reports have following design: [Name] [Description] [Instances_Count] I need to make [Name] clickable (add action on It with…
Stanislovas Kalašnikovas
  • 9,203
  • 4
  • 32
  • 59
0
votes
1 answer

SSRS. Specify IF, in expression, to choose month correctly

I have expression on Text Box that after StartDate selected It type some text. It working normally, except 1 month of the years is selected It throws an error. I need to specify something like that IF month = 1 then years = -1 month = 12. For now my…
Stanislovas Kalašnikovas
  • 9,203
  • 4
  • 32
  • 59
0
votes
1 answer

Background Color Not Filling in Entire Row Based off Expression in SSRS

I was hoping I could get some help on this issue. Got a report that displays data for events; of which we have two types: fixed and mobile. To fill in the row based off what type the event is, I used this expression: =IIF(Fields!OwnerType.Value =…
MISNole
  • 992
  • 1
  • 22
  • 48
0
votes
1 answer

Adding Two Subtotals in SSRS to Another Cell

I've got a report that I want to sum some of the columns and then do some basic subtraction on the summations on a row underneath. In my screenshot, I've got the columns summing correctly, and the row is hidden which is what I'm looking for. But…
MISNole
  • 992
  • 1
  • 22
  • 48
0
votes
1 answer

Using Expression to Hide Certain Data in SSRS

I'm trying to hide/suppress data using an expression for Row Visibility in SSRS. I currently have an expression: =IIF(CInt(Fields!EM_ET.Value)=1 Or CInt(Fields!EM_ET.Value)= 2,True,False) That hides certain data I do not want to appear, but I would…
MISNole
  • 992
  • 1
  • 22
  • 48
0
votes
1 answer

Displaying Record Once in SSRS Table

I've created a table from a procedure that will display a summary of all incentives from a given collection operation or recruiter in my report. But if the collection operation or recruiter has multiple incentives assigned to their drives during the…
MISNole
  • 992
  • 1
  • 22
  • 48
0
votes
1 answer

SSRS Expression still returns a count for all fields

Would anyone be able to help me with my SSRS expression? It seems to be returning a count for all records even though I have certain requirements in my iif function. Here is what I currently have: =Count(Iif((Fields!METHOD.Value = "Something") AND…
scapegoat17
  • 5,509
  • 14
  • 55
  • 90
0
votes
1 answer

Combining Two Address Fields in SSRS w/ Expression

I'm trying to combine two fields into one text box in SSRS through an expression. If an address does have two entries, I'd like a line break between Addr1 and Addr2. What I have currently is: =Fields!Addr1.Value & VbCRLF & Fields!Addr2.Value But…
MISNole
  • 992
  • 1
  • 22
  • 48
0
votes
1 answer

SSRS 2008 R2 name field formatting it correctly

In one of my reports a name field is bringing through people's names as: john.smith I have added =StrConv(Fields!name.value,vbProperCase). This now brings them through as John.Smith, which is better, but is there a way of removing the full stop…
Will F
  • 417
  • 2
  • 6
  • 17
0
votes
1 answer

Combining an IIF statement with correct capitalisation - SSRS 2008R2

Any advice appreciated please. In many of our reports, some text comes through in upper case, eg a name as: JOHN SMITH Or in lower case - john smith Is there any code / an expression we can use to allow regular capitalisation, so the data always…
Will F
  • 417
  • 2
  • 6
  • 17
0
votes
1 answer

IIF Expression in SSRS 2008R2

I have written an IIF statement: =IIF(fields!addressline1.Value< ",", "No Details", Fields!addressline1.Value) This works fine in that it returns 'no details' if the addressline1 value is blank. However, I would also like to add…
Will F
  • 417
  • 2
  • 6
  • 17
0
votes
1 answer

Calculating Median - Report Builder 3 - SSRS - "Median=0" - What is wrong with my code?

These are my datasets: Average Cost column and expression This is my Median column and expression Details Group Property variables and expression Code that I am using to TRY and calculate the median These are the results. The Median is always…
QuestionQuestion
  • 37
  • 1
  • 9
0
votes
1 answer

What are the asterisks in quotes doing in this VB function for a textbox expression in SSRS?

This changes the decimal places displayed on a percentage in a textbox. Can someone help me break it down and explain the asterisks? Thanks. =IIF((ReportItems!Textbox68.Value > 1 and ReportItems!Textbox68.Value < 2), "*", …
Mike Canner
  • 119
  • 2
  • 9
1 2 3
…
14
15