| View previous topic :: View next topic |
| Author |
Message |
kgodhula
Beginner
Joined: 22 Jul 2004
Posts: 3
Topics: 2
|
 Posted: Thu Jul 22, 2004 8:40 pm Post subject: Export QMF Report |
 |
|
I have exported a QMF Report of 200+ pages to a dataset in HTML format and sorted to remove the HTML tags. When I print the dataset the report is printed continuously without the specified page breaks mentioned in the QMF Form.
It is not required to print the report from QMF environment that would give the required results. But, I need to FTP the file to a destination and it will be printed there. They don't use Mainframe.
I want to print on new page whenever the number of rows reaches 60. I specified this in QMF Profile. I want to have all the print control and page control characters exported to dataset.
How can I achieve this one? I would appreciate if someone could advise me. |
|
| Back to top |
|
 |
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12378
Topics: 75
Location: San Jose
|
| Posted: Fri Jul 23, 2004 5:57 am Post subject: |
|
|
kgodhula,
| Quote: |
I have exported a QMF Report of 200+ pages to a dataset in HTML format and sorted to remove the HTML tags.
|
Why do you have to export in HTML format and then once again comeback and remove the tags?
1. Execuete your query in QMF
2. Press PF9(FORM)
3. code your headings and footers if you have any
4. Press PF12(Report)
5. The report will be displayed
6. Press PF4(print)
This will create a dataset with your results.The dataset name is
Now you can ftp the dataset or download the dataset to the PC or even you can even print the dataset using the option 3.6(hard copy)
Hope this helps...
Cheers
Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu |
|
| Back to top |
|
|
kgodhula
Beginner
Joined: 22 Jul 2004
Posts: 3
Topics: 2
|
| Posted: Tue Jul 27, 2004 12:34 am Post subject: |
|
|
| kolusu wrote: | kgodhula,
| Quote: |
I have exported a QMF Report of 200+ pages to a dataset in HTML format and sorted to remove the HTML tags.
|
Why do you have to export in HTML format and then once again comeback and remove the tags?
1. Execuete your query in QMF
2. Press PF9(FORM)
3. code your headings and footers if you have any
4. Press PF12(Report)
5. The report will be displayed
6. Press PF4(print)
This will create a dataset with your results.The dataset name is
Now you can ftp the dataset or download the dataset to the PC or even you can even print the dataset using the option 3.6(hard copy)
Hope this helps...
Cheers
Kolusu |
Hi Kolusu,
Thanks for your time and solution. Your solution did trigger more appropriate solution for my particular requirement. You are right when I want to print the report into a dataset as one off job. As I need to automate the process for scheduling I diverted the QMF print out put to the dataset using
QMFBATCH.DSQPRINT DD DSN=&ENV....etc in the JCL. |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
