Print Page | Close Window

Record Counter

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=16686
Printed Date: 02 May 2024 at 7:09am


Topic: Record Counter
Posted By: sarath
Subject: Record Counter
Date 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


Replies:
Posted By: subramaniyan
Date 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.

Posted By: kevlray
Date 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.

Posted By: lockwelle
Date 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.

Posted By: sarath
Date Posted: 08 Jun 2012 at 8:38pm
Thanks Mr. subramaniam
 
It works fine.
Below is the formula I used.
 
Remainder ( mailto:%7b@RECORD%7d,5 - {@RECORD},5 ) = 0
 
Regards


Print Page | Close Window