Creating HEADINGS for EXL2K output 1

[LeonelSanchezJr]

I have a heading in my report FEX which creates a HEADING for EXL2K output.

The heading looks like this:
(column letters appear on top for your readability)

A B C D E
Date Range Selected 01-JAN-04 thru 15-JUL-04

I have columns A and B merged, however, I would like everything in ONE column. My problem is due to columns C and E are input parameter values, therefore, they appear in separate columns.

Can I load the TEXT and the input parameters (<START_DATE and <END_DATE) into one TEXT field and have it appear as a HEADING in EXL2K?


Thanks,

Leo ;-)

 

[WFGuru]

Why not put everything into one defined field?

HEADER/A100 = 'Date range selected ' | EDIT(START_DATE) | 'thru ' EDIT(END_DATE);

You would have to do more than EDIT to get the dates formatted correctly but if they are input parameters, just use the &variables.

HEADER/A100 = 'Dates selected from &START_DATE thru &END_DATE ';

OR

TABLE FILE fn
"Dates selected from &START_DATE thru &END_DATE

 

[LeonelSanchezJr]

Great idea, however, I don't know if I could use a Define Field since I am peforming a direct SQL passthru to Oracle and then the returned record set is being printed as such:

TABLE FILE SQLOUT
PRINT FIELD1
FIELD2
FIELD3
END

What did you mean in the "OR" portion of your answer?


Thanks,

Leo ;-)

 

[WFGuru]

I mean just insert the &variables into your heading instead of using fields. If you want a defined field, you could create a define against the SQLOUT.