Talk with the Author
 Crystal Reports Forum : General Information : Talk with the Author
Message Icon Topic: Suppressing of sections based on two conditions Post Reply Post New Topic
Author Message
Sven
Newbie
Newbie


Joined: 28 Mar 2008
Online Status: Offline
Posts: 12
Quote Sven Replybullet Topic: Suppressing of sections based on two conditions
    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 :)
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3701
Quote hilfy Replybullet 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
IP IP Logged
keval300
Newbie
Newbie
Avatar

Joined: 18 Jul 2008
Location: India
Online Status: Offline
Posts: 24
Quote keval300 Replybullet 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...
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.030 seconds.