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,

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?

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.

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?

PCHOLD Format doesnt bring the report up on the screen automatically. I have to hunt it down to where ever it saves it.

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?

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.

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.

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