Crystal Reports Record Counter

Report Design

Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Report Design

Topic: Record Counter

Author	Message
sarath Newbie Joined: 06 Jun 2012 Location: Saudi Arabia Online Status: Offline Posts: 2	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 Logged


subramaniyan Newbie Joined: 06 Jun 2012 Online Status: Offline Posts: 1	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 Logged

kevlray Admin Group Joined: 29 Oct 2009 Online Status: Offline Posts: 1587	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 Logged

lockwelle Moderator Joined: 21 Dec 2007 Online Status: Offline Posts: 4374	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 Logged

sarath Newbie Joined: 06 Jun 2012 Location: Saudi Arabia Online Status: Offline Posts: 2	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 Logged

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