0 pts.
 Variable Report Heading in Query/400
I use Query/400 to produce a report which has a "control number" in the report heading. This number is stored in a one-record file and also in a data area. The number is used for information only; it does not control data selection. Is there any way to access this information and put it in the report header? Thanks for any responses.

Software/Hardware used:
ASKED: October 6, 2004  8:34 AM
UPDATED: October 18, 2009  10:40 AM

Answer Wiki:
Yes, If you select your "control number" file in your Query with the *ALL option as matching criteria, then your control number will be available on ALL records of your report. So you should be able to use it into your header. ====================================================================== I don't know of a way to get a variable value into headings of a Query/400 query. However, if you convert it to a QM query, you can use the &col text variable syntax to place that column value in any heading line you create. The value could be obtained by joining to your one-record file or simply by passing it in as a parameter to the query and referencing the substitution variable in the SELECT that's created. I think it needs to be referenced in the reporting in detail lines, but detail printing it can be suppressed simply by assigning a zero width. Tom
Last Wiki Answer Submitted:  October 18, 2009  10:40 am  by  Guillet   0 pts.
All Answer Wiki Contributors:  Guillet   0 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _