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

IIF IsNothing expression example

I'm using SSRS 2008 and am trying to create an expression where if date field A is greater than date field B or date field A is NULL then this filter will select this record. How do I do this? I tried this expression to select NULL date fields, but…
salvationishere
  • 3,461
  • 29
  • 104
  • 143
0
votes
1 answer

SSRS BIDS SUMMING A SUM TO PRODUCE A SUM

Please see attached images. On the light blue row I need total percentages next to the total days. There are 3 classifications : Project, RFC and Support, each has two sub colums (Days and Total%) I have included a sum for total days added up…
JsonStatham
  • 9,770
  • 27
  • 100
  • 181
0
votes
0 answers

ARform.RDL ship to address cleanup to remove blanks

I am trying to clean up our companies ARForm.rdl before our relaunch and am trying to figure out a way to remove all the blanks in the shipto address fields. in the Bill to Address area I changed the code to…
Cowboydanny
  • 1
0
votes
0 answers

Snowflake - How to Call Stored Procedure in SSRS with multi-value parameter

I have a Snowflake Stored Procedure written in Snowflake that has 3 dynamic parameters, 1. StartDate, 2. EndDate, 3. FromVQ (Multi-value parameter meaning users can select more than one value) that im embedding in ssrs stored procedure…
Arsee
  • 651
  • 2
  • 11
  • 36
0
votes
2 answers

Dynamically assign Dollar and percent sign to the Column value in SSRS expression

I have a column with the below sample data coming from the table , I am loading this data to SSRS report. I have to fomat the data based on Type column, if the type is dollar in the report it should show as $78.00 if the type is 'percent' it should…
0537
  • 993
  • 8
  • 15
  • 32
0
votes
0 answers

SSRS Group by Time Expression

I have data that for time bands I would like to add to my group properties expression on SSRS, the data is in the image I would like to display this like the image below, with this grouping by time I set so 00:00 to 01:59 etc I had this in my…
Kris
  • 1
0
votes
0 answers

SSRS Currency Format IIF Expression

I'm trying to format the text box properties based off an expression, I have a field 'currencyID' and I'm trying to get it to change from £ to € if the value doesn't equal 1. So far I've got this but I am terrible at SSRS…
GandalfTheFoolish
  • 3
  • 4
0
votes
1 answer

Report field to display correct error message in ssrs

I have a dropdown with parameters Student Name and Student Id. When I select Student Name a textbox appears as below and have the submit button: enter image description here On clicking Student ID the report parameter is displayed as below: enter…
hash.f
  • 1
  • 1
0
votes
1 answer

SSRS Expression to Sum value IIF YearMonth = Parameter

I hope someone would be able to assist\help. I have a Tablix that I'm trying to populate with three separate (summed) values (Current Month, Current Year and Previous Year) from one field based on a parameter. My parameter is set as yyyymm. My…
BjornJ
  • 3
  • 2
0
votes
1 answer

RDLC Report - Ordering in date is not working

I am trying to implement ordering by date in rdlc report. The data is filtered on the basis of from date and to date. I have also added header on the top of the report as 'Month Name' Details(e.g. Nov Details) The date format of a column on which I…
mradima07
  • 3
  • 1
  • 1
  • 5
0
votes
1 answer

RDLC report - Duplicate data issue in grouping

I have a RDLC report in which I want grouping by username and status which has value open and closed. I am getting duplicate username when both the value of status is present for the username. In the expression, I have used below code - =IIf…
mradima07
  • 3
  • 1
  • 1
  • 5
0
votes
1 answer

SSRS Expression Split string in rows and column

I am working with SQL Server 2008 Report service. I have to try to split string values in different columns in same row in expression but I can't get the excepted output. I have provided input and output details. I have to split values by space ("…
nanda9894
  • 61
  • 5
0
votes
1 answer

SSRS Expression "Count of Days with No dissatisfied Customers" Cannot get it working

I have to get a expression in my SSRS table that achieves the count of days with no dissatisfied customers. Right now I have an expression like this: =RunningValue(IIF(Fields!SATISFACTION_LEVEL.Value <> "Dissatisfied",1,0),Sum, "DataSet1") This…
Brandan
  • 1
  • 2
0
votes
1 answer

SSRS report multiple concatenate

I'm trying to join two data sets in my SSRS table report. The problem is that I can only concatenate two columns in my lookup statement. The third is being ignored. I need to do more than two. how can I achieve this? my values are duplicating in my…
Tdubs
  • 29
  • 7
0
votes
1 answer

Visible Row Values on IIF Expression from Hidden Row?

Purchase Price Variance In my specific scenario (screenshot) Report is showing Shipment(step1) and then Invoice(step2). And I want is all this information in one row. I need to hide the row when POP_TYPE=Shipment but how can I get QTY SHIPPED and…
adeel
  • 17
  • 8
1 2 3
…
14 15