Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Select Expert Post Reply Post New Topic
Author Message
CKrzacz
Newbie
Newbie
Avatar

Joined: 15 Jun 2011
Location: United States
Online Status: Offline
Posts: 15
Quote CKrzacz Replybullet Topic: Select Expert
     Posted: 26 Aug 2011 at 7:32am
Ok, so I have made a report with parameters of date and time so that we can see what our sales were in between the sets of dates given. In this report, we are also showing "Quantity of Items Shipped" and "Total Extended Price". My problem, is that the Qty Shipped and Total Ext Price isn't following the parameters of the date and time...

How would I go about fixing this so that they properly pull from the dates given?

Thanks!!!
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 26 Aug 2011 at 11:42am
What did you put in your select expert?
How are those two pieces of data related to your sales date data? Are they in different tables? Did you join those tables correctly?
IP IP Logged
CKrzacz
Newbie
Newbie
Avatar

Joined: 15 Jun 2011
Location: United States
Online Status: Offline
Posts: 15
Quote CKrzacz Replybullet Posted: 29 Aug 2011 at 2:21am 
{invoice_hdr.invoice_date} in {?BegInvDate} to {?EndInvDate}


Is what I have in Select Expert -- Group

Basically, what I'm trying to do is have my Grand Total pull from the Date Parameters given, rather than it pulling from day one of the first recorded sale...which is where I apparently am doing something wrong.
IP IP Logged
CKrzacz
Newbie
Newbie
Avatar

Joined: 15 Jun 2011
Location: United States
Online Status: Offline
Posts: 15
Quote CKrzacz Replybullet Posted: 29 Aug 2011 at 2:49am
To clarify what I am "trying" to do. 

sum({invoice_line.qty_shipped} in {?BegInvDate} to {?EndInvDate})


I am trying to get my details section to sum up the total quantity shipped within the date that I have given. I know this formula is wrong..I just don't know how to properly put it to have it work.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 29 Aug 2011 at 3:47am

Crystal will not let you put conditions on the summary. You can use one of 3 techniques.

1. A formula to convert the data from the value to a 0 if the row is outiside your desired range and then sum the formula field
if {invoice_hdr.invoice_date} in {?BegInvDate} to {?EndInvDate} then {invoice_line.qty_shipped} else 0
Sum this for formula field to get the total
2. variable formulas to conditionally include or exclude each row when summing. Lots of examples of these in the forum but not my preferred process (although probably the most popular one).
3. Create a Running Total (note running totals and variable formulas do not work in headers, only details and footers)
Select new running Total
name = whatever you want
field to summarize= {invoice_line.qty_shipped}
type =Sum
evaluate = use a formula
{invoice_hdr.invoice_date} in {?BegInvDate} to {?EndInvDate}
reset = never (for a grand total)
Place in report footer
 


Edited by DBlank - 29 Aug 2011 at 4:12am
IP IP Logged
CKrzacz
Newbie
Newbie
Avatar

Joined: 15 Jun 2011
Location: United States
Online Status: Offline
Posts: 15
Quote CKrzacz Replybullet Posted: 29 Aug 2011 at 4:02am
*phew*

Thank you so much!
IP IP Logged
waterg2
Newbie
Newbie
Avatar

Joined: 29 Oct 2010
Online Status: Offline
Posts: 10
Quote waterg2 Replybullet Posted: 29 Aug 2011 at 7:39am
DBlank
 
I just have to say that was a superb explanation you gave!!!! Very clear and easy to understand.
 
Smile
waterg2
IP IP Logged
bradjordan111
Newbie
Newbie
Avatar

Joined: 11 Sep 2011
Online Status: Offline
Posts: 1
Quote bradjordan111 Replybullet Posted: 11 Sep 2011 at 8:23pm
Unable to gauge out whether Crystal Report 9.x is reqd as minimum or absolute in Windows Vista? if not then which version is required
Litobyte Softworks
Architect Webware / myESQL firmware
Unity Android, Wii QA
system backup & Easy HairstylesDeveloper
IP IP Logged
george.cousin88
Newbie
Newbie
Avatar

Joined: 23 Dec 2012
Online Status: Offline
Posts: 2
Quote george.cousin88 Replybullet Posted: 23 Dec 2012 at 4:04am
sounds good to me
Formal Hairstyles
IP IP Logged
george.cousin88
Newbie
Newbie
Avatar

Joined: 23 Dec 2012
Online Status: Offline
Posts: 2
Quote george.cousin88 Replybullet Posted: 23 Dec 2012 at 4:11am
Crystal Reports allows users to graphically design data connection(s) and report layout. In the Database Expert, users can select and link tables from a wide variety of data sources, including spreadsheets, databases, Enterprise business views, and local file system information.
Formal Hairstyles
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.