on 04-06-2011 12:43 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.