Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Call report caster schedule from HTML page

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] Call report caster schedule from HTML page
 Login/Join
 
Tim P.
Platinum Member
posted
We have an interesting request to call a RC schedule from an html page. The big issue we are facing is how to pass parameters to it. We are using RC because we have to email multiple excel compound reports at once. The user population also does not have access to the RC schedule, they want it all in one interface.

With a fex you can just concatenate variables to the end of the url and it passes those variables, with a schedule it does not, it seems to just ignore them.

Anyone ever tried something like this?

This message has been edited. Last edited by: Tim P.,


WebFOCUS App Studio 8.2.02
Windows 7, All Outputs
 
Posts: 141 | Location: Mclean, VA | Registered: December 04, 2012Report This Post
Tom Flynn
Expert
posted Hide Post
Hi Tim,
Why use RC?
Look into EDAMAIL, we use it, works great...
Tom


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
 
Posts: 1972 | Location: Centennial, CO | Registered: January 31, 2006Report This Post
Tim P.
Platinum Member
posted Hide Post
We looked into EDAMAIL and it doesn't allow for multiple attachments in one email, at least as far as we can tell. If that is untrue by all means please share.

I will confirm EDAMAIL does work great for other applications however, used it a lot.


WebFOCUS App Studio 8.2.02
Windows 7, All Outputs
 
Posts: 141 | Location: Mclean, VA | Registered: December 04, 2012Report This Post
Tom Flynn
Expert
posted Hide Post
OK, not tried with multiple workbooks, that could be a huge email! Zip them up into 1?
We allow users to create RC schedules, so, never tried outside the IBI module...
Good Luck!


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
 
Posts: 1972 | Location: Centennial, CO | Registered: January 31, 2006Report This Post
Tim P.
Platinum Member
posted Hide Post
Yea it is 6 or 7 compound excel sheets that's why it's a bit complicated.

We did think of the zip idea but i'm not even sure how we would zip up all the reports into one file on the fly.


WebFOCUS App Studio 8.2.02
Windows 7, All Outputs
 
Posts: 141 | Location: Mclean, VA | Registered: December 04, 2012Report This Post
Waz
Expert
posted Hide Post
You can call RC from Restful Web Services, its all in the documentation


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Tim P.
Platinum Member
posted Hide Post
Waz,
We sadly do not have restful web services available.

We tried a bunch of different things, global variables, foccache, set statements, none seemed to work.

Our solution was to populate a permanent hold file with the values we need, use that to populate the values needed in the report, run the RC job and then remove the hold file after the RC job is done. I used an ajax call from inside the htmlcomposer to call the schedule from the html page on a button click. Slightly messy but it gets the job done so i'd call it a solution.

Can't always be squeaky clean with WF...


WebFOCUS App Studio 8.2.02
Windows 7, All Outputs
 
Posts: 141 | Location: Mclean, VA | Registered: December 04, 2012Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Call report caster schedule from HTML page

Copyright © 1996-2020 Information Builders