Using xlsx-page-break-as-new-sheet in RTF Template

Gaurav Bhardwaj11111

Summary

Using xlsx-page-break-as-new-sheet in RTF Template

Content

Hello All

I am working on a RTF template to create multi sheet Excel Output in Oracle Cloud BI. Basically i want to create multiple sheet and name them based on report parameter.  I using below command within If statement. Spreadsheet name command is working fine but output is not splitting in separate sheet. Based on report data, i may want create just one sheet or 2 or 5 sheet. Is there any way to do it in rtf template?

Welcome  Report

<?spreadsheet-sheet-name: Document Control?>

 
 

<? If: REPORT_NEEDED1=’Y’ ?>  

A

Full Name	Person Number	Cvg Thru Dt	Relationship	Date Of Birth	Gender
F FULL_NAME7	PERSON_NUMBER7	CVG_THRU_DT7	RELATIONSHIP7	DATE_OF_BIRTH7	SEX7 E

<? xlsx-page-break-as-new-sheet?><?spreadsheet-sheet-name: A?>

<?end if?>

<? If: REPORT_NEEDED2=’Y’ ?>  

B

Full Name	Person Number	Hire Date	Legal Employer	Business Unit	Emp Category	Location
F FULL_NAME6	PER_NUM6	HIRE_DATE6	LEGAL_EMP6	BUSINESS_UNIT6	EMP_CATEG6	LOCATION6 E

<? xlsx-page-break-as-new-sheet?><?spreadsheet-sheet-name: B?>

<?end if?>

<? If: REPORT_NEEDED3=’Y’ ?>  

C

Full Name	Person Number	Life Event	Lf Evt Ocrd Dt	Le Status	Assignment Status Type
F FULL_NAME4	PER_NUM4	LIFE_EVENT4	LF_EVT_OCRD_DT4	LE_STATUS4	ASSIGNMENT_STATUS_TYPE4 E

<? xlsx-page-break-as-new-sheet?><?spreadsheet-sheet-name: C?>

<?end if?>

Any help would be highly appreciated!

Thanks

Gaurav

Hasso Schaap

Are you sure you are in the right community?

BI Publisher templates don't work in BICS? Do they?