nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

field cascading grouping in Report Queries - BI publisher

Gor_Mahia

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

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

any suggestion is appreciated

...thanks.

Find more posts tagged with

Reporting

Accepted answers

All comments

Venkat Thota - BIP

please upload xml and layout , will send you updated , thanks

Gor_Mahia

YGUTTIKONDA,

ive attached a sample xml and template files - please take a look and let me know . Maybe i need to duplicate rowset to fill the page.

====================================xml=======================================

<?xml version="1.0" encoding="UTF-8"?>

<ROW>

<NUMBER_GROUP>354545</NUMBER_GROUP>

<ID_VAL>8902</ID_VAL>

<SCORE_RATE>67</SCORE_RATE>

<TAG_NUMBER>34465656</TAG_NUMBER>

<EMP_NAME>CALIFORNIA DEPT INSURANCE</EMP_NAME>

<CONT_CNT>1</CONT_CNT>

</ROW>

<ROW>

<NUMBER_GROUP>45001</NUMBER_GROUP>

<ID_VAL>4511</ID_VAL>

<SCORE_RATE>89</SCORE_RATE>

<TAG_NUMBER>6799</TAG_NUMBER>

<EMP_NAME>CALIFORNIA DEPT INSURANCE</EMP_NAME>

<CONT_CNT>3</CONT_CNT>

</ROW>

<ROW>

<NUMBER_GROUP>354545</NUMBER_GROUP>

<ID_VAL>8902</ID_VAL>

<SCORE_RATE>95</SCORE_RATE>

<TAG_NUMBER>57001</TAG_NUMBER>

<EMP_NAME>ALINNA HEALTH CARE</EMP_NAME>

<CONT_CNT>1</CONT_CNT>

</ROW>

<ROW>

<NUMBER_GROUP>354545</NUMBER_GROUP>

<ID_VAL>8902</ID_VAL>

<SCORE_RATE>95</SCORE_RATE>

<TAG_NUMBER>57001</TAG_NUMBER>

<EMP_NAME>ALINNA HEALTH CARE</EMP_NAME>

<CONT_CNT>1</CONT_CNT>

</ROW>

</ROWSET>

</DOCUMENT>

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

thank you.

group ROW by TAG_NUMBER

Employee No: TAG_NUMBER Emp Name: EMP_NAME

Created by: []

Number Of Group Records	Amount
Number Of Group Records	Amount
CONT_CNT	AMNT

ID	Task Order Number	Score %
G V IF NUMBER_GROUP RS	F ID_VAL	SCORE_RATE E E

page breakend ROW by TAG_NUMBER

Gor_Mahia

3591335

i dont know why i need sub template. Pls note iam done with PART#1 above my problem is PART#2 -i.e. Repeating header details on long manager groups( Pls see above comment...).

thanks.

Venkat Thota - BIP

check below document , https://blogs.oracle.com/xmlpublisher/entry/dynamic_report_titles

Dir_Pal

Y dont u create a subtemplate and call that sub template in rtf which might help.

Venkat Thota - BIP

Did you apply same with your template ? this will definetly works , unfortunately i dont have your xml and rtf to modify ,Thanks

Gor_Mahia

Venkat-BIP

i show this before but it will be better if the link to the sample template was working but its not ---> [ You can find the sample templates, data and outputs here. ]

my only problem at this time is to repeat header details on every page for long running group records.

regards,

Enock.

Venkat Thota - BIP

venkythota54@gmail.com

Gor_Mahia

Hi,

its like attachment is not allowed except image/link? so annoying

Gor_Mahia

Venkat

can i have your email since the file attachment is not allowed here...regards