ListOfCellDocuments is only available with Financial Management or Oracle Essbase as the database connection.
ListOfCellDocuments is a text function that returns a list of all cell documents and their file attributes that a designer has selected to be retrieved from cells within a report. You can use this function in a text box, text cell or text cell heading.
In Financial Management or Oracle Essbase, documents are inserted into the data source cells of a report. The Financial Reporting designer selects the cells and chooses Retrieve Cell Documents on the property sheet. If those documents exist, they are appended to the report when printed or saved as a snapshot or PDF. to view the list of cell documents that exist, the designer adds the ListOfCellDocuments to the report in a text box, text cell or text cell heading.
<<ListOfCellDocuments (“GridName“, FileName&Description&PageNumber)>>
Returns the consecutive start page number of each cell document within the report. This is not necessarily the page number specified on the document. |
In the following example, two grids in the report are selected to print cell document information. In Grid1, the file name, description, and the consecutive start page number of the extracted cell documents are requested, in Grid2 only the file name and start page numbers are requested.
<<ListOfCellDocuments (“Grid1“, FileName&Description&PageNumber)>><<ListOfCellDocuments (“Grid2“, FileName&PageNumber)>>
The resulting list might look similar to the following, where Grid1 has two attached documents and Grid2 has one attached document:
April Variance High Volume Page3
April Variance Low Volume Page9
This function supports the Current keyword. For information and examples, see Current / Cur Keyword. |