Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
field cascading grouping in Report Queries - BI publisher — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

field cascading grouping in Report Queries - BI publisher

Received Response
9
Views
21
Comments
edited Sep 11, 2019 5:18AM in Oracle Analytics 21 comments

Summary

field cascading grouping in Report Queries - BI publisher

Content

Hi,

 

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.

 

PART#1: (DONE)

============================================================

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:

=========================

Country: USA

Dept: Sales

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!