Crystal Reports & SQL Reporting Services Training Consultants
Account Log in:
Genius is that energy which collects, combines, amplifies and animates
Institute of IT Trainers - Freelance Trainer of the Year 2006 & 2009
Liverpool Business Connect Member
  Maximum Impact Solutions Limited - Reporting Solutions, Creating Answers
Reporting Solutions - Creating Answers, Crystal Reports, Dashboarding (Xcelsius) & SQL Reporting Services

The Maximum Impact Solutions Blog Feed ME!!!!


How can I Add Multiple Conditions to the Visibility Property in SQL Reporting Services 2008?

During a recent SQL Server Reporting Services 2008 (SSRS 2008) report design project, a client asked   "How can I Add Multiple Conditions to the Visibility Property of a Report Item?"

If SSRS 2008 had the IN function then the formula would simply be:

=iif((Field_Type!Fieldname.Property) IN (Condition1, Condition2, Condition3), True, False)

However  SQL Server Reporting Services (SSRS) does not have an IN function within its   formula or expression functions, so to add multiple conditions, one would have to define each condition individually  and use the AND or OR functions between each condition.


When creating conditional formatting formulas, with multiple conditions, one must enclose each condition within a bracket and then link them using either the AND or OR functions.

The syntax to control the visibility of a report item in SSRS 2008, with multiple conditins, is as follows:
= iif(((Field_Type!Fieldname.Property) = Condition1) OR
( Field_Type!Fieldname.Property = Condition2) OR
( Field_Type!Fieldname.Property = Condition3)) ,True , False)

Note: The default for the Visibility property for Report Items is Hidden

If you have any questions, leave us a comment below, or need any assistance, please do not hesitate to Contact Us



how to give iif condition in false part can any one help on this


Naveen, you would have to create a Nested IIf statement and add the condition to the false part of the statement above, but then make sure you state whether object is visible.


thank you it helped me a lot :)


Thanks - helpful


Doctors have many challenges to face as they are perennially surrounded by patients, diseases, hospital duties and over-extended or odd shift timings. Universally, doctor is considered to be a noble profession and respectable one at that, but a doctor also has to work under immense pressures, emotional strains and other physical challenges. A regular physician like most of us at some point face will have to deal with personal situations such as important family affairs, family holidays, sickness or pregnancy that may force them to abandon medical duties. At the same time, a hospital or a healthcare facility is also constantly faced with emergency situations that demand all hands on deck round-the-clock. Therefore, every hospital, clinic or nursing home is compelled to hire locum tenens or substitute doctor in order to keep the staffing under control at all times. In fact, locum doctors are the most valuable asset for the medical community because they provide quality medical care and act as a helping-hand in emergency situations when the medical facilities need them the most. Unlike regular or permanent doctors, locum doctor jobs are also ideal career options for medical interns and graduates because they offer a wide array of medical exposure in varied medical specialties, work cultures and healthcare systems. Locum jobs are challenging and flexible, thus an increasing number of medical professionals have benefitted from these jobs, so whether one is looking for a family physicians position or in a hospital or in a clinic, locum jobs for doctors are available at all levels and in different healthcare systems. In addition, being a locum doctor gives a medical professional the control over their working hours, location of work and choice of area of specialisation. Technically, locum positions are not restricted to general physicians but they are also extended to other fields of medical specialisations such as cardiology, neurology and many more. Travelling can be an integral part of locum jobs, and these distinctive features are a boon for many dedicated medical professionals who are eager to expand their medical careers with loads of multi-cultural medical experiences. The fact that locum agencies in the UK recruit tens of thousands of locums from across the globe in various NHS hospitals, private clinics, nursing homes and other public hospitals speaks volume of the popularity of locum jobs. Locating or getting a locum tenens job is a simple task as long as you are registered with one of the many reputable locum agencies. These agencies act as the middle man between locum tenens and medical facilities, and they also look after all the details pertaining to travel for locum tenens, accommodation and the nature of locum work. Thus, maintaining a healthy locum doctor-agency relationship benefits both the parties, and it also increases the probability of getting recommendable employment opportunities and businesses or vice-versa.


Name *

Email Address *

Comment *