Show sub-report in group footer of main report

robinpearce · Post by **robinpearce** » Fri May 08, 2009 7:58 am

Hello,

Sorry to trouble you again but I have another question.

I have a report with 2 datasources - call them Employees and Expenses. Both datasources contain a Department column and I have linked the 2 datasources on Department. The requirement is to group the employees by department. i.e show a department header, a list of employees in that department, and then in the department footer list all the expenses for that department.

I have tried creating a sub-deport for the expenses but cannot get it to work. I need to put the subreport in the emplyees footer but when I do that I cannot select the Master Component from within the sub-report. Perhaps I should not be using a sub-report.

Have you any ideas how I can achieve this ?

Best regards
Robin

Post by **Edward** » Tue May 12, 2009 2:49 am

Hi Robin,

Yes, you are right, it is impossible with a subreport. Please place in the Group Footer Band a Container and then place a DataBand inside of this container. This must work as you expected.

Thank you.

robinpearce · Post by **robinpearce** » Tue May 12, 2009 3:45 am

Thank you so much - I didn't realise all I needed was a container in order to be able to place a databand in a footer. It now works perfect - thanks again.