Please start any new threads on our new site at http://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | 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
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

cidr
Posting Yak Master

United Kingdom
207 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
52326 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
207 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
52326 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
207 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
207 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  
 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.06 seconds. Powered By: Snitz Forums 2000