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     Printing calculations without using any tables
Go
New
Search
Notify
Tools
Reply
  
Printing calculations without using any tables
 Login/Join
 
Silver Member
posted
Is it possible to print some calculations without using any tables?

Say I have some code like this. Can I create a report just to print these values? That way I can test some calculations based on current date without involving any tables yet.

-SET &WORKDATE = AYMD(&YYMD,0,'I8YYMD') ;
-SET &SAVEDATE=EDIT(&WORKDATE,'99999999$');
-SET &TIME8A = 'A2345678' ;
-SET &TIME8A = HHMMSS(&TIME8A) ;
-SET &TIMEBGN = &TIME8A ;
-SET &TIME6A = EDIT(&TIME8A,'99$99$99$');
-SET &SAVEDTTM= &SAVEDATE || '_' || &TIME6A;
-SET &SAVPATH = 'D:\file_' ;
-SET &HISTNAME = &SAVPATH || &SAVEDTTM || '.XLS' ;
END
-RUN


WebFOCUS 7.6.9
Windows
all output (Excel, HTML, PDF)
 
Posts: 42 | Registered: April 29, 2010Reply With QuoteReport This Post
Master
posted Hide Post
Josh,

If all you want to do is see the & output then I would use the -TYPE command. like this:
-TYPE WORKDATE --> &WORKDATE
-TYPE SAVEDATE --> &SAVEDATE
-TYPE TIME8A   --> &TIME8A
-TYPE TIMEBGN  --> &TIMEBGN
-TYPE SAVEDTTM --> &SAVEDTTM
-TYPE SAVPATH  --> &SAVPATH
-TYPE HISTNAME --> &HISTNAME  


Eric Woerle
8.1.05M Gen 913- Reporting Server Unix
8.1.05 Client Unix
Oracle 11.2.0.2
 
Posts: 750 | Location: Warrenville, IL | Registered: January 08, 2013Reply With QuoteReport This Post
Silver Member
posted Hide Post
Thanks! This is going to save me a huge headache.


WebFOCUS 7.6.9
Windows
all output (Excel, HTML, PDF)
 
Posts: 42 | Registered: April 29, 2010Reply With QuoteReport This Post
Virtuoso
posted Hide Post
If you start with

-SET &ECHO=ON;
You can see what you get

And the END command is here useless .




Frank

prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

 
Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Printing calculations without using any tables

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