Focal Point
[SOLVED] Submit report under MRE to report caster

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/634108121

May 20, 2009, 03:13 PM
mtguy
[SOLVED] Submit report under MRE to report caster
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
May 20, 2009, 04:22 PM
Prarie
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
May 20, 2009, 05:49 PM
Darin Lee
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
May 21, 2009, 09:01 AM
mtguy
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
May 21, 2009, 09:18 AM
PBrightwell
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
May 22, 2009, 08:24 AM
dlogan
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


May 22, 2009, 12:36 PM
mtguy
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
May 26, 2009, 09:27 AM
dlogan
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


May 26, 2009, 10:47 AM
GinnyJakes
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
June 04, 2009, 02:25 PM
mtguy
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