hi, please forgive me if i mentioned wrongly on subject of this topic
my requriement is we have Departments and under a department there are sections and then designations, we want to show section total and after all sections ends in a department this will show departments total
i have created a report of dept and emp tables, here i tried to have aggregation with column breaks, selected 2 columns for break deptno and job, and it is showing sum only on job and not deptno, how i can have department totals in addition to job totals? and also report show a grand total.
ws: ptmws
developer
Infra123
app: TESTS
page: 14 - IR - With 2 Tables