Hi Silvio,

I'm glad that you're looking into PowerPoint Reports!

To find the SQL that's executed to get the data, check the name of the variable that is read from to list its information - from your screenshot of slide #10, the "list variable" that is read is "all_programs". 

Another way to read $[ program : all_programs : TABLE ] is: "Read all the values in the list variable "all_programs", and for each value, insert it as a line on this TABLE and make the row avaiable as the variable "program" .

You can then find the declaration of the list variable "all_programs" on the first screenshot you shared, in the comments section:

$# all_programs | DATASOURCE | Programs List #  , which could be read as: "Take all the values returned by PPM Dashboard Datasource "Programs List" and put them in the list variable "all_programs"."

So, here's your answer: The SQL that's being run is whatever SQL is defined in the Dashboard Data Source "Programs List". It's always a good practice to create some Dashboard Datasources whenever retrieving data from PPM DB for reports, but if you just want to run a SQL query, there are some examples later in the comments section of your first screenshot. It's important to get that the first name after the "$#" opening tag is the name of the list variable in which the values will be stored, and that you will later be able to retrieve and list with the $[ .... ]  tag.

Note that there's a help section that's worth reading about PowerPoint (and Word) reports in the PPM online help, however the most helpful resource still is this example report that you've already run, where you can compare the template with the result to understand how things are working.

One more thing: I strongly advise you to also check and run the word report demo template - it demonstrates the same mechanisms, but with more examples and more explanations - since almost all the tags and mechanisms are the same, it's definitely worth a look.

One more thing from my side.

I woull like to have a PowerPoint report (preferred) or a Word report (second option) to have a page for each entity.

For example, a PowerPoint (or Word) page for each program retrieved by the query. As general purpose example, in the page I would like to have the Program Name and the Program Manager.

Is this something obtainable by this type of report ?

 If yes, can you share a debugTemplate1 (pptx and/or docx) to implement such requirement ?

Hi Silvio,

This is not possible at the moment. Iterating list of data can only be inserted in tables or lists, not pages or slide(s) - at least not yet. Feel free to submit some idea or ER to get that considered in a future release.