Skip to Content

Is it possible to dynamically toggle report type between report and input form?

Experts, we are using EPM 10.0 MS. We have a sheet with 3 reports and we want to dynamically set each reports behavior as either report or input form based on user selection. I have looked through the available APIs and EPM functions but don't see anything that accomplishes this. The only function that appeared to possibly do the job is the EPMReportsOptions functions but it apparently does not support this one options. Any feedback or guidance is appreciated.

Thank you,


Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Apr 07, 2016 at 07:36 AM

    Hi Hitesh,

    Refer EPM User guide topic Options42.4.3.1 SetSheetOption


    Add comment
    10|10000 characters needed characters exceeded

    • Hi Hitesh,

      you can switch from input sched to report using api and vba

      Dim api As Object

      Set api = Application.COMAddIns("FPMXLClient.Connect").Object

      api.SetSheetOption Sheet1, 1, False '(true = input sched, false= report)

      see please the paragraph of the epm Add-in user guide for all the the sheetoptions available via api.