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
3
votes
1 answer

SSRS - Conditional Text Formatting (Expressions using Switch)

I will open this up by stating that the expressions do work within the report. The problem is they aren't working together. I currently have a column header formatted based on the values of two columns. Italics and underlined based on the value of…
Facegames TC
  • 63
  • 1
  • 1
  • 8
3
votes
1 answer

SSRS Reporting Services - Bold Word in String

Publication - How to bold author name from within a string? It would be something like this if 1 value was returned but it is a string (=iif(Fields!Author.Value = Parameters!5aAuthor.Value, "Bold", "Normal"). Example: Authors + Year + Title +…
sjackson5280
  • 43
  • 4
3
votes
2 answers

Using AND in Switch Expression in SSRS 2008

Below is my code I use in the Color Expression in SSRS 2008 to change the color of the text. =Switch(Fields!DistanceFromOutlet.Value > 500, "Red", Fields!DistanceFromOutlet.Value < 250, "White") How would I say if the DistanceFromOutlet.Value > 250…
Etienne
  • 7,141
  • 42
  • 108
  • 160
3
votes
3 answers

Is there a way to do SSRS Expressions in C#

I am working on a SQl Server Report Services project and the report I am creating requires some custom code. It seems that all expressions must be in VB.NET and I figured if there was an 'easy' way to switch that over to be C#, it would be…
JasonRShaver
  • 4,344
  • 3
  • 32
  • 39
2
votes
1 answer

set value of variable and use it in same SSRS expression

In SQL server reporting services(SSRS) tablix cell, i want to write an expression as follows:- set the value of variable and use that variable in "if" condition. i have written following expression and its working fine, only issue is i want only…
Yash
  • 191
  • 2
  • 3
  • 14
2
votes
0 answers

Converting formula from Crystal Reports to SSRS

I'll try and keep this as short as possible but I'm trying to convert a formula cell from crystal report to SSRS. Here is the query: SELECT (SELECT START_DATE FROM APPS.GL_PERIODS WHERE PERIOD_TYPE = 'Month' AND…
a.rand
  • 21
  • 1
2
votes
1 answer

Switch expression in SSRS : Argument 'VarExpr' is not a valid value"

=switch( Fields!HEORG_REFNO.Value=7535,"public", Fields!HEORG_REFNO.Value=7539,"public", Fields!HEORG_REFNO.Value=7609,"public", Fields!HEORG_REFNO.Value=7541,"public", true,"private" ) I want to group my result based on…
Devesh Sharma
  • 25
  • 1
  • 7
2
votes
2 answers

SSRS expression based on Field value

I have a matrix report. i am calculating by using this expression, =switch(Fields!Type.Value = "ATHLETE",Sum(Fields!JnlAmt.Value) ,Fields!Type.Value = "Type",0.8*Sum(Fields!JnlAmt.Value) ,Fields!Type.Value = "VENUE", Sum(Fields!JnlAmt.Value)) Now i…
Hari
  • 192
  • 2
  • 12
2
votes
2 answers

Bit conversion not working in SSRS report

I'm working on SSRS report. I have Dataset that returns below values. Now I wanted to change color of Data field on bases of this bit. I tried below, but no success. It always shows False in…
Pedram
  • 6,256
  • 10
  • 65
  • 87
2
votes
2 answers

Sum IIF with multiple values in SSRS

I am having an issue with my expression. I am trying to write: if it finds these specific codes in the Dataset column, Sum them and return the amount. However, I am receiving #ERROR. Any help with this expression is really…
Geo
  • 336
  • 1
  • 6
  • 20
2
votes
3 answers

Custom Number Format in SSRS Report

I am using SSRS Report and I need to define a Custom Number Format for Tablix Textbox. For example: Convert 012123456 To 012-123456. How can I do this by using custom number format or by using FORMAT Please suggest me! Thanks
Pedram
  • 6,256
  • 10
  • 65
  • 87
2
votes
2 answers

Iif function in SQL Server Report Builder 2012 3.0

I'm trying to make an automatic invoice but the final part gets me stuck. If a client is not from the same country as the supplier then he shouldn't pay VAT. To get this in my invoice I'm trying to insert an expression but it gives the following…
Jorgen V
  • 193
  • 1
  • 14
2
votes
0 answers

SSRS GetMedian code help - Sql Server Reporting Services

I am trying to find out the median of a value in SSRS. I keep getting #Error. I place GetMedian() everywhere in my report. Header, Footer, Footer of the table with no luck I am using the code from this post to get the median but I think the issue is…
SeanJohn
  • 187
  • 1
  • 2
  • 11
2
votes
0 answers

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

The intro for this little problem starts here: Adding values to a Report when there is no Data in query SSRS After that: Adding values to a Report when there is no Data in query SSRS Between Datasets Now a basic introduction of what Im trying to…
Nickso
  • 785
  • 1
  • 10
  • 32
2
votes
2 answers

How do i display from and to date from parameter?

Currently, I have text box that asks for a date. However, I would like to get date format like 9/13/2013 to 10/30/2013 from parameter. How can I add to date and from date to text box?
HAIZD
  • 179
  • 1
  • 1
  • 16
1 2
3
…
14 15