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.
Questions tagged [ssrs-expression]
225 questions
2
votes
1 answer
How to remove zeroes after the decimal point as an expression in SSRS
I have the following expression in one of my textbox in my SSRS Report:
=IIF(IsNothing(Lookup(Trim(Fields!venta_Cod_vendedor.Value) & "-" & ReportItems!Textbox233.Value, Fields!AgregarVentas.Value, Fields!venta_prom_sem.Value,…
Nickso
- 785
- 1
- 10
- 32
2
votes
3 answers
how do I get the average of lookup value from ssrs?
=Lookup(dsc.Value,Dsc.value,Fields!Fmotion.Value,"Stage")
I want to get average of that lookup value. How can i write an expression that shows average of that lookup value?
HAIZD
- 179
- 1
- 1
- 16
2
votes
1 answer
Adding values to a Report when there is no Data in query SSRS
I have a query that returns Sales representatives number, Category, Sales.
The result is something like this:
There are 4 categories called G1,G2,G3,G4.
As you can see the Sales representative 11 sold 10 each category (Yellow rows).
But…
Nickso
- 785
- 1
- 10
- 32
2
votes
0 answers
How to Apply a code in a RunningValue expression in SSRS
I have the following conundrum:
I made a code inside my report that basically accumulate value, here:
Dim number as Double
Function Accumulate(ByVal value as Double) As Double
number=number + value
Return number
End Function
And I made a…
Nickso
- 785
- 1
- 10
- 32
2
votes
1 answer
SSRS URL Encode
I have an issue with an expression in SSRS
Project
USE SSRS Expressions and custom code to encrypt, and then determine
target to hyperlink to based on environment.
What we have accomplished
We have created a custom DLL using a custom library…
Hituptony
- 2,740
- 3
- 22
- 44
2
votes
2 answers
SSRS how to use multiple criteria in expression - based on a row value and a field name
Please look at the image below, my dataset has two processes, 'logs processed' and 'stacked at kilns'.
I need to take the total 'stacked at kilns' and divide it by the total 'logs processed' for each length.
so for example for field name 5.4…
Smudger
- 10,451
- 29
- 104
- 179
2
votes
2 answers
SSRS Expression
I've been using Crystal Reports for about 2 years and now I'm trying to learn SSRS in order to convert some of our custom reports over to SSRS.
In the DB, I have a column called OpenToPublic which will either be 0 for No or 1 for Yes. In CR, I…
MISNole
- 992
- 1
- 22
- 48
2
votes
1 answer
SSRS Expression - Aggregating variables
I'm building a report where I'm trying to write an expression for a variable (not parameter). I'm planning on creating multiple variables, each referencing the SUM(SUM()) of amounts from different datasets. I'm then planning on referencing each of…
dp3
- 1,607
- 4
- 19
- 28
2
votes
2 answers
SSRS expression editor does not recognize embedded code function
I have an SSRS report with information about invoices my company has issued with things like amount, date, payment, amount due, etc. I'm using SSRS 2008 (not R2) in Visual Studio 2008 environment. My issue has to do with formatting the report using…
Paul
- 1,375
- 2
- 21
- 55
2
votes
2 answers
SSRS divide by zero error expression
Hope your well.
I am working on a report and seem to get a #error. Seems like it is a divide by zero error but I can not work out a solution. The expression:
=( Sum(Fields!Line_Sell.Value) - Sum(Fields!Line_Cost.Value) ) /…
Steven
- 91
- 1
- 9
2
votes
1 answer
Dynamic matrix width to always equal chart width
Most things are dynamic in SSRS i.e you can create a custom expression for most formatting.
I have a report with a matrix tool. This matrix will vary in width depending on how many columns are included.
Above the matrix is a chart.
How do I make…
whytheq
- 34,466
- 65
- 172
- 267
2
votes
3 answers
SSRS BIDS expression language Month Part from Current date
In BIDS I need an expression to take the YEAR part of a date which is minus 1 month of the current date.
For example Today's date is 20/04/2012 the desired expression would return:
2012
If todays date was 05/01/2012 the desured expression would…
JsonStatham
- 9,770
- 27
- 100
- 181
1
vote
1 answer
Left and Right Indent in Same SSRS Expression
I need to to be able to control the alignment of text in the expression. What I need is for a $ to always be left indented but then put the value right indented.
Example:
$ 100.00
$ -
$ 546,983.00
$ 4567,00
The dash is what is…
auwall12688
- 389
- 3
- 11
- 23
1
vote
1 answer
Show line in even rows in Reporting service
I have a report that I want add a line beneath the even rows in details section.I add a Line in details section and add this expression to that:
=IIF(RowNumber("DataSet1") Mod 2 , "Green", "No Color")
but line showed under the last record of my…
Arian
- 12,793
- 66
- 176
- 300
1
vote
1 answer
How to set visibility expression in SSRS?
I am using SSRS 2008 with a tablix. I want to make one of my rows visible, when field value = 1 and invisible when this value = 0. How do I configure this? Right now I right-clicked teh row and entered the field value for the expression. Then I…
salvationishere
- 3,461
- 29
- 104
- 143