field cascading grouping in Report Queries - BI publisher
Summaryfield cascading grouping in Report Queries - BI publisher
Please note the below part#1 ive done now and works BUT my problem is part#2 for long running group records which i need to repeat the header on every page.
iam relative new to Oracle BI publisher but iam trying to create a report query + template layout with grouping as below.
1. query like:
though not sure if this query will give me correct output...
select dept_name, emp_name, manager, country, location from Employees group by country.....
2. report printout should look like: