Active TopicsMemberlistSearchHelpRegisterLogin

Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Section Suppression Not Working in 2008 Post Reply Post New Topic
Author Message
CRaid
Newbie
Newbie


Joined: 07 Jan 2013
Online Status: Offline
Posts: 13
Quote CRaid Replybullet Topic: Section Suppression Not Working in 2008
    Posted: 12 Jul 2013 at 4:45am
I am using 2008 and am having problems with suppressing a section if the field's value, in that section, is 0.
 
In the section's suppression,  I added this formula:
    {Table1.Monies} = 0
 
When I run the report, the field, Monies, is definitely 0, yet the section keeps showing up.  There are no other tests for the section.  The suppress option is not selected in the section, only the formula was added to the suppression.
 
Anyone else having this problem?  It has happened to me twice so far.  Any ideas?
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 12 Jul 2013 at 4:48am
did you try and create a formula using {Table1.Monies} = 0
and place that on the section you want to supress to verify that the formula returns a True?
IP IP Logged
CRaid
Newbie
Newbie


Joined: 07 Jan 2013
Online Status: Offline
Posts: 13
Quote CRaid Replybullet Posted: 12 Jul 2013 at 5:06am
Thank you for your help, DBlank!  I regret to inform you this did not work.
  
Is there a weird thing with 2008?  I have done many suppressions and never had a problem until now.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 12 Jul 2013 at 5:08am

did the formula return a T or F?
IP IP Logged
kevlray
Admin Group
Admin Group
Avatar

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Quote kevlray Replybullet Posted: 12 Jul 2013 at 5:14am
I do not know if this is related, but we had a similar issue with an WebI report using MS-SQL as a data source.  Even though the data type was a decimal(10,2) , it would suppress with the measure  = 0.  But would if we checked > -.01 and less < .01.  Still do not understand why.
IP IP Logged
CRaid
Newbie
Newbie


Joined: 07 Jan 2013
Online Status: Offline
Posts: 13
Quote CRaid Replybullet Posted: 12 Jul 2013 at 7:21am
By George, I think we've got it!  This worked beautifully!  Thank you for your help, kevlray!
 
Maybe the value of the field actually comes out to a trillionth of what we see, which makes it a non-zero value.
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.016 seconds.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2024 Brian Bischof. All Rights Reserved.