Focal Point
[SHARE] Print Out a Job List in Report Caster

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

July 16, 2013, 03:17 PM
Guang
[SHARE] Print Out a Job List in Report Caster
Hello All,

I got a request from my user asking for a report including all of scheduled job in Report Caster. Does anyone know how to do that? I look through the online help, and try to run a report from ReportCaster API. But no data showed up, and got an error.

I apprecate in advance for any help.

Guang
July 16, 2013, 04:35 PM
prodrigu
Try looking at the below tables:

BOTSCHED
BOTTASK
BOTDEST


Prod: WebFOCUS 7.7.03: Win 2008 & AIX hub/Servlet Mode; sub: AS/400 JDE; mostly Self Serve; DBs: Oracle, JDE, SQLServer; various output formats
July 16, 2013, 05:07 PM
Guang
Hi Prodrigu,

I can not see those tables in either iWay or Developer Studio. Please let me know where I can find those tables so I can build a fex to print out a report.

Many thanks for help.

Guang
July 17, 2013, 08:40 AM
CLH
First you need to know where your report caster tables are stored. Sql server, Oracle, Focus files.

Once you have that information you can set up connections to the data and run reports on the tables.

The "Reportcaster development and administration" guide has information on the tables and what information is contained in them.


Webfocus 8.0.7 on Windows