DATE PARAMETER SELECTION

[apples]

Hi,
I am using a date range parameter in a report. The table has 2 date fields on which I have a seperate running totals. I am using the same date parameter to calculate in both cases in the formula section under evaluate.
I am using crystal 8.01
The formula in both cases is :

{date1.table} < {?Invoice date Period}

{date2.table} < {?Invoice date Period}
This is just not giving me the desired results.
Any help greatly appreciated
Thanks
Sonia

 

[kenhamady]

Are you trying to include the record if either is less, or if BOTH are less. Crystal uses an AND condition by default, and you might need to change it to an OR condition in the selection formula.

If this isn't it, explain how the results are wrong. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Guide to Crystal in VB

http://www.kenhamady.com/

- tek@kenhamady.com

 

[synapsevampire]

Create 2 running totals and in the evaluate use a formula section of each place your formulas, it should provide the correct results.

If you want to limit the entire report to just those rows, place the following in the record selection formula:

{date1.table} < {?Invoice date Period}
or
{date2.table} < {?Invoice date Period}

-k

 

[apples]

Perhaps I should explain a bit, there is only 1 formulae in each of the running totals each one looks at a different date field and calculates the necessary amounts for that date field.

I have other running totals in the report using the same date parameter but I use the operator 'in' and the dates are being pulled through correctly.

The Invoice date period is for eg 01/02/2003 - 28/02/2003
when I use the < would the formulae know only look at dates less than or equal to 31/01/2003

Sonia

 

[kenhamady]

It should.
You didn't explain how the results are currently wrong. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Guide to Crystal in VB

http://www.kenhamady.com/

- tek@kenhamady.com