[Last Call] Learn how to a build a cloud-first strategyRegister Now


MS Reporting Services Conditional Formatting

Posted on 2005-04-27
Medium Priority
Last Modified: 2008-03-03


Question on using conditional formatting in an expression using MS Reporting Services. This is a time sensitive issue for me.

1. iif - how do you do like an if...elseif...else type statement with these?
2. switch - how do you specify a default for a switch?

thanks in advance, I \'m having trouble finding decent resources out there for anything beyond the most basic tutorials

Question by:animated405

Accepted Solution

ABaruh earned 2000 total points
ID: 13883012
=IIF(Thing To Test, What to do if True, What to do if False)

Set Visibility.Hidden = True if Parameters!Test.Value = 0

=IIF(Parameters.Test.Value = 0, True, False)

You can use vb.net code to handle more detailed If..then logic.  You actually create the Code in the Code tab of the Report Properties.  See this site about embedding code in the report:  http://odetocode.com/Articles/130.aspx

I'm not sure what you mean by switches.

Author Comment

ID: 13890829

thanks, i thought I could do this right in the expression for that fields in the table, but the code portion works just as well.

also, I was talking about a switch statement instead of using and if...else type statement which I could have put right in the expression if I knew how to set the default case

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

1. Set up your parameter at the report level as usual, check the box Multi-value, and set the Data Type to String 2. Set the Stored Procedure Parameter to varchar(max)  --<---- This part here is the key to it's success Example:    @cst_key var…
I recently went through setting up a JasperReports Server using the AWS EC2 instance, and this article will cover some basic administration tasks I had to perform.
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…

831 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