Joined: 24 Jul 2014
Location: United States
Online Status: Offline
Posts: 1
Topic: Sorting for Top N Reports Posted: 28 Jul 2014 at 5:49pm
Hello Crystal Report Gurus,
Could you help me with the below Scenario and how it is achievable. I am currently working on CR 2013 version.
My Present Report is a Top N report and is sorted in DEsc on AMount
Item Category Amount
1 A 1450
10 B 1200
3 C 1150
1 D 900
5 E 700
and i want to transform it to:
Item Category Amount
1 A 1450
D 900
10 B 1200
3 C 1150
5 E 700
Basically i want to Club the Item if they belong to 2 different categories. For now i have a Group by Segment.
I have tried to insert a group on Item and it shows the first 2 rows as required, but the whole table is getting sorted by the Item column which should not happen. I know that if we insert a Group the Sorting is automatically considered and cannot be avoided.
Could you please let me know how is this possible in CR.
Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Posted: 29 Jul 2014 at 4:46am
while i haven't done it, there is the option to sort on a formula...so if you can come up with a formula that sorts the results correctly (or takes the correct logic into account) it should work.
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