In-Table List with Filtering Grouping and Ordering in Presentation Document

In-Table List with Filtering, Grouping, and Ordering in Presentation Document

In-Table List with Filtering, Grouping, and Ordering in Microsoft PowerPoint Document

Creating a In-Table List with Filtering, Grouping, and Ordering

Practising the following steps you can create In-Table List with Filtering, Grouping, and Ordering Template in MS PowerPoint 2013.

  1. Add a new presentation slide.
  2. Press “Insert” tab to insert the table.
  3. Insert a 2x2 table.
  4. Save the template.

Reporting Requirement

As a report developer, you are required to represent managers’ contract information with the following key requirements:

  • Report must show each manager along with sum of prices of his contracts.
  • It must represent all the information in tabular form.
  • Report must be generated in the Presentation Document.

Adding Syntax to be evaluated by GroupDocs.Assembly Engine

Manager

Contract Price

<<foreach [in getContracts()

    .where(c => c.getDate().getYear() + 1900 == 2015)

    .groupBy(c => c.getManager())

    .orderBy(g => g.key.getName())]>><<[key.getName()]>>

<<[sum(c => c.getPrice())]>><</foreach>>

Download In-Table List with Filtering, Grouping, and Ordering Template

Please download the sample In-Table List with Filtering, Grouping, and Ordering document we created in this article:

Generating The Report

ODP Template and Report in Apache OpenOffice

In order to check compatibility of ODP between Microsoft Office 2010 and Apache OpenOffice 4.1.2, we performed below tests:

  • We opened the ODP template created through Microsoft Office 2010 in Apache OpenOffice 4.1.2. The template opened successfully in Apache OpenOffice without any issues or formatting losses.
  • We opened the ODP report generated through GroupDocs.Assembly in Apache OpenOffice 4.1.2. The report opened successfully in Apache OpenOffice without any issues or formatting losses.