Business Intelligence

Get Involved. Join the Conversation.

Topic

    Kumo70
    field cascading grouping in Report Queries - BI publisher
    Topic posted April 8, 2018 by Kumo70 Red Ribbon: 250+ Points, last edited May 7, 2018 by Arijit ChakrabortyBronze Trophy: 5,000+ Points, tagged BI Publisher 
    51 Views, 21 Comments
    Title:
    field cascading grouping in Report Queries - BI publisher
    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

    emp_name,   location Manager

    --------------------------------------

    ................................................

    ......             .......           ........

     

    Country: Canada

    Dept: HR

    emp_name,  location Manager

    --------------------------------------

    ..............................................

    ......             .......           ........

     

     

    3. here is my screenshot - note there are 2 cascaded grouping outer COUNTRY main grouping then within it DEPT child grouping as below

    pastedImage_0.png

     

     

    PART#2 (i need help on this pls)

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

    IAM PLANNING TO repeat the header information on every page. if records for a manager group contains many (fullname, title, salary) onto the next page then the header details (department) together with column headers should show at the top of the next page

    pastedImage_0.png

    any suggestion is appreciated

     

    ...thanks.

    Comment