×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Creating HEADINGS for EXL2K output

Creating HEADINGS for EXL2K output

Creating HEADINGS for EXL2K output

(OP)
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   

RE: Creating HEADINGS for EXL2K output

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 "

RE: Creating HEADINGS for EXL2K output

(OP)
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   

RE: Creating HEADINGS for EXL2K output

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.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close