Can you add a field value to a column title 2

[David Beagan 2]

@Erin.Trotter, your previous post on this was closed to further answers. So I created this post.

Not sure if that was the intent. But I did want to comment that your line of code:

-READ RPTMNTH &RPTMNTH.A20;Should be

-READ RPTMNTH &RPTMNTH.A20.Although could still be a problem if the A20 is not right.

You might want to consider using -READFILE instead of -READ.

[Erin Trotter]

I got it to work with the car file, but with my file, it's just not working. Still shows the square where the column title should be even when I changed the semi-colon to a period. Here's the example with the car file.

 

 

 

TABLE FILE ibisamp/car

BY CAR.COMP.CAR

BY CAR.BODY.DEALER_COST

WHERE CAR.COMP.CAR EQ 'BMW';

ON TABLE HOLD AS CARNAME

END

-RUN

-READ CARNAME &CARNAME.A20;

-TYPE &CARNAME

 

-DEFAULTH &WF_SUMMARY='Summary';

-DEFAULTH &WF_TITLE='WebFOCUS Report';

TABLE FILE ibisamp/car

BY CAR.COMP.CAR NOPRINT

BY CAR.BODY.DEALER_COST AS 'Brand of car is &CARNAME

BY CAR.CARREC.MODEL

BY CAR.ORIGIN.COUNTRY

WHERE CAR.COMP.CAR EQ 'BMW';

ON TABLE PCHOLD FORMAT HTML

ON TABLE NOTOTAL

ON TABLE SET CACHELINES 100

ON TABLE SET STYLE *

INCLUDE=IBFS:/FILE/IBI_HTML_DIR/ibi_themes/Warm.sty,$

TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, SUMMARY=&WF_SUMMARY.QUOTEDSTRING, ORIENTATION=LANDSCAPE, $

ENDSTYLE

END

[Erin Trotter]

And thank you so much. I'm new to this community board... Used focal point back when it was Information Builders and don't have the hang of this one yet.