for-each@section:DATA_SET do not generates PDF report if no data are found

User_64MLR

i am working on a report that has lots of parameters, it could happen that for some parameters inserted the reprot will not extract data to display.
i am using @section because i need data to be splitted by CUST_NUMBER.
so the report is working fine if soome data are extracted, but if no data are found, report is throwing error thata the PDF i'm trying to generate is corrupted.
i tried to use this:

<?if@section:not(DATA_SET)?>No Data Found<?end if?>
<?for-each@section:DATA_SET?>
<!-- all the rtf template related to my DATA_SET -->
<?end for-each?>

but is not working
can you please help?

Bhaskar Konar

for-each@section:DATA_SET do not generates PDF report if no data are found

User_64MLR

Apr 28, 2025

i am working on a report that has lots of parameters, it could happen that for some parameters inserted the reprot will not extract data to display.
i am using @section because i need data to be splitted by CUST_NUMBER.
so the report is working fine if soome data are extracted, but if no data are found, report is throwing error thata the PDF i'm trying to generate is corrupted.
i tried to use this:

<?if@section:not(DATA_SET)?>No Data Found<?end if?>
<?for-each@section:DATA_SET?>
<!-- all the rtf template related to my DATA_SET -->
<?end for-each?>

but is not working
can you please help?

---

View Post

Hi @User_64MLR,

Welcome to the Oracle Analytics Community.

Can you please check the following example to see if it help?

Thank you.

User_64MLR

@Bhaskar Konar this is not solving my issue since i am not using for-each:DATA_SET syntax.
i receive the error "The PDF you are trying to open is corrupted" and this is only happening when there are no data fetched in combination with @section syntax.