Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: how to restrict the number of rows displayed ?? Post Reply Post New Topic
Author Message
SIddhu
Newbie
Newbie
Avatar

Joined: 27 Feb 2008
Location: India
Online Status: Offline
Posts: 22
Quote SIddhu Replybullet Topic: how to restrict the number of rows displayed ??
     Posted: 11 Aug 2008 at 12:27am
Hi,
 
I have to prepare a report in which i have to show the details of a list of representatives. Each representative will have many activities and a corresponding date for that activity. I have to pick up only the 2 most recent activities of each rep and display that.
 
So i arranged the details in a descending order of that date. now i have to display only the top two activities of that person in the report.
 
How do i limit the details, so that only the top 2 activities are displayed....?
 
Please help me out !!
Thanks !!
Siddhu.
IP IP Logged
RitaInHood
Newbie
Newbie


Joined: 07 Jul 2008
Online Status: Offline
Posts: 25
Quote RitaInHood Replybullet Posted: 11 Aug 2008 at 2:32pm
Group by rep
Set a flag to 0 in the header
on the detail, increment flag
if flag >2, suppress
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