I have been working on a report I like to call "subreport hell" at the moment.
Its a bit brutal and a little crude right now, but its almost doing exactly as designed
I am having trouble as I have a grid of subreports which are going away and extracting data for each historical year back to 2008 based on a value trn_cde.
The subreports all pass variables back to the main report for summing for each record.
Howver I am having trouble zeroing out the variables for the next record. Do subreports not run on a per record basis?
The first record is correct, but the subsequent records each have some values from the last record still being added up.
Can anybody offer advice. Its so close to be how I want it!
Screenshot shows all the subreports and the totals.
Its a bit ugly there are variables for each subreport passed back.