@MartinY: Thanks. So your change was just adding ".fex" right? Those 2 reports are XLSX format, and if Excel is open, then 2 reports to run, but it's two instances of the first report. If Excel has to be started, then only the first runs. So in either case, I'm not getting the 2nd report.
@Waz: they are on the reporting server for my contrived example, but my real use case is in the repository. What would be different about trying to do it from there, because that translation always trips me up.
Prod: 18.104.22.168, Dev/App Studio: 22.214.171.124 Dev:App Studio, Dev Studio 126.96.36.199 OS:Windows 7 Output:AHTML, Excel 2007
The life of a designer is a life of fight against the ugliness.
Posts: 138 | Location: North Carolina | Registered: August 10, 2012
Originally posted by J.Hines: @MartinY: Thanks. So your change was just adding ".fex" right? Those 2 reports are XLSX format, and if Excel is open, then 2 reports to run, but it's two instances of the first report. If Excel has to be started, then only the first runs. So in either case, I'm not getting the 2nd report.
Yes, only add ".fex"
Excel output !!! Not the same game. I thought that you were executing several fex to perform HOLD files, not produce Excel output file format. Not sure that you can to such a thing using EX. There is a few other technic to produce multiple Excel report but in one Excel file with multiple tabs, not multiple files. Except if you are using Report Caster.
WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF In Focus since 2007
Posts: 2347 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013
If the distribution of your documents is the same, run the job in report caster with each "EX" being a separate task. Report caster will return 1 report in a task. If there are multiple reports in a task, the task has to be split up, for example, task 1 collects data, task 2 is report 1, task 3 is report 2, etc. Each report can be a compound document.
If the distribution list for the reports are different, then you have to have Report Caster start the first job, then in the post processing or in the fex it self, have Report Caster fire off the next job, then that job fire the 3rd job and so on. There are several ways to do this. You may be able to use DSTRUN, or Restful Web Services or use MODIFY to update the next run date/time of the job in Report Caster. We use the last method. With WebFOCUS 8, IBI introduced the current security model and since we are a SSO shop, DSTRUN stopped working. It would even work with the alternate security zone. IBI identified a bug with the alternate security zone (vers 8.0.08) and it is supposed to be fixed now but we have already converted to updating the next run date/time and it works so we probably won't go back (we have 60 jobs that run this way). Depending on how your security is configured, it may or may not work. If you search the forum for DSTRUN you'll find a lot of discussions.
In FOCUS since 1985. Prod WF 8.0.08 (z90/Suse Linux) DB (Oracle 11g), Self Serv, Report Caster, WebServer Intel/Linux.
Posts: 958 | Location: Oklahoma City | Registered: October 27, 2006