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     [CLOSED]Report Painter Overiding doc format
Go
New
Search
Notify
Tools
Reply
  
[CLOSED]Report Painter Overiding doc format
 Login/Join
 
Platinum Member
posted
Is there a way to keep report painter from overriding my Doc format.

I prefer to use

 ON TABLE SET ONLINE-FMT '&DOCFORMAT' 
  

OR

  ON TABLE SET ONLINE-FMT PDF  


In the first case when exiting out of painter it wipes out the whole line.

In the second case it changes it to a PCHOLD file.

Any help.

Thanks

Dan

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


IBM Main Frame: MVS, FIX, VSAM

Windows SQL

WF 7.7
 
Posts: 147 | Registered: June 24, 2006Reply With QuoteReport This Post
Virtuoso
posted Hide Post
The first question of course is why you prefer to use the set online-fmt statement over the pchold statement.
Second question is: have you tried to say PCHOLD FORMAT &FORMAT?


GamP

- Using AS 8.2.01 on Windows 7 - IE11.
in Focus since 1988
 
Posts: 1960 | Location: Netherlands | Registered: September 25, 2007Reply With QuoteReport This Post
Platinum Member
posted Hide Post
The reason I like it is because it is easier to view the report as it finishes and then save it to file if it is acceptable.

No I have not used that one.


IBM Main Frame: MVS, FIX, VSAM

Windows SQL

WF 7.7
 
Posts: 147 | Registered: June 24, 2006Reply With QuoteReport This Post
Guru
posted Hide Post
quote:
Originally posted by moyer1dl:
The reason I like it is because it is easier to view the report as it finishes and then save it to file if it is acceptable.

No I have not used that one.


i don't understand why it would be much different so ill turn GamP's question on its head:

is there any reason why you can't use ON TABLE PCHOLD FORMAT?


Developer Studio 7.64
Win XP
Output: mostly HTML, also Excel and PDF

"Never attribute to malice that which can be adequately explained by stupidity." - Heinlein's Razor
 
Posts: 285 | Location: UK | Registered: October 26, 2007Reply With QuoteReport This Post
Platinum Member
posted Hide Post
PCHOLD Format doesnt bring the report up on the screen automatically. I have to hunt it down to where ever it saves it.


IBM Main Frame: MVS, FIX, VSAM

Windows SQL

WF 7.7
 
Posts: 147 | Registered: June 24, 2006Reply With QuoteReport This Post
Expert
posted Hide Post
PCHOLD says "bring the output back to the client". This should be the browser. I don't understand what you mean by having to hunt it down whereever it saves it.
TABLE FILE CAR
SUM SALES
BY COUNTRY
-*ON TABLE SET ONLINE-FMT PDF
ON TABLE PCHOLD FORMAT PDF
END

These two lines produce the same output.

Am I missing the point?


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, 2006Reply With QuoteReport This Post
Platinum Member
posted Hide Post
What I mean is when I use PCHOLD I just get a message that gives me the statitics of the report and says it has been saved. How many records and how many lines on the browser it does not produce the report. In fact I have never been able to locate where the report goes. I have searched on my pc and in the project folders and it is no where to be found. It basically goes to oblivion.


IBM Main Frame: MVS, FIX, VSAM

Windows SQL

WF 7.7
 
Posts: 147 | Registered: June 24, 2006Reply With QuoteReport This Post
Virtuoso
posted Hide Post
As Ginny said: PCHOLD FORMAT xxx and OFFLINE-FMT xxx are the same and produce the same output - the results are sent back to the client, whatever this client is. If you use ON TABLE HOLD (so without the PC) then you get the behaviour you describe. The results are being held in the default location, which is one of the agent directories in the edatemp folder, and when the agent finishes, the temp directory gets cleared. So then it looks as though it goes into oblivion - but only after the agent finishes.
You can see that the file gets created if you do a SET TEMPERASE=OFF in your fex. That will prevent the clearing of all files after the agent finishes and allows you to view the contents of the temporary folder.


GamP

- Using AS 8.2.01 on Windows 7 - IE11.
in Focus since 1988
 
Posts: 1960 | Location: Netherlands | Registered: September 25, 2007Reply With QuoteReport This Post
Guru
posted Hide Post
i dont use mainframe but the way i understand it is that PCHOLD returns the report to the client wheras HOLD saves it as a ftm file on the server, and HOLD FORMAT XFOCUS saves it XFOCUS file on the server...

as others have said here so personally im confused that on mainframe you've never had a report returned as html to your browser using ON TABLE PCHOLD FORMAT HTML


Developer Studio 7.64
Win XP
Output: mostly HTML, also Excel and PDF

"Never attribute to malice that which can be adequately explained by stupidity." - Heinlein's Razor
 
Posts: 285 | Location: UK | Registered: October 26, 2007Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED]Report Painter Overiding doc format

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