[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Visual Studio Reporting Expression for checking if value exists?

Posted on 2011-05-13
7
Medium Priority
?
589 Views
Last Modified: 2012-05-11
I would like to do a statement in VS reporting services that just checks to see if a value Exists in  a Field, for example If Exists (Fields!Total.Value > 50000) but in the correct syntax of course
0
Comment
Question by:melli111
  • 5
  • 2
7 Comments
 
LVL 21

Expert Comment

by:Alfred A.
ID: 35754155
You could try something like this:

=IIF((Not Fields!Total.Value Is Nothing) AndAlso  Fields!Total.Value > 50000, True, False)


Note that the expression assumes that a boolean value is required as an output.
0
 
LVL 15

Author Comment

by:melli111
ID: 35754350
The issue I think is that an expression like you have posted above will only work to check individual records, not for the entire field.  Or will that check all of the records?
0
 
LVL 21

Expert Comment

by:Alfred A.
ID: 35754379
It really depends on how you apply.  It can be applied to every row in a dataset  or every row in your tablix for example.  You could use an expression to filter for instance records that have totals of let say greater than 50,000.  You could setup an expression to a total field column and filter the rows.  

SSRS Expressions are powerful and there are a lot of uses for them and I use them a lot.
0
Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

 
LVL 21

Expert Comment

by:Alfred A.
ID: 35754387
By the way, in my example above, you can set the Row Visibility of a row by setting the Hidden property to either true or false.  True, hides the row, False shows the row.  The expression above can define a Hidden property as an example.
0
 
LVL 15

Author Comment

by:melli111
ID: 35754874
Can an Expression be used for the Row Visibility?
0
 
LVL 21

Accepted Solution

by:
Alfred A. earned 2000 total points
ID: 35755351
Yes.  Check this out.  

http://msdn.microsoft.com/en-us/library/ms159830.aspx

In the above link, we you click "Show or hide based on an expression", you can input your expression at this point.
0
 
LVL 21

Expert Comment

by:Alfred A.
ID: 35755359
Oh and in the provided link in my previous post, check the topic on "To hide static rows in a table, matrix, or list"
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Performance in games development is paramount: every microsecond counts to be able to do everything in less than 33ms (aiming at 16ms). C# foreach statement is one of the worst performance killers, and here I explain why.
This article aims to explain the working of CircularLogArchiver. This tool was designed to solve the buildup of log file in cases where systems do not support circular logging or where circular logging is not enabled
Loops Section Overview
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Suggested Courses

873 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question