ssrs-expression Questions
4
Solved
Stumbled on an obscure problem. Posting this because my searches of stack overflow did not find my answer. Hopefully this will help someone else.
Problem:
My reporting services report will compile,...
Buttonball asked 29/7, 2014 at 18:17
4
Solved
I have a tablix box that has a division expression. When dividing by zero or nulls I get #Error displayed in my report. I tried to create an IIF statement and tested with static values. This verifi...
Antidote asked 4/10, 2013 at 19:19
7
Solved
i'm recieving the following error:
Error 1 [rsInvalidAggregateScope] The Value expression for the text box
‘Textbox2’ has a scope parameter that is not valid for an aggregate function.
The scope...
Berate asked 4/2, 2014 at 12:7
4
Is it possible to write extension methods for expressions behind RDLC fields?
For example, let's say that I have a DateTime field in my datasource that may either have a valid value or may be null...
Jarv asked 2/7, 2010 at 23:17
5
Solved
I'm trying to highlight a field when the value has the word 'deadline' in it. I'm trying to use the expression:
=IIf(Fields!Notes.Value like "%deadline%","Yellow","Transparent")
in the Background...
Serra asked 25/1, 2012 at 20:32
6
Solved
I'm trying to write a field expression for a Cell in my report where I have to change the background color of the cell depending on the string value in the cell. Ex: if the column has a value 'Appr...
Frigidaire asked 14/2, 2011 at 14:30
3
Solved
Trying to count all rows in a column where column=Yes
I have two columns in my report Accepted and rejected.
I'm trying to count the rows where accepted=Yes and do the say thing for rejected.
I'v...
Harbourage asked 4/3, 2013 at 15:2
2
Solved
In one of the column name, I need to display yesterday's date like - September 4,2014
I used DateAdd("d",-1,Today()) function to display,but it is displaying like - 9/4/2014 12:00:00 AM.
How can ...
Blockbusting asked 5/9, 2014 at 17:6
7
Solved
I am using the following expression to work out a percentage:
=Fields!Days.Value/Sum(Fields!Days.Value, "Date_month_name")
Days.Value is showing as 0 however in a few of my results instead of re...
Bradytelic asked 12/1, 2012 at 14:12
14
Solved
I'm trying to populate an expression (default value of a parameter) with an explicit time. How do I remove the time from the the "now" function?
Cuevas asked 8/9, 2009 at 18:10
1
I am struggling to get an expression to work in SSRS.
I have an address block stored in an Oracle database with carriage return characters.
An example is the data stored in the database is:
123 ...
Adroit asked 11/1, 2016 at 17:4
1
Solved
Is there a difference between Today() and Now()?
When I searched online for date expressions I noticed that both are used quite frequently to retreive the same information. Which expression shoul...
Eroticism asked 9/12, 2015 at 11:32
1
Solved
I have below line in crystal report formula, It means that if string conversion failed it will print ##.
CStr({rptReport;1.Total},"##")
Now, the question is how can I achieve this by SSRS Expres...
Petepetechia asked 7/12, 2015 at 13:12
1
Solved
value 1 is a retail price decimal value 2 is the difference between 2 retail costs both are decimals
=IIF(Fields!Prorated.Value is null,"",Fields!Prorated.Value)-Fields!Retail.Value fixxed !!!
...
Virulence asked 22/9, 2015 at 12:26
1
Solved
I am having trouble showing/hiding a column based on parameter value chosen.
How my report is set up:
Parameter: ImportStatus --ImportStatus parameter has three values you can choose from: M, V, E...
Discompose asked 18/12, 2014 at 20:43
1
Solved
I'm trying to create a calculated expression from a field in my dataset. I need to find everything that contain the word Exchange Traded from one field and in my new field have the words 'ETF 13F'....
Conure asked 14/11, 2014 at 19:22
1
Solved
I am creating a field from tables with our shoretel phone system and i am intergrating reports via SSRS and i need some assisstance with an expression.
=if(Fields!ExitReason.Value 7,
then if (Fiel...
Kwh asked 4/12, 2013 at 19:22
1
Solved
I use the following expression to obtain a row number for a table in SSRS:
=RunningValue(CountDistinct("Table1"),Count,"Table1")
I also use an expression for the row visibility property. Lets ju...
Wilow asked 23/9, 2013 at 6:51
1
Solved
I am trying to display a different logo based on the users franchise number.
Parameter = UserFranNr
If the value <> 99 and <> 87, then the embedded image to display is ID0. (Embedded image ...
Polypetalous asked 18/9, 2013 at 9:29
3
Solved
I have a problem here,
Have an SSRS report for Bank Transfer see attached
I would like to add a row expression which will Sum the total amount of the same bank, i.e,
03001 - Standard Chartered B...
Northernmost asked 30/8, 2013 at 10:20
2
Solved
I have an SSRS report which I want to sum values of a field, but only if the value of another field is equal to 1, as I have made the report output a row number for each row. Bascially, I'm trying ...
Mousseline asked 14/8, 2013 at 15:47
1
Solved
What's the syntax for inserting a WHERE clause in an SSRS expression? I am using BIDS 2008.
=Sum(Fields!QuantityToShip.Value) WHERE FIELDS!Program.Value = "FC"
The code listed above represents t...
Novara asked 12/4, 2012 at 22:0
1
Solved
I would like to write a Reporting Services "Expression" that basically behaves as the following (pseudo code)...
if ([Fields!StateProvinceId.Value] == 1)
{
return "Ontario";
}
else if ([Fields!St...
Bandylegged asked 23/8, 2010 at 21:46
1
© 2022 - 2025 — McMap. All rights reserved.