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] Submit report under MRE to report caster

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] Submit report under MRE to report caster
 Login/Join
 
mtguy
Member
posted
Hi ,
In one application we need to give to the user the possibility to schedule the current report to report caster .
The report it is located under MRE .
Any sugestions ?!
I am using webfocus 7.6.1 under unix

Best regards,
MtGuy

This message has been edited. Last edited by: Kerry,


WF 7.6.2 , iWay 5.5 , Sun Unix , Windows XP , .NET , Oracle , SQL Server and more
 
Posts: 24 | Registered: December 05, 2007Report This Post
Prarie
Virtuoso
posted Hide Post
Do you not want the user to have access to ReportCaster? You can set them up a Job they can execute with DSTRUN. You will need to do some research on how to do that. You should be able to find it here on the Forum.


In Focus since 1993. WebFOCUS 7.7.03 Win 2003
 
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005Report This Post
Darin Lee
Virtuoso
posted Hide Post
If you give the user "Schedule" capabilities (under user administrator) they can schedule their own jobs whether or not the job is in MRE. If that is too much functionality, you can use the API to create your own scheduling app. I believe the 7.6 version now allows you to easily add a schedule button to a launch page for easy access to RC after running a report.


Regards,

Darin


In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat
 
Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007Report This Post
mtguy
Member
posted Hide Post
Hi ,
I don't wanna give access to the report caster console . The client will be in the section filter page for the report , in this page they have a button for the caster job .

Regards,
MtGuy


WF 7.6.2 , iWay 5.5 , Sun Unix , Windows XP , .NET , Oracle , SQL Server and more
 
Posts: 24 | Registered: December 05, 2007Report This Post
PBrightwell
Master
posted Hide Post
Can you run deferred instead of through Report Caster? Is your UNIX email active?


Pat
WF 7.6.8, AIX, AS400, NT
AS400 FOCUS, AIX FOCUS,
Oracle, DB2, JDE, Lotus Notes
 
Posts: 755 | Location: TX | Registered: September 25, 2007Report This Post
dlogan
Platinum Member
posted Hide Post
You could always do a modify to the ReportCaster tables to create/update a run time of a report in ReportCaster.

This method is technically not supported, but the table structure isn't that complicated so its not that hard to do.

Otherwise writing something in the API would be best.


WF 71.x, 76.x, 7701, 8.0 Beta OS: Linux, Win2k3, Win2k, Win2k8, WinXP


 
Posts: 203 | Registered: November 19, 2007Report This Post
mtguy
Member
posted Hide Post
Hi DLogan ,
I tried already this direction , the problem is the
report caster installation , i can't see the tables botsched ,..
We have full license and this tables should be there.
I tried too another direction by using reportcaster webservices
but it is crashing everytime .

Regards,
MtGuy


WF 7.6.2 , iWay 5.5 , Sun Unix , Windows XP , .NET , Oracle , SQL Server and more
 
Posts: 24 | Registered: December 05, 2007Report This Post
dlogan
Platinum Member
posted Hide Post
Are you using the same userid to connect to the database that ReportCaster is using? On 7.6.2 ReportCaster wouldn't even start if the repository tables were not there. As a result they should be present.


WF 71.x, 76.x, 7701, 8.0 Beta OS: Linux, Win2k3, Win2k, Win2k8, WinXP


 
Posts: 203 | Registered: November 19, 2007Report This Post
GinnyJakes
Expert
posted Hide Post
Mr. Logan is correct. You must verify that RC is working properly. Have you run the testcfg script? Have you brought up and logged into the reportcaster.jsp page? If you can't do either of those, you have a more serious problem than the one this post is for. Please verify that you have a solid RC installation and then run a successful RC job before continuing with this task.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report This Post
mtguy
Member
posted Hide Post
Hi,
I was able to find the report caster tables . I have just one small question , what is the algorithm for NEXTRUNTIME calculation from botsched table . I want to calculate this time before to insert the record into repocaster table .

Thanx!
MtGuy

This message has been edited. Last edited by: mtguy,


WF 7.6.2 , iWay 5.5 , Sun Unix , Windows XP , .NET , Oracle , SQL Server and more
 
Posts: 24 | Registered: December 05, 2007Report 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] Submit report under MRE to report caster

Copyright © 1996-2020 Information Builders