[CLOSED] How to include a field value on a column heading

Focal Point

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/659109931

June 04, 2009, 03:34 PM

webmeister

[CLOSED] How to include a field value on a column heading

I want to be able to print a field's or parameter's value in a column heading. What I'm currently trying to use is:

SEM_ANT_HRS  AS '<TERM Ant,Hrs'

Is this the correct way to put a value onto a column heading?

Thank you in advance

This message has been edited. Last edited by: Kerry,

Mainframe FOCUS 7.0
VM/CMS and MVS/TSO

June 04, 2009, 05:02 PM

Francis Mariani

You cannot embed column data in a column title, but you can embed a Dialogue Manager variable:

SEM_ANT_HRS AS '&SEMAINE Ant,Hrs'

If the column data value is the same for the whole report, you may TABLE the data, -READ the value and put it in a Dialogue Manager variable.

Francis

Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server

June 04, 2009, 05:48 PM

Darin Lee

See this recent post for a couple ideas you might try

Regards,

Darin

In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat

June 05, 2009, 04:48 AM

<JJI>

quote:
See this recent post for a couple ideas you might try

Darin, are you sure this is the right link. This post is about Excel compound!!!

June 05, 2009, 08:22 AM

PBrightwell

Try setting your column titles as a heading or subheading.

Pat
WF 7.6.8, AIX, AS400, NT
AS400 FOCUS, AIX FOCUS,
Oracle, DB2, JDE, Lotus Notes

June 05, 2009, 11:51 AM

Darin Lee

quote:
This post is about Excel compound

Yes. The question wasn't as much about excel compound as how to get a data value in the column title.

Regards,

Darin