Active TopicsMemberlistSearchHelpRegisterLogin

Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: how to Sort record without grouping in crystal X? Post Reply Post New Topic
Author Message
myotismon
Newbie
Newbie


Joined: 22 Jul 2013
Online Status: Offline
Posts: 2
Quote myotismon Replybullet Topic: how to Sort record without grouping in crystal X?
     Posted: 22 Jul 2013 at 9:02pm
hello everyone, I have a report where I need to order for "expiration date" records

Structure Report:
heading
details A: customer code
details B: item number / expiration date
footer

I ordered with "record sort expert" and "expert group"
but when I do, it put before all records of details b
and then all records in details

here is the result:
-----------------
item number / expiration date 1
item number / expiration date 2
item number / expiration date 3

customer number 1
customer number 2
customer number 3
----------------

I would need instead it put in this way:
----------------
customer number 1
item number / expiration date 1

customer number 2
item number / expiration date 2

customer number 3
item number / expiration date 3
-----------------

someone can help me
hello thanks to all
IP IP Logged
praveeng
Senior Member
Senior Member
Avatar

Joined: 11 Jul 2011
Online Status: Offline
Posts: 165
Quote praveeng Replybullet Posted: 23 Jul 2013 at 2:50am
Hi,
 
Instead of using two details sections, Use single details section.
Expand the Details section size and place the Customer number. then below the Customer number, place the Item number field.
Try this one, it may help you..
 


Edited by praveeng - 23 Jul 2013 at 2:51am
Praveen Guntuka,
praveen_guntuka@yahoo.com
IP IP Logged
myotismon
Newbie
Newbie


Joined: 22 Jul 2013
Online Status: Offline
Posts: 2
Quote myotismon Replybullet Posted: 23 Jul 2013 at 6:13am
i cannot join the 2 sections, because when i do the item number dissapear in the "details a"
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4374
Quote lockwelle Replybullet Posted: 24 Jul 2013 at 5:10am
Seems a silly question, but do you have a group set for the customer? It seems from the sample output that you want to group the customer, and place items with expiration dates that belong to the customer below that.

If you don't want to group, as the title suggests, then you have probably already done everything that CR will let you on just straight sorting.

I was surprised to see that CR displayed detail B before detail A. This implies to me that when there is a value in detail B, there is no value in detail A, which is why it sorts first, and since you don't get the output that is expected, I would also suspect that when there is a value in detail A, detail B is blank...so it might be more than grouping issue

It might be a data issue

Just a thought

HTH
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

HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | PRIVACY | CLICK PLAYS | BAEZL

© 2004-2026 Brian Bischof. All Rights Reserved.