SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 Two conditions in report grouping visibility
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

cidr
Posting Yak Master

United Kingdom
206 Posts

Posted - 04/30/2013 :  06:26:15  Show Profile  Reply with Quote
Hi All

Quick question.

I have two conditions on the report grouping visibility. The first condition is to hide only rows that only have NOTHING on a particular field, the second is based on a parameter which has two values (Yes and No). Yes to hide the grouping all together and No to show the grouping.

The first condition always applies and as such will never show rows that have NOTHING. I'm not sure if I can have both conditions on the visibility tab. Below is an idea of what I'm trying to do.

=IIF(Parameters!Action.Value= "Yes" ,True,False) and IIF(ISNOTHING(Fields!action.Value), True, False)

Does anyone know of a way to leverage both arguments?
Thanks

Edited by - cidr on 04/30/2013 06:59:16

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 04/30/2013 :  06:27:17  Show Profile  Reply with Quote
you need to write them as separate consitions in visbility tab.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

cidr
Posting Yak Master

United Kingdom
206 Posts

Posted - 04/30/2013 :  06:54:42  Show Profile  Reply with Quote

visakh 30/04/2013
you need to write them as separate conditions in visibility tab.



Hi Visakh, I'm not sure what you mean. The conditions will be within the same expression container but if I write them as separate conditions (i.e. both with Equal sign) it wont work. Is this what you meant?

Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 04/30/2013 :  06:58:34  Show Profile  Reply with Quote
you want both condition to hold good or any one?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

cidr
Posting Yak Master

United Kingdom
206 Posts

Posted - 04/30/2013 :  07:02:28  Show Profile  Reply with Quote
visakh, I changed the first post slightly because it was slightly incorrect.

The first condition (yes or no) will hide the whole group.

The second condition will always apply; empty action field, hide the row. Using the grouping visibility for this forces a collapse of that row so there's no spaces between rows in the report.

Is it possible to have both conditions?
Go to Top of Page

cidr
Posting Yak Master

United Kingdom
206 Posts

Posted - 04/30/2013 :  07:19:59  Show Profile  Reply with Quote
OR function seems to have worked but didn't seem to work before. I'll have to investigate.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000