Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: i want suppress only if entire columns are 0.00 Post Reply Post New Topic
Author Message
Sampath Kumar
Newbie
Newbie
Avatar

Joined: 30 Jul 2009
Location: India
Online Status: Offline
Posts: 2
Quote Sampath Kumar Replybullet Topic: i want suppress only if entire columns are 0.00
    Posted: 05 Aug 2009 at 4:34am
hi,Experts.
i want suppress only entire columns are zero or 0.00 but here below how can i do? for can make a condition if entire
columns are 0.00 then suppress other wise no.this is my existing formula how can i modify.

isnull({Sp_Optional_New_OutstandingMIS_BIllWise_newformat_27032009;1.Serv Chrgs - HO})
or ({Sp_Optional_New_OutstandingMIS_BIllWise_newformat_27032009;1.Serv Chrgs - HO}) = 0.00

Regards,
Sampath Kumar.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 05 Aug 2009 at 6:15am
I assume you mean you have multiple fields on a detail section and you want to suppress the detail row if all the fields on it are NULL or 0.00.
Just parenth the formula you ahave now and add an AND then add your next field conditions...It will be like this (red ink indicates new sections of the suppression formula):
(isnull({Sp_Optional_New_OutstandingMIS_BIllWise_newformat_27032009;1.Serv Chrgs - HO})
or ({Sp_Optional_New_OutstandingMIS_BIllWise_newformat_27032009;1.Serv Chrgs - HO}) = 0.00 )
AND
(isnull({table.nextfield}) or {table.nextfield}=0)
AND
(isnull({table.thirdfield}) or {table.thirdfield}=0)
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.032 seconds.