Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Suppress a Column Post Reply Post New Topic
Author Message
Nila Angel
Newbie
Newbie


Joined: 27 Oct 2008
Location: India
Online Status: Offline
Posts: 3
Quote Nila Angel Replybullet Topic: Suppress a Column
     Posted: 27 Oct 2008 at 10:55pm
Hi,
 

I want to suppress a column value in all the even rows under details section. I am using Crystal Reports 10 version.

 

Please help me.

IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 27 Oct 2008 at 11:35pm
You can do this by creating a formula and attaching it to the Suppress property of the column. The formula should test if the row is even or odd.
RecordNumber Mod 2 = 0;
This code says that if the recordnumber is evenly divisible by 2, then it is an even row. Attach this to the suppress property of your field and it will suppress it on every even row.
 
My Encyclopedia book is filled with tips and tricks just like this one. You can find out more about my books at Amazon.com or reading the Crystal Reports eBooks online.
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
IP IP Logged
Nila Angel
Newbie
Newbie


Joined: 27 Oct 2008
Location: India
Online Status: Offline
Posts: 3
Quote Nila Angel Replybullet Posted: 28 Oct 2008 at 12:00am
Hi,
 
I did same but it is only suppressing the 2 row and showing all the remaining odd and even rows.
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 28 Oct 2008 at 12:22am
That's odd. How about just printing the results of the formula on the detail row and then you can look to see what value it is returning. You should see zero on every even row. If not, report back what you get so I can see what is going on.
RecordNumber Mod 2
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
IP IP Logged
Nila Angel
Newbie
Newbie


Joined: 27 Oct 2008
Location: India
Online Status: Offline
Posts: 3
Quote Nila Angel Replybullet Posted: 28 Oct 2008 at 11:25pm
Hi,
 
It's Working fine. Thaks a lot
IP IP Logged
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