Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: group/sorting help Post Reply Post New Topic
Author Message
Greg2010
Newbie
Newbie
Avatar

Joined: 26 Oct 2010
Location: United States
Online Status: Offline
Posts: 5
Quote Greg2010 Replybullet Topic: group/sorting help
     Posted: 06 Dec 2010 at 8:10am

I am grouing a report by truck so I can have it total each days weight with sort records on date

When the report is run, it still starts off with "AB Trucking" on 12/2 instead of "Z Trucking" on 12/1 Here is a sample of the data.
 
DATE TRUCK WEIGHT SEQUENCE
12/01/10 Z TRUCKING 2500 23587
12/02/10 AB TRUCKING 3000 23588
12/02/10 Z TRUCKING 2520 23589
12/02/10 M TRUCKING 4250 23590
12/02/10 Z TRUCKING 2515 23591
 
Any help anyone could give would be greatly appreciated!!
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 06 Dec 2010 at 10:40am
It looks like what you need is to group by date and then by truck instead of the other way around.
 
-Dell
Proviti, Data & Analytics Practice
www.protiviti.com/US-en/data-management-advanced-analytics
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 | KONACAD

© 2004-2026 Brian Bischof. All Rights Reserved.