Grouping Structures (HELP!)

[josearturoramirez]

Hi, look at this case....

I have table with employees, accruals types and other where all accruals earned/used/expired is stores. My goal is this:

Group #1 EmployeeName
\
Group #2 Acrual Type + (Balance to date1) (*a)
\
Group #3 Startin accruals balance (since date1) (*b)
\
(*c) [Details of all transactions of this accrual type]
/
Group #3 Endnig accruals balance (to date2)
/
Group #2 Acrual Type + (Balance to date2) (*d)

*a: Balance to date is the sum of all balance accrued until date1.
*b: Starting Acruall means the amount of the first accrual transaction after date1
*c: Show s all accrual transaction during date1 and date2
*d: Balance to date in this case should use the same formula than *a, but until date2.


I almost get this goal, but i found a problem with a repeatring records in details...

 

[Madawc]

I'm not sure I follow. If you've got unwanted repeating records, the normal solution is to group them by the repeating value, show one set of details in the group header and suppress the details and group footer. In your case this would mean a 4th group inside the other three, which should not be a problem.

It helps to give your Crystal version, 8.5 or 9 or whatever, because sometimes this makes a big difference to what can be done.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[josearturoramirez]

ok, i'm closer the solution than before, now how can i avoid that the details repeat?

i'm getting something like this...

01/01/2000 (ACCTYPE) EARNED 100
01/15/2000 (ACCTYPE) USED 20
01/01/2000 (ACCTYPE) EARNED 100
01/15/2000 (ACCTYPE) USED 20

in some cases it repeats more than two times...

 

[Madawc]

Group by whatever it is that is EARNED or USED.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10