Crystal Reports CRYSTAL REPORT

Technical Questions

Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions

Topic: CRYSTAL REPORT

Post Reply

Post New Topic

Author	Message
vpriyanka2001 Groupie Joined: 28 May 2009 Online Status: Offline Posts: 59	Topic: CRYSTAL REPORT Posted: 02 Sep 2009 at 10:12am
	I need to create a REPORT with 4 Fields 1 Broker Name (Firmname) Broker Number (Bornum) Premium (Prem_tally) count (count) Result should be TOP BROKER by Premium I cannot really understand how to do this, please please help.
	IP Logged


DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 02 Sep 2009 at 10:30am
	Group on Broker #. Insert a Summary using the Prem_tally Field as a SUM at group level 1 (broker#). THis must be done for the Group Sort Expert to be activated. Click on the Group Sort Expert.(blue graph line with red arrowe pointing up next to the Group Expert button). For this Group sort change to "top N" Based on "SUM of table.Prem_Tally" Where N is (number of brokers you want to be shown in report). Include others is optional.
	IP Logged

vpriyanka2001 Groupie Joined: 28 May 2009 Online Status: Offline Posts: 59	Posted: 02 Sep 2009 at 10:57am
	Thanks.
	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