Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Using the Report Caster Tables to build a Job Scheduler Report
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] Using the Report Caster Tables to build a Job Scheduler Report
 Login/Join
 
Member
posted
Hello, I'm a new guy to the forum, so please play nice...
I have written a Web FOCUS Job Scheduler report using the 'BOT' tables from Report Caster. It has a Table of Contents and links between the TOC and the requested report page. It works pretty well, but I'm having an issue that's preventing me from finishing the report.

I can't seem to locate the data for the 'Summary' field on the Properties Tab in Report Caster. I've dumped every table into a file, one by one. I can't see any sign of 'Summary' data in the BOT tables.

I would like to send a screenshot, but I haven't figured out how to do that on Focal Point.

Report Caster--> Schedule--> Properties--> Summary. Any ideas where the Summary data resides?

Any help would be greatly appreciated.

Stan Moss

This message has been edited. Last edited by: FP Mod Chuck,


8008, Windows, PDF, HTML,
XLSX
 
Posts: 4 | Registered: May 09, 2018Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Hi Stan

Welcome to Focal Point... We always aim to play nice! I think you will find it a helpful place to get answers to your development questions.

I also looked at all the tables and can't find the summary data either. I have pinged the product manager to find out where it resides and will post his reply when I get it.


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 1506 | Location: Customer Support | Registered: April 12, 2005Reply With QuoteReport This Post
Member
posted Hide Post
Thanks for the help, Chuck!


8008, Windows, PDF, HTML,
XLSX
 
Posts: 4 | Registered: May 09, 2018Reply With QuoteReport This Post
Member
posted Hide Post
I opened a case about this a few months ago.

"After doing further research, the summary field is stored in the WF_NLSOBJ table."

Vince

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


WebFocus 8.2.01
Windows 2016
XLSX, HTML, PDF
 
Posts: 9 | Registered: October 12, 2011Reply With QuoteReport This Post
Member
posted Hide Post
Thank you, VinceCSW. We added the synonym for WF_NLSOBJ and I'm able to dump the file and see the Summary data. However, I don't know how to tie this table to any of the others. I've tried running 'finds' against the BOT tables, looking for what I presume to be the key from the WF_NLSOBJ table, with no success. Would you be so kind as to give me the case number for the Summary issue? It may tell me what I need to know. Thanks for the help.
stanm


8008, Windows, PDF, HTML,
XLSX
 
Posts: 4 | Registered: May 09, 2018Reply With QuoteReport This Post
Expert
posted Hide Post
Joining HANDLE in WF_REPOSOBJ to IBFSID in BOTSCHED should do it for you.

T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.06 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
 
Posts: 5577 | Location: United Kingdom | Registered: April 08, 2004Reply With QuoteReport This Post
Member
posted Hide Post
Thanks, Tony A. That did the trick! Appreciate the help.
stanm


8008, Windows, PDF, HTML,
XLSX
 
Posts: 4 | Registered: May 09, 2018Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Using the Report Caster Tables to build a Job Scheduler Report

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.