one month sales

[kris0517]

how do i get gross sales for june 1, 2002 to june 30, 2002?

 

[dgillz]

Your question leaves a lot to the imagination, but assumming you are querying a transaction table, write a formula something like this:

If {SalesDate} in date(2002,6,1) to date(2002,6,30) then {SalesAmont} else 0

Then sum this formula field as desired.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

dgilsdorf@trianglepartners.com

 

[Madawc]

In Crystal 8.5, do a Running Total, setting a formula to select between these dates. i.e.
>= date(2002, 6, 1) and <= date(2002, 6, 30)

Madawc Williams
East Anglia
Great Britain

 

[putts]

I'm assuming you have a Sales table somewhere in your database with each Sale Value and the Date it was sold.

Create two parameter fields:
preDate
postDate
(you could get away with just one, but this will allow for more flexibility)

In your Record Selection put this:

({DBDateField} >= {@preDate})
AND
({DBDateField} <= {@postDate})

Now just do an Insert/Running Total Fields and use your Sale Value as the Summary Field and Select Sum as the Type of Summary.

This value will be your Gross Sales.