Print Page | Close Window

Suppressing of sections based on two conditions

Printed From: Crystal Reports Book
Category: General Information
Forum Name: Talk with the Author
Forum Discription: Ask Brian questions about his books and give him your comments. Like the book? Hate the book? Have suggestions? Let me know!
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=4038
Printed Date: 28 Apr 2024 at 5:21am


Topic: Suppressing of sections based on two conditions
Posted By: Sven
Subject: Suppressing of sections based on two conditions
Date Posted: 19 Aug 2008 at 4:01pm
Hello
 
currently, I am trying to suppress a section of group based on two conditions:
 
  1. The first condition is to suppress the section always if the user is not at DrillDownGroupLevel 1.
  2. The second condition is to supress the section if the GroupName ({Customer.TerritoryID})  is not UK or US.
I went to the section expert and entered this code in the "Suppress (No drill-down)" x-2 formula field:
 
 
DrillDownGroupLevel <> 1 AND
(
GroupName ({Customer.TerritoryID}) <> "US" OR
GroupName ({Customer.TerritoryID}) <> "UK"
)
 
Unfortunately, it does not work. Any ideas are very welcome!!
 
I am using Crystal Reports XI
 
Thanks in advance!!


-------------
Keep trying :)


Replies:
Posted By: hilfy
Date Posted: 22 Aug 2008 at 11:20am
How exactly is it now working?
 
You formula is looking for both conditions to be true.  Try replacing the AND with OR.  That way it should suppress if any of the statements are true.
 
-Dell


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics

Posted By: keval300
Date Posted: 21 Sep 2008 at 11:25pm

Still if it doest work ,

Then try the "Select Expert" option on Right click of the field.

 



-------------
Enjoy...


Print Page | Close Window