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
1
vote
2 answers

How can I compute and display a date range in an SSRS report field?

In the report I'm working on, the user enters a begin date and an end date. Typically, the two will span two weeks, such as if they enter 5/15/2016 for the begin date and 5/28/2016 for the end date. What I need to show in column headings are the…
B. Clay Shannon-B. Crow Raven
  • 8,547
  • 144
  • 472
  • 862
1
vote
2 answers

SSRS Expressions For end of week date

I need to use an SSRS expression to find two dates - The date that's the end of this week. The dates that's the start of the week, 2 weeks ago. For example, if today is 27/05/2016 1 = 29/05/2016 2 = 09/05/2016 This needs to be dynamic e.g.…
MJCookie
  • 135
  • 1
  • 3
  • 10
1
vote
2 answers

Cascading Parameters Refresh in SSRS Report for Date Selection

I'm using SSRS report. How to set another parameters default date based on first selected date. Please see the below image. Here, when I will select Date value as 02-01-16 I wanted to add 14days to this date and then I want to set this updated date…
Pedram
  • 6,256
  • 10
  • 65
  • 87
1
vote
2 answers

Disable go to report action for a text box if data is zero or nothing in SSRS

Description I want to disable links (Go to report action) when data is Zero or Nothing. I used below expression in go to Report section: =IIf(IsNothing(Fields!HighwayLampCounts.Value)=0, "rpt_Highway_Online_Koli_Detail","rptNoData") But, it…
Nahid
  • 95
  • 2
  • 9
1
vote
1 answer

Hide Tablix on Condition base in SSRS

I've one main report in which I have created two different Tablix. (Both have different dataset) My question is, How can I hide tablix on condition base in SSRS. For example: Parameters!First.Value="Y" then hide only first tablix and show second…
Pedram
  • 6,256
  • 10
  • 65
  • 87
1
vote
1 answer

SSRS expression on report

I have this expression in report but not display when I ran the report, no error. Can you help please. =iif(Parameters!daterange.Value = 10000, "As of: " & First(Fields!mindate.Value, "TopExecutedReports"), "") It's correct. Mistaken
user1203397
  • 67
  • 1
  • 2
  • 8
1
vote
2 answers

SSRS Switch with And Expression need help , the second condition is not true

I need a help on the below Expression, I've column A - Date, Column B- Yes/No , Column C - Date. Condition If Column B = Yes and Column A has a Date then text box in *Grey If Column A don't have Date, then check if Column C has date then if…
user2086122
  • 65
  • 4
  • 10
1
vote
1 answer

add 2 values together in an ssrs-expression

I'm looking to bring in my expression 2 values that I what to add together. =Sum(iif(Fields!Leadsource.Value = "set1", 1, 0) and (Fields!Leadsource.Value = "set", 1, 0)) but is just coming back as 0 when the value should be 400 or so. Can any one…
user5627259
1
vote
2 answers

difference between + and & in ssrs expression

I am working on SSRS Report. I have one question, what is the difference between + and & in ssrs-expression? Please share your answer with short example. Thanks.
Pedram
  • 6,256
  • 10
  • 65
  • 87
1
vote
1 answer

SSRS Count or Sum expression

I cannot work out why these Total expressions don't work... I am trying to add any cells that have a date later than today, with any cells that have "Not Reqd", and then divide that by the number of rows, to get a percentage. All I'm getting is…
ttratl
  • 21
  • 8
1
vote
1 answer

SSRS evaluate column in fill expression

I have a table in SSRS, Grouped on customer number. I need to evaluate the same column within the fill expressions. The evaluation should be - where if the ABTAX for the two different customers is the same and the AIMAXO are also the same then fill…
MJCookie
  • 135
  • 1
  • 3
  • 10
1
vote
3 answers

SSRS - Expression to create string for reporting heading

I have a report which has 6 parameters within it. What I would like to do is make these parameters part of my report heading. My parameters are as follows: @BMDataType1 Text @BMDataComp1 Float @BMDataType2 Text @BMDataComp2 Float @BMDataType3 …
chrissy p
  • 823
  • 2
  • 20
  • 46
1
vote
1 answer

SSRS - IIF/Switch/Replace multiple conditions in a field

Have a nvarchar column in ms sql that, based on user input, may or may not have a carriage return and a line break together (CHR(13)&CHR(10)), just a carriage return (CHR(13)), just a line break (CHR(10)). In using that column in ssrs, I need to…
phoeneous
  • 59
  • 1
  • 6
1
vote
3 answers

SSRS Expression

I have to create a report and the header is not query based so I created the header like = "Name of the company" & vbcrlf & "name of the report" so on now my question is how do I make Name of the company Bold and Report name bold too?
seema
  • 11
  • 1
1
vote
2 answers

Saving the value of the sum of ReportItems.TextBox in SSRS

I have the following: =Round(ReportItems!Textbox47.Value + CDbl(ReportItems!Textbox218.Value) + CDbl(ReportItems!Textbox222.Value) + CDbl(ReportItems!Textbox226.Value) + CDbl(ReportItems!Textbox230.Value) +…
Nickso
  • 785
  • 1
  • 10
  • 32
1 2 3
…
14 15