Skip to Content
0
Former Member
Nov 04, 2009 at 05:59 AM

Grouping Problem - Total doesnot match

24 Views

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