Report Design
 Crystal Reports Forum : Crystal Reports .NET 2003 : Report Design
Message Icon Topic: Rank of grouping Post Reply Post New Topic
Author Message
joekanan
Newbie
Newbie
Avatar

Joined: 22 Aug 2011
Online Status: Offline
Posts: 9
Quote joekanan Replybullet Topic: Rank of grouping
    Posted: 27 Feb 2012 at 8:51pm
Dear All

I have some data and need to be sorting from biggest qty unto lowest.  It's describe like this

Transaction ;
Code     Item      qty
B001     Book      3
B002     Tea         3
B003     Book      3
B004     Sugar     2
B005     Sugar     3
B006     Glass      2

I need to create report to be like this (Sales Rank) :
Item   Qty
Book     6
Sugar    5
Tea        3
Glass     2

If there were any example of creating the report , please share with me how to create the report

Thanks,

 

IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 28 Feb 2012 at 5:22am
you might try looking at the top n style reports. 
 
I haven't done any, but it might be the idea that you need.
 
You could also create a stored proc that will sum up the value that you want and return that, then you could order by summed amount.
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.016 seconds.