Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Report Design
Message Icon Topic: Record Counter Post Reply Post New Topic
Author Message
sarath
Newbie
Newbie


Joined: 06 Jun 2012
Location: Saudi Arabia
Online Status: Offline
Posts: 2
Quote sarath Replybullet Topic: Record Counter
    Posted: 06 Jun 2012 at 1:52am

The report I made have 100 records. I put the record number in first column. But I want to appear only the records where record number can be divided by 5 with remaining 0 value means I want to see the records which record number is 5, 10, 15, 20, 25 ....., 100 only. Please help me how I can make this report.

 
Regards


Edited by sarath - 06 Jun 2012 at 1:54am
IP IP Logged
subramaniyan
Newbie
Newbie


Joined: 06 Jun 2012
Online Status: Offline
Posts: 1
Quote subramaniyan Replybullet Posted: 06 Jun 2012 at 1:59am
select the details  section (report detail- as the record displays in detail portion)select suppress if give the condition as Rownumber(your computed column name)/5 =0 means suppress false else true.
IP IP Logged
kevlray
Admin Group
Admin Group
Avatar

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Quote kevlray Replybullet Posted: 06 Jun 2012 at 7:16am
I do not think that will work
recordnumber mod 5 =0  should only be true on every fifth row.  There is no function in Crystal reports call Rownumber.
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 07 Jun 2012 at 12:07pm
just for sillyness, wouldn't it be {table.recordnumber} since sarath said that he put the recordnumber in the report?
 
If he is just using the built in recordNumber of the report....nevermind.
IP IP Logged
sarath
Newbie
Newbie


Joined: 06 Jun 2012
Location: Saudi Arabia
Online Status: Offline
Posts: 2
Quote sarath Replybullet Posted: 08 Jun 2012 at 8:38pm
Thanks Mr. subramaniam
 
It works fine.
Below is the formula I used.
 
Remainder ({@RECORD},5 ) = 0
 
Regards


Edited by sarath - 08 Jun 2012 at 8:58pm
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.031 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.