Project and Portfolio Management Practitioners Forum
cancel

How to run report from WF execution step?

Highlighted
Semenov Alexand
Acclaimed Contributor.

How to run report from WF execution step?

Hi All! I use 7.5 sp 5.

I need run report from WF execution step but i don't know needed command!

Also i want to link this report to project request as Attachment.

I complete this task with request to request.
But how it possible for report and request?
Many thanks in advice!!!!!
2 REPLIES
Erik Cole
Acclaimed Contributor.

Re: How to run report from WF execution step?

Hi,

I think what you would need to do is make a shell script that handles all of this, and call it from your execution.

You would need to:

- get the next available report number from the sequence
- direct your report's SQL output to an html file using the correct filename (tip: you can also write html query output to a filename ending in .xls and it will then open in Excel by default)
- compose the proper URL for the report, and add it as a URL attachment to your project request
Jason Nichols K
Acclaimed Contributor.

Re: How to run report from WF execution step?