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
0 answers

Adding values to a Report when there is no Data in query SSRS Between Datasets

It is basically the same question I had in this thread: Adding values to a Report when there is no Data in query SSRS The only difference now is that I want to extend the same functionality to different Datasets. Imagine this: I have two Datasets.…
Nickso
  • 785
  • 1
  • 10
  • 32
1
vote
0 answers

SSRS Expressions issue with separate datascope

DATEDIFF("d", First(Fields!CurrentEffDate.Value, "dstvwGMDEntryDetails"), Now()) have this as an expression it works perfectly but before it does this i need Fields!IsTempProduct.Value, "dstvwProductDetails")=1 this if a product is a temporary…
Cladback
  • 157
  • 1
  • 1
  • 9
1
vote
1 answer

Parameter![paramname].label (0) = #error

im using a visual studio expression =parameter!site.label(0) the user can select all/ multiple values for this parameter but the parameter is only showing the first one say user selected all (birm,londn,leeds) the field should say birm,…
Cladback
  • 157
  • 1
  • 1
  • 9
1
vote
1 answer

SSRS Expressions Not Executed When Rows Are Hidden

I'm new to SSRS and have been tasked with converting our Crystal Reports to it. The problem I'm running into is when trying to hide the detail rows which contain the data for the group calculations, the expressions no longer get calculated. How can…
Error
  • 25
  • 1
  • 6
1
vote
2 answers

SSRS - Complex date range field logic not working with nested IIF's

There's a requirement to display a date range based on the following logic in a Reporting Services report like so: If there's only a Started datetime, display like so: on 12 December 2014 If there's a Started and Finished datetime on the same day,…
Gavin
  • 5,629
  • 7
  • 44
  • 86
1
vote
1 answer

SSRS Expression to Substitute 0 for NA

I've the SSRS Expression that is provided below. The issue with that expression is that the last column sometimes shows #VALUE! when the 1st column value is NA. It is basically failing to calculate. How can I fix this expression so that it shows the…
user3430726
  • 55
  • 1
  • 7
1
vote
3 answers

split ssrs expression between 2 words

I have a requirement to split a result up into 3 separate expressions, Using sql server 2008. The result i currently get is for example. "person: man tel: yes rel: christian msg: misc text" I need it split into: "Person: man" "Tel: yes" "Rel:…
user3735855
  • 144
  • 2
  • 20
1
vote
1 answer

SSRS: expression in a calculated field

I am trying to write an expression in a calculated field that shows if one date value is greater than another: =(IIF(fields!date1.value>fields!date2.value,"late","on time") This works fine when there is a value in fields!date2. However, if…
Will F
  • 417
  • 2
  • 6
  • 17
1
vote
2 answers

How to replace Null fields with 0s

I have a field in a matrix that has some nulls. I would like to replace all the nulls with 0s. This is the expression I currently have in the field: =Sum(IIf(Code.isVM(Fields!deviceType.Value), 0, 1)) I'm guessing I have to have an IsNothing…
JimMatz
  • 45
  • 1
  • 4
1
vote
1 answer

SSRS expression evaluation not working

A shared data set returns two columns: DaysEarly and NumberShipped. I want to use this in a table to show the number of shipments that were early, on time, and late. The data looks like this: DaysEarly NumberShipped 3 123 2 …
David O
  • 49
  • 7
1
vote
1 answer

SSRS - expression warning for date time format

I need to grab the Month and Year info from 2 date/time parameters of my report (Start date and End date) into a textbox. I used the following expression - =MonthName(Month(Parameters!StartDate.Value)) & Format(Year(Parameters!EndDate.Value)) & "…
viv_acious
  • 2,429
  • 9
  • 34
  • 55
1
vote
2 answers

Use a summary field in an expression in SSRS reports

I have the details of my report being summed up in a summary expression, all works fine. The fields are decimal values of hours worked. Thus, the summary value is also a decimal value. I'd like to access the summary value and convert it to hours…
RobRichard
  • 100
  • 3
  • 11
1
vote
4 answers

How do I mix functions in complex SSRS expressions?

I'm writing a report against a data repository that has null values within some of the columns. The problem is building expressions is as temperamental as a hormonal old lady and doesn't like my mixing of functions. Here's an expression I've written…
TheHolyTerrah
  • 2,859
  • 3
  • 43
  • 50
1
vote
2 answers

Formatting a Text in SSRS

I have a text of the form 1;#aa2;#dde4;#sdfsa6;#hjjs I want to remove digit and ;# from the above string and keep the string as aa dde sdfsa hjjs Is there a way like we do in C# to check if string contains ;# and replace it with a or a…
Ishan
  • 4,008
  • 32
  • 90
  • 153
1
vote
1 answer

SSRS Expression to count the distinct number of items visible

Currently I'm using this expression in a cell above the column headers of a table: = "Num Days " & CountDistinct(Fields!Date.Value) In the report designer this is the context of the expression: Here is what the result looks like: The expression is…
whytheq
  • 34,466
  • 65
  • 172
  • 267
1 2 3
…
14 15