EPM function for opening Report Editor

[Former Member]

Hi All,

I am looking for macro that can be used for opening a report editor. EPM tab has been disabled for users so I need to create a different option in custom ribbon.  The OpenReportEditor opens the editor to create a new report option whereas I want the editor to open the existing report in edit mode.

Below is the code I used to open the editor using macro.

Dim client As Object

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

client.OpenReportEditor

Any suggestions please?

Thanks,

Pratap

[Former Member · Accepted solution]

Hi Pratap,

Please use below code....It opens Edit report for current report! Tested!

Dim EPMobject As New FPMXLClient.EPMAddInAutomation

Sub Button5_Click()

EPMobject.OpenEditReport

End Sub

Regards,

JP

[former_member186338 · Accepted solution]

Yes, correct!

[Former Member · Accepted solution]

Hi JP&,

Thanks for suggesting the function.

Looks like it EPM version dependent as its not working on EPM Add-in SP18.

Regards,

Pratap

[former_member186338 · Accepted solution]

EPM Add-in SP18 is very old, upgrade required...

[Former Member · Accepted solution]

Hi Pratap..

Have you used the same code which I have suggested or just replaced OpenEditReport???

What is the error your getting if you say not working???

I have tested on EPM Add-In SP25......upgrade your EPM to latest.

Regards,

JP

[Former Member · Accepted solution]

Yes, it works on Sp25.

I need to deal with different issue of upgrading EPM for all.

anyway, at least we have a solution now.

Thanks for your suggestion.

Regards,

Pratap

[Former Member]

Hi Pratap,

As JP & suggested it completely works perfect, adding to this if you have multiple technical reports place the cursor in the respective cell of which report you want to edit and click on the button.

Thanks.

[former_member186338]

Unfortunately it's a bug: OpenReportEditor will always open as a new report.

You can open case with SAP support.

[Former Member]

Hi Vadim,

I have logged this with OSS.

Lets see if they can help.

-Pratap