Jump to content

Can you add a field value to a column title 2


David Beagan 2

Recommended Posts

@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.

Link to comment
Share on other sites

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

Link to comment
Share on other sites

×
×
  • Create New...