Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 214 Oracle Analytics News
- 42 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
BI Publisher - Detect change of page

Summary
BI Publisher - Detect change of page
Content
Hi all,
Is it possible to know or detect that the page has changed in the a report?
I have a table generated with a variable number of rows based on the following data:
<G_TABLE>
<G_ROW>
<INFO_1>42157777_1</INFO_1>
<INFO_2>Blab bla bla_1</INFO_2>
<INFO_3>ncmvnmcnvmnvmncv_1</INFO_3>
<INFO_4>uiouiouioyioouioi_1</INFO_4>
<INFO_5>uj585jj4838j3_1</INFO_5>
</G_ROW>
<G_ROW>
<INFO_1>42157777_2</INFO_1>
<INFO_2>Blab bla bla_2</INFO_2>
<INFO_3>ncmvnmcnvmnvmncv_2</INFO_3>
<INFO_4>uiouiouioyioouioi_2</INFO_4>
<INFO_5>uj585jj4838j3_2</INFO_5>
</G_ROW>
<G_ROW>
<INFO_1>42157777_3</INFO_1>
<INFO_2>Blab bla bla3</INFO_2>
<INFO_3>ncmvnmcnvmnvmncv_3</INFO_3>
<INFO_4>uiouiouioyioouioi_3</INFO_4>
<INFO_5>uj585jj4838j43_3</INFO_5>
</G_ROW>
... With many more rows so that the table will not fit in one page!
</G_TABLE>
What I would like to do is that, on the final report, the data of the first <G_ROW> block (42157777_1, Blab bla bla_1, ...) is displayed as first visible data row (first after the header row) in the table on every page!
Thanks in advance of your answers.
Best regards.
Lilian
Answers
-
Lilian,
From what i understand you want the only 20 lines or 25 lines (FIXED NUMBER of lines) displayed on each page ?
please see the below blog post
https://blogs.oracle.com/xmlpublisher/anatomy-of-a-template-i-fixed-row-enumeration
hope this helps !!
0