Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
field cascading grouping in Report Queries - BI publisher
Answers
-
Venkat
loading the files is not possible due to sensitivity - can you please take a look at the above details i added.
thank you.
0 -
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"?>
<DOCUMENT>
<ROWSET>
<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>
<AMNT>995656</AMNT>
<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>
<AMNT>995656</AMNT>
<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>
<AMNT>6556565</AMNT>
<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>
<AMNT>6556565</AMNT>
<CONT_CNT>1</CONT_CNT>
</ROW>
</ROWSET>
</DOCUMENT>
==============================================================================
thank you.
Created by: []
Number Of Group Records
Amount
ID
Task Order Number
Score %
page breakend ROW by TAG_NUMBER
0 -
check below document , https://blogs.oracle.com/xmlpublisher/entry/dynamic_report_titles
0 -
Y dont u create a subtemplate and call that sub template in rtf which might help.
0 -
Did you apply same with your template ? this will definetly works , unfortunately i dont have your xml and rtf to modify ,Thanks
0 -
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.
0 -
-
Hi,
its like attachment is not allowed except image/link? so annoying
0 -
Venkat
can i have your email since the file attachment is not allowed here...regards
0
