MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Edit codes in QMF Forms

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Database
View previous topic :: View next topic  
Author Message
hari_uss
Beginner


Joined: 19 Dec 2002
Posts: 78
Topics: 6
Location: Trivandrum, India

PostPosted: Sun Feb 12, 2006 12:17 pm    Post subject: Edit codes in QMF Forms Reply with quote

I don't have much experience in the QMF Forms. So apologies if this question sounds too easy!

I am retrieving following details from the table for a particular company with settlement date as yesterday.

Item
Invoice number
Amount


I need to put the details in a report. Company and settlement date come in the header and rest of the elements form the detail lines. [My query retrieves all the above mentioned items plus Company and settlement date.]

Form for this was developed by another group. I could see that they have used OMIT as the usage code for company and settlement date. When I create the report, if the query had retrieved any data, report looks okay. Otherwise, company and settlement date are printed as &1 and &2 respectively [1 and 2 are the sequence numbers for company and settl date in the form].

How can I suppress this and display the actual company and settlement date in the header line? Any edit code will be useful for that?

NB: Column names are given in bold.
Back to top
View user's profile Send private message Send e-mail
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12378
Topics: 75
Location: San Jose

PostPosted: Mon Feb 13, 2006 8:43 am    Post subject: Reply with quote

hari_uss,

I don't quite understand the question. If your intention is to add headers then you can try this

Run your query in QMF and then press PF9. In the bottom section of the screen you will see the options to add headers and footers.

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Database All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group