Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: HELP Post Reply Post New Topic
Author Message
Duncan3
Newbie
Newbie
Avatar

Joined: 10 Jun 2009
Location: United States
Online Status: Offline
Posts: 6
Quote Duncan3 Replybullet Topic: HELP
    Posted: 10 Jun 2009 at 11:58am
IP IP Logged
rahulwalawalkar
Senior Member
Senior Member
Avatar

Joined: 08 Jun 2007
Location: United Kingdom
Online Status: Offline
Posts: 731
Quote rahulwalawalkar Replybullet Posted: 11 Jun 2009 at 12:38am

Hi

Try this......
 
Group by Location
Sort by Order ID
 
Then go to Menu Insert Summary
 
Field to Summarize :- Order ID
Calculate this Summary:- Minimum
Summary Location :-Group Footer
 
this will insert minimum of Order ID per location in Group Footer
 
Then Go to Details Section right click select Section Expert
Then in Common Tab
Suppress(No Drill-Down) click x+2 button and enter the code below...
 
{Orders.Order ID} > Minimum ({Orders.Order ID}, {Customer.location})
 
Cheers
Rahul
 
IP IP Logged
Duncan3
Newbie
Newbie
Avatar

Joined: 10 Jun 2009
Location: United States
Online Status: Offline
Posts: 6
Quote Duncan3 Replybullet Posted: 11 Jun 2009 at 2:42pm
Thanks but that didnt work wht i need is
 

Location ID

Order ID

           Customer ID

       DATE

 

2E-2E

44250

906113

 03/02/2009

2 East

2W-2W

44329

906101

 03/02/2009

2 West

2W-2W

44190

906105

 03/02/2009

2 West

2W-2W

44291

906106

 03/02/2009

2 West

2W-2W

44260

906116

 03/02/2009

2 West

3W-333

44243

906112

 03/02/2009

3 West

NONE

44199

906106

 03/02/2009

None

NONE

44208

906108

 03/02/2009

None

NONE

44239

906112

 03/02/2009

None

SUR-S009

44197

905812

 03/02/2009

 

SUR-S2W1

44220

906106

 03/02/2009

 

 

 

 

 

 

 I need to group the locations and for each customer ID  I only want see the first order and what location it went to. I don’t want to count any other order after the first order id per customer



Edited by Duncan3 - 11 Jun 2009 at 2:44pm
IP IP Logged
rahulwalawalkar
Senior Member
Senior Member
Avatar

Joined: 08 Jun 2007
Location: United Kingdom
Online Status: Offline
Posts: 731
Quote rahulwalawalkar Replybullet Posted: 12 Jun 2009 at 7:01am
Hi
 
a bit confused now,
I only want see the first order and what location it went to ,can you let us know how do you determine which is the first order in group?
 
Cheers
Rahul


Edited by rahulwalawalkar - 12 Jun 2009 at 7:01am
IP IP Logged
Duncan3
Newbie
Newbie
Avatar

Joined: 10 Jun 2009
Location: United States
Online Status: Offline
Posts: 6
Quote Duncan3 Replybullet Posted: 12 Jun 2009 at 8:56am

There is only one customer ID number. Each customer could have multiple order id’s. The order id numbers are sequential. So for each customer weo nly want the first order id for that customer. The tricky part is the grouping of the location because one customer could have multiple orders going to different locations. We only want to count the first order from each customer and total those by location

Can this be done with out counting the 2nd or 3rd order or location  form a singal customer?
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.031 seconds.