View previous topic :: View next topic |
Author |
Message |
hari_uss Beginner
Joined: 19 Dec 2002 Posts: 78 Topics: 6 Location: Trivandrum, India
|
Posted: Sun Feb 12, 2006 12:17 pm Post subject: Edit codes in QMF Forms |
|
|
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 |
|
 |
kolusu Site Admin

Joined: 26 Nov 2002 Posts: 12378 Topics: 75 Location: San Jose
|
Posted: Mon Feb 13, 2006 8:43 am Post subject: |
|
|
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 |
|
 |
|
|