Show sub-report in group footer of main report
Posted: 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
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