Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Iterate through a list of customer orders Post Reply Post New Topic
Author Message
keithrichards
Newbie
Newbie


Joined: 30 Jun 2010
Location: Australia
Online Status: Offline
Posts: 31
Quote keithrichards Replybullet Topic: Iterate through a list of customer orders
     Posted: 02 Jul 2010 at 12:47am

Hi all,

 

Just wondering if anybody is able to share a suggestion on how I can iterate through a list of customer orders and only count the orders that are based on a date range.

 

Currently I have a group based on CUSTOMER with a formula field containing the following ;

 

Count ({ORDER_NUMBER},{CUSTOMER})

 

Currently this counts all the orders each customer has made.

 
What I want to achieve is to add a date range criteria to this that will only return the number of orders that meet that criteria.
 
Many thanks,
 
KR
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: 02 Jul 2010 at 2:06am

Hi,

*I would suggest to create Date range parameters
*Start Date and End Date
*Then in record selection formula check {Table.DateField} in {?StartDate} to {EndDate} please check for exact synatx.
*Thats all so when you run the report you will be prompted  to select Start Date and EndDate select accordingly once done you will get count of order number per customer for selected Date Range
 
hope this is what you looking for
 
Cheers
Rahul


Edited by rahulwalawalkar - 02 Jul 2010 at 2:07am
IP IP Logged
keithrichards
Newbie
Newbie


Joined: 30 Jun 2010
Location: Australia
Online Status: Offline
Posts: 31
Quote keithrichards Replybullet Posted: 02 Jul 2010 at 2:19am

Thanks for the feedback,

I have been down that track but as the data is in two different tables I can't use this technique... hence the work around.
 
Thanks anyway.
 
KR
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: 02 Jul 2010 at 2:50am
Hi
Is is not possible to join the tables on common field and then use both the tables in the report?
 
Join could be Inner, Or Left or Right Outer Join depending on what needs to be displayed in the report.
 
Cheers
Rahul
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.