RTF template PDF ouput issue when using for-each-group@section

Apodapati2 · Jan 26, 2017 8:00AM

Summary

Content

Hello,

I have building RTF template, where we have issue generating blank PDF ouput when using for-each-group@section. error message: "There was an error opening this document. This file cannot be opened because it has no pages".

Details:

We have Datamodel containing only one dataset G_1, whenever there is no G_1 group data report should create blank page

sample XML looks like below when there is no data for dataset G_1 :

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

<DATA_DS><DIRECTORY_OUTPUT>/Shared</DIRECTORY_OUTPUT><P_INVOICE>1234</P_INVOICE>

</DATA_DS>

RTF template for example looks like:

<?for-each-group@section:G_1;./INVOICE_DIV?><?sort:current-group()/INVOICE_DIV;'ascending';data-type='text'?>

---------- Invoice Table Heading ----------------

Start Body ( using start body to repeat Invoice table heading on each page)

----------- Invoice Table values --------------

End Body

End G_1 by Invoice_DIV

if I remove the @section and use tag <?split-by-page-break:?>, the report generates blank page at the end when we have data in G_1.

Can you please suggest on how to get this sorted out.

Many Thanks

YGUTTIKONDA · Jan 26, 2017 8:00AM

Hello,

Just do a simple test like below ..

<?variable:countrow;count(G_1)?>

<?$countrow?>

<?if:$countrow>0?> HELLO<?end if?>

this is working .. Pl check

-- YG

Apodapati2 · Jan 26, 2017 8:00AM

I tried to use varaible and call outside for-each-group and inside for-each-group but I am still getting the same issue. Can you please see below correct me if I am doing wrong? can you elaborate a bit more where I need to define the variable and how I need to call if some thing wrong below?

<?variable:countrow;count(G_1)?>

<?if:$countrow>0?>

<?for-each-group@section:G_1;./INVOICE_DIV?><?sort:current-group()/INVOICE_DIV;'ascending';data-type='text'?>

---------- Invoice Table Heading ----------------

Start Body ( using start body to repeat Invoice table heading on each page)

----------- Invoice Table values --------------

End Body

End G_1 by Invoice_DIV

<?end if?>

YGUTTIKONDA · Jan 26, 2017 8:00AM

use a variable to count the rows .. and insert a IF statement to validate it and display blank page ..

<?variable:countrow;count(G_1)?> -- this is variable deceleration and using the count of the group (G_1 in this case)

<?$countrow?> -- Invoking the variable ..

Venkat Thota - BIP · Jan 27, 2017 8:00AM

follow below links

This is know issue,

https://blogs.oracle.com/xmlpublisher/entry/no_data_found

use <?if@section: not(//ID)?>No Data Found<?end if?> at last page...

Apodapati2 · Jan 27, 2017 8:00AM

I have attached a test sample XML and RTF files. can you please check.

YGUTTIKONDA · Jan 27, 2017 8:00AM

I didn't quite understand ... is your requirement as below

1) when there are no records you want to display a blank page ??

2) you want to insert a page-break for INVOICE_DIV ??

also lets forget abt #1 , did your page-break work in the past ??

upload your template and xml file.

--YG

Apodapati2 · Jan 27, 2017 8:00AM

the above one works if you dont use @section in for-each-group. but I need @section in the template to page break based on INVOICE_DIV. Did you try using @section?

Apodapati2 · Jan 30, 2017 8:00AM

This worked perfectly fine, the link was helpful. Many thanks

MFA for Oracle Community

Oracle Analytics Cloud and Server

Categories

RTF template PDF ouput issue when using for-each-group@section

Summary

Content

Answers