The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

How to run report from WF execution step?

Highlighted
Semenov Alexand
Esteemed 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
Honored 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
Honored Contributor

Re: How to run report from WF execution step?

//Add this to "OnDomLoad" event