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

Gaurav Bhardwaj11111 · Jul 13, 2017 7:00AM

Summary

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 · Jul 20, 2017 7:00AM

Are you sure you are in the right community?

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

MFA for Oracle Community

Oracle Analytics Cloud and Server

Categories

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

Summary

Content

Answers