PPM : Word Report can handle conditional statements?

Hi Team,

For Word reports in PPM, we could see looping in WordReportDemo document but is conditional (if else) statements will also be supported in word report?

If so, can we get the syntax for it.

We want to implement something like, block or table should be visible in word report only when certain condition is satisfied.

 

Regards,

Lavanya P M

  • Suggested Answer

    0  

    Hi Lavanya,

    There's no "buillt-in" solution, but you could easily emulate it with a List that would retrieve 1 record if your SQL condition is true, and 0 record if it is false:

    $# conditions | SQL | select 1 from dual where <insert your condition here > #

    $[ condition : conditions : WORD_FROM ]

    ... Your word paragraph here to be inserted only if the condition is true ...

    $[ WORD_TO ]

    This way the paragraph will NOT be inserted at all if the condition is false, and will be inserted once if the condition is true.

    However, I'm not sure whether this will work if you have complex stuff in your paragraph such as table or pictures (a corrupted word document may be generated in that case) - but it should definitely work if you only have text and lists, even formatted.

  • 0   in reply to   

    Replying to myself to confirm that this solution does work - I've successfully used it for a PPTX Report where we only wanted to show a specific slide ("Path to Green") in a Project Status deck if the Project Status is not Green.