cancel
Showing results for 
Search instead for 
Did you mean: 

usage of date parameters in formula editor in crystal report

Former Member
0 Kudos

Hi,

I have to develope a crsytal report where I need to create 3 date parameters and filter the data according to parameter date selection. need to display a measure (amt) column using 3 parameter dates . Question is how to write a formula where I have to display sumof tha measure (amt) between parameter 2 and parameter 3 as a column, and sum of measure values upto parameter 1 and sum of measure (amt) greater than or equal to parameter 3 (date selection)

. parameters are dates . any answers will be highly appreciated.

Thanks in advance

Priyam

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

when you use parameters and place them in the record selection they will reflect the entire report

if you want to show values based upon that parameters selected you can do something like this

if date in parameter1 to parameter2 then value

it should only show the value if the date falls in the parameter range.

i would use the following to generate accurate formulas

MANUAL RUNNING TOTALS

RESET

The reset formula is placed in a group header report header to reset the summary to zero for each unique record it groups by.

whileprintingrecords;

Numbervar X := 0;

CALCULATION

The calculation is placed adjacent to the field or formula that is being calculated.

(if there are duplicate values; create a group on the field that is being calculated on. If there are not duplicate records, the detail section is used.

whileprintingrecords;

Numbervar X := x + ; ( or formula)

DISPLAY

The display is the sum of what is being calculated. This is placed in a group, page or report footer. (generally placed in the group footer of the group header where the reset is placed.)

whileprintingrecords;

Numbervar X;

X

Answers (0)