How to use a totals file in a groupfooter
I have Header then a Groupheader and a Masterdata with a details file assigned per BookPeriod/AccountNo. This works oke. But I want the totals from de totals file (begin Balance changes and End balance, also a BookPeriod and accountNo). After every BookPeriod/AccounNo I only get the first record of the Totals file. Can anyone give a hint how to do this?
GroupHeader and/or MasterData expression? Which file? Details or Totals?