PPT Report Type Editor

• This section captures the basic attributes of the PPT Report type

• This section captures filters that the end-user can use when running the report.

Template Structure

• A single-row datasource is expected to return only a single row of data. For example, the following datasource returns the value of a filter called 'Division'

select '[P.DIVISION]' division from dual

• A multi-row datasource is expected to return 1 or more rows of data. To display the rows in the presentation, a table needs to be added in the slide with headers and referring to the tokens from the datasource. 

• The tokens should be suffixed '_X' to indicate that the rows will repeat. 

• The following table shows an example of a table showing risks which uses a datasource with scope 'RISK'. The datasource fetches 5 columns: ID, Title, Impact, Likelihood, Status

• Besides the standard approach to run a PPT Report as detailed in the Reports End User Guide it is possible to place a hyperlink in a Content Area to run a PPT Report Export. When configuring these hyperlinks it will be necessary to pass in any Filter Tokens via the URL used.

• See an Example below of some HTML which places an icon into a Content Area which runs a PPT Export when clicked:

<div class="office_ppt_icon ppt_icon_style"                                                 

onclick="location.href='/Reports/Slide_Export.jsp?report_def_id=ABC&REPORT_ID=100">

</div>                                                                                      

<style>                                                                                     

.ppt_icon_style {                                                                           

height: 70px;                                                                       

width: 70px;                                                                        

background-repeat: no-repeat;                                                       

cursor: pointer;                                                                    

background-position: center;                                                        

background-size: 40px;                                                              

margin: 0 auto;                                                                     

}                                                                                           

</style>                                                                                    

• Data from multiple entities can be collated into slides and can be exported into a single PPT Report with a single click.

• This requires that the Datasources being used by the PPT Report Type having a Grouping Column Name so that it can separate out the different entities.

<div class="office_ppt_icon ppt_icon_style"                                                         

onclick="location.href='/Reports/Slide_Export.jsp?report_def_id=ABC&REPORT_ID=100,200,300">

</div>