on 11-04-2009 5:59 AM
Hi,
I am working on a requirement where I need to select records based on a specific date. The report is generated from a software where initally I will specify the Begin and End date based on which originally the records are selected.
Now the requirement needs to again select records with in a specific date range which falls between the Begin and End date I have already specified, I have did that too using a formula & using parameters like the following
{SAMPLETABLE.RELEASE_DATE} >= {?From} and {SAMPLETABLE.RELEASE_DATE} <= {?To}
Grouping is also carried about based on the original parameters (i.e., Begin & End date).
In the report footer we have three summary fields & the Total does not match with the sum in the details section after giving the Release date parameters.
To make more clear,
Let me say the From date as 01/01/1960 & the End date as 01/01/2009 & the number of records in this range is 4.
Name Release Date Field 1 Field 2 Field 3
Test1 1/1/1960 100 70 80
Test2 1/10/1990 52 98 74
Test3 1/11/1999 100 25 74
Test 4 1/1/2009 47 75 85
Total 299 268 313
If I give the release date between 1/10/1990 & 1/11/1999 it selects two records but the Total remains the same.
Name Release Date Field 1 Field 2 Field 3
Test2 1/10/1990 52 98 74
Test3 1/11/1999 100 25 74
Total 299 268 313
Can any one point me in right direction? Where I need to make change to get the total based on the selected records?
Thanks in advance,
Regards,
Karthi
Hi Karthi,
Running total will help you.. You can reset the runninig total by group if needs.
Regards,
Salah
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
10 | |
9 | |
9 | |
9 | |
6 | |
6 | |
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.