CODEWITHSUNDEEP
bi-publisher
Raphaël
Raphaël

Reputation: 173

BiPublisher Sheet name of .xpt report when outputting as excel

Currently, when displaying (downloading) my .xpt bipublisher report as a .xlsx, my only sheet's name is Sheet1. I would like to rename it.

I know you can create xls templates directly and simply rename the sheet, but I'd need to recreate the whole report...

Upvotes: 0

Views: 3197

Answers (2)

Alejandro Hernandez
Alejandro Hernandez

Reputation: 1

Using a RTF you can actually created multi-sheet excel file and also you can rename the sheet. In order to create multiple sheet you need the following instruction:

<?split-by-page-break:?>

And before that instruction you need you use this one:

<?spreadsheet-sheet-name: xpath-expression?>

Next some examples:

<?spreadsheet-sheet-name: {concat(.//name, '')}?> --> It concatenates
<?spreadsheet-sheet-name: {.//name}?>   --> It only use the XML field
<?spreadsheet-sheet-name: {normalize-space(upper-case(.//name))}?> --> It applied a trim and upper functions

In my case in my XML data file, i have this field called "name" in a third level:

<sales>
 <division>
 <name>Groceries</name>
 <year>2014</year>
 <totalsales>3810</totalsales>
 <costofsales>2100</costofsales>
 </division>
 <division>
...

Upvotes: 0

Moonpie
Moonpie

Reputation: 287

For RTF templates, you can specify a spreadsheet-sheet-name command.

This is from the Oracle Fusion Middleware Report Designer's Guide for Oracle Business Intelligence Publisher - 11g Release 1 (11.1.1) regarding RTF templates:

<?spreadsheet-sheet-name: xpath-expression?>

Where xpath-expression is an XPath expression or a string constant.

The example given is:

<?spreadsheet-sheet-name: {concat(.//YEAR, ' ',.//STATE)}?>

(The guide for 12.2.1 has the same; I do know know about anything prior to 11.1.1.)

Upvotes: 0

Related Questions