Labels

"Milestone Summary" portlet is not sorta
1
9.62 GUI installation
2
Ad
8
Adding Developer name field from Object type...
1
Admin
64
Admin Console
10
Agile
7
AlreadyInOctane
0
Analyze Assignment Load
1
AOL
2
API
12
Approval from email notification
2
Approve Time
7
Approved Budget User Data Fields
1
Assignment update using position update ...
2
Attachment with notification
2
Audit Logs
7
Audit Trail
5
Authentication
5
Autofill
2
background service restart
1
Bar chart
4
Certification
6
Change Project Name
1
CHPERPDBA@mountsinai.org
1
Clear cache issue wrt RequestRulesUserLibrary...
1
Closed Project
3
Confirmation
9
Copy_Header's_User_Data_Default_No
2
cost health icon
1
Dashboard Usability
13
Dashboards
19
Databases
7
decimals
4
Demand Management
34
department
1
deployment
8
Display info on logon page
1
Enabling Floating License
1
Export to PDF
7
exporting to PDF and Excel
7
Feature Request
68
Field Type
7
file attachment
4
Filters
10
Financial & Staffing Profile
17
Financial Summary
27
FinancialSummaryAPI
2
Github
1
Global KPI
3
Import from excel to Table component
3
in-line editing
2
Include use
11
Idea ID: 2878302

Ability to generate PowerPoint / Word / Excel reporting generating one slide/page/folder for each row retrieved

silviocri
Status: Accepted

To be tentatively delivered in PPM 24.3 (July)

See status update history

Hi All

I would like to have the ability to generate a Power Point or Word or Excel reporting (at least one option) where, based on SQL, for each row retrieved a slide or page or folder is generated and populated with the information retrieved in the row

For example, the query can be a list of programs and the Power Point report will generate one pptx generating one slide for each program; in the slide info. for the specific program like program manager, program health, start date etc etc are published on the slide. The same for the word reporting where a single word page is generated for each program and/or the same for the excel reporting where a single folder is generated for each program.

See also the discussion    https://community.microfocus.com/devops-cloud/proj-port-mgmt/f/discussions/526996/powerpoint-reporting-by-sql-query-where-is-the-sql-executed-in-the-powerpointdemo-pptx-template 

  •   in reply to Etienne Canaud 

    Hi,

    Finally I managed to find a way to get this to work in MS Word Reports too, so I'll set the whole Idea as "Accepted". There's still some limitation in the fact we cannot duplicate sections with complicated objects (images, charts, etc.), but it works fine with Text paragraphs (with formatting) and tables, so it should cover the simple reporting use cases.

    Nested loops are supported in both PowerPoint & Word reports. By this, I mean that you can have let's say a first loop that repeat some paragraphs (word) or slides (powerpoint) for each PPM Project, and within these sections you can have a sub-part (Slides/Table rows/Paragraphs) that would be repeated to list all the issues for each project. This is interesting as it opens the possibility to do some pagination in PowerPoint, for example by listing 10 issues per slide, and include as many slides as needed to list all the issues if they exceed 10 for a project. 

  •  

    Hi Silvio,
    FYI, there will tentativley be a capabiltiy to repeat slides (or group of slides) in powerpoint reports in PPM 24.3 (July release). This will involve some limitations on the slides copied this way (no picture, no chart. no hyperlink unless it's created with the $@...@ tag). No plan to support it for Word yet however, as things are a bit more complicated there.

Resources

Support
Documentation
Learning Services
Partner Programs
Privacy
Compliance
Help
Company
Privacy Policy
Terms of Use
Cookies Preferences
Accessibility
Anti-Slavery Statement
Support
Contact Us
Careers
Code of Business Conduct and Ethics
The opinions expressed above are the personal opinions of the authors, not of OpenText. By using this site, you accept the Terms of Use. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.), Hewlett Packard Enterprise Company, or Micro Focus. As of January 31, 2023, the Material is now offered by OpenText, a separately owned and operated company. Any reference to the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks is historical in nature and the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks are the property of their respective owners.