Hi,

I am using a multiverb request like below.
Here I am facing problem in styling like I am unable to catch the referenced field AVERAGE to give styling i.e.
I want to make the back color of the title of referenced field AVERAGE as grey color.

I tried to make it by using the below code:
----------------------------------------
TYPE=TITLE,
COLUMN=AVERAGE,BACKCOLOR='GREY',
$
----------------------------------------

But this is not happening in this way.

TABLE FILE CAR
SUM PCT.RETAIL_COST WITHIN COUNTRY
BY COUNTRY
BY BODYTYPE
ON TABLE HOLD AS THEDATA
END
-RUN
TABLE FILE THEDATA
SUM AVE.RETAIL_COST NOPRINT
BY BODYTYPE
SUM RETAIL_COST
BY BODYTYPE
ACROSS COUNTRY
COMPUTE AVERAGE/D3%=C1;
ON TABLE NOTOTAL
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=LANDSCAPE,GRID=OFF,
$
DEFMACRO=RED, MACTYPE=RULE, WHEN=FLG EQ 1,
$
TYPE=REPORT,
BORDER=LIGHT, GRID=ON, FONT='ARIAL', SIZE=8, COLOR='BLACK', BACKCOLOR='NONE',
$
TYPE=TITLE,
STYLE=BOLD, BACKCOLOR='GREY',BORDER=LIGHT,
$
TYPE=HEADING, BORDER=OFF,
$
TYPE=HEADING, LINE=1, SIZE=8, FONT='ARIAL', STYLE=BOLD, WIDTH=4.5,COLOR='WHITE',
$
TYPE=DATA,
BORDER=LIGHT, SIZE=8, JUSTIFY=CENTER, BACKCOLOR=( 'SILVER' 'WHITE' ),
$
TYPE=ACROSSTITLE,
JUSTIFY=CENTER, SIZE=8, BACKCOLOR='SILVER',BORDER=LIGHT,
$
TYPE=ACROSSVALUE,
JUSTIFY=CENTER, SIZE=8, BACKCOLOR='SILVER', STYLE=BOLD, BORDER=LIGHT,
$
TYPE=SUBTOTAL,
SIZE=8, COLOR='BLACK', STYLE=BOLD, BORDER=OFF,JUSTIFY=CENTER,
$
TYPE=REPORT,
WRAP=0.6,
$
TYPE=TITLE,
COLUMN=AVERAGE,BACKCOLOR='GREY',
$
END


Can any one please help me in this above.


Thanks in advance.

Ranjan

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

Hai Rajan,

Try the code given below,

<
TABLE FILE CAR
SUM PCT.RETAIL_COST WITHIN COUNTRY
BY COUNTRY
BY BODYTYPE
ON TABLE HOLD AS THEDATA
END
-RUN
TABLE FILE THEDATA
SUM AVE.RETAIL_COST NOPRINT
BY BODYTYPE
SUM RETAIL_COST
BY BODYTYPE
ACROSS COUNTRY
COMPUTE AVERAGE/D3%=C1;
HEADING
""
ON TABLE NOTOTAL
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=LANDSCAPE,GRID=OFF,
$
DEFMACRO=RED, MACTYPE=RULE, WHEN=FLG EQ 1,
$
TYPE=REPORT,
BORDER=LIGHT, GRID=ON, FONT='ARIAL', SIZE=8, COLOR='BLACK', BACKCOLOR='NONE',
$
TYPE=TITLE,
STYLE=BOLD, BACKCOLOR='GREY',BORDER=LIGHT,
$
TYPE=HEADING, BORDER=OFF,
$
TYPE=HEADING, LINE=1, SIZE=8, FONT='ARIAL', STYLE=BOLD, WIDTH=4.5,COLOR='WHITE',
$
TYPE=DATA,
BORDER=LIGHT, SIZE=8, JUSTIFY=CENTER, BACKCOLOR=( 'SILVER' 'WHITE' ),
$
TYPE=ACROSSTITLE,
JUSTIFY=CENTER, SIZE=8, BACKCOLOR='SILVER',BORDER=LIGHT,
$
TYPE=ACROSSVALUE,
JUSTIFY=CENTER, SIZE=8, BACKCOLOR='SILVER', STYLE=BOLD, BORDER=LIGHT,
$
TYPE=SUBTOTAL,
SIZE=8, COLOR='BLACK', STYLE=BOLD, BORDER=OFF,JUSTIFY=CENTER,
$
TYPE=REPORT,
WRAP=0.6,
$
ENDSTYLE
END
>

With Regards
Shobia.J

-----------------------------------
WF 7.6.1,WinXP,HTML

Hi Sobhia,

Thanks for the quick response.

This I have tried before in my report.
What happens here is as we are taking the advantage of some issues it creates other formating issues while doing some formatting like doing left justification of some columns and giving width to some other columns.

You can test the following code.


-------------------------------------
TABLE FILE CAR
SUM PCT.RETAIL_COST WITHIN COUNTRY
BY COUNTRY
BY BODYTYPE
ON TABLE HOLD AS THEDATA
END
-RUN
TABLE FILE THEDATA
SUM AVE.RETAIL_COST NOPRINT
BY BODYTYPE
SUM RETAIL_COST
BY BODYTYPE
ACROSS COUNTRY
COMPUTE AVERAGE/D3%=C1;
HEADING
""
ON TABLE NOTOTAL
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=LANDSCAPE,GRID=OFF,
$
DEFMACRO=RED, MACTYPE=RULE, WHEN=FLG EQ 1,
$
TYPE=REPORT,
BORDER=LIGHT, GRID=ON, FONT='ARIAL', SIZE=8, COLOR='BLACK', BACKCOLOR='NONE',
$
TYPE=TITLE,
STYLE=BOLD, BACKCOLOR='GREY',BORDER=LIGHT,
$
TYPE=HEADING, BORDER=OFF,
$
TYPE=HEADING, LINE=1, SIZE=8, FONT='ARIAL', STYLE=BOLD, WIDTH=4.5,COLOR='WHITE',
$
TYPE=DATA,
BORDER=LIGHT, SIZE=8, JUSTIFY=CENTER, BACKCOLOR=( 'SILVER' 'WHITE' ),
$
TYPE=ACROSSTITLE,
JUSTIFY=CENTER, SIZE=8, BACKCOLOR='SILVER',BORDER=LIGHT,
$
TYPE=ACROSSVALUE,
JUSTIFY=CENTER, SIZE=8, BACKCOLOR='SILVER', STYLE=BOLD, BORDER=LIGHT,
$
TYPE=SUBTOTAL,
SIZE=8, COLOR='BLACK', STYLE=BOLD, BORDER=OFF,JUSTIFY=CENTER,
$
TYPE=REPORT,
WRAP=0.6,
$
TYPE=REPORT,COLUMN=E02,JUSTIFY=LEFT,
$
ENDSTYLE
END
---------------------------------------

I need to justify some particular columns to left.This is the mandatory requirement along with that too.

For which I am searching for a way to catch that particular column 'AVERAGE' to make the backcolor GREY.

It would be a great help if u or anybody can help me out in this issue.

Thanks,
Ranjan.

quote:

Originally posted by SHOBIA:
Hai Rajan,

Try the code given below,

<
TABLE FILE CAR
SUM PCT.RETAIL_COST WITHIN COUNTRY
BY COUNTRY
BY BODYTYPE
ON TABLE HOLD AS THEDATA
END
-RUN
TABLE FILE THEDATA
SUM AVE.RETAIL_COST NOPRINT
BY BODYTYPE
SUM RETAIL_COST
BY BODYTYPE
ACROSS COUNTRY
COMPUTE AVERAGE/D3%=C1;
HEADING
""
ON TABLE NOTOTAL
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=LANDSCAPE,GRID=OFF,
$
DEFMACRO=RED, MACTYPE=RULE, WHEN=FLG EQ 1,
$
TYPE=REPORT,
BORDER=LIGHT, GRID=ON, FONT='ARIAL', SIZE=8, COLOR='BLACK', BACKCOLOR='NONE',
$
TYPE=TITLE,
STYLE=BOLD, BACKCOLOR='GREY',BORDER=LIGHT,
$
TYPE=HEADING, BORDER=OFF,
$
TYPE=HEADING, LINE=1, SIZE=8, FONT='ARIAL', STYLE=BOLD, WIDTH=4.5,COLOR='WHITE',
$
TYPE=DATA,
BORDER=LIGHT, SIZE=8, JUSTIFY=CENTER, BACKCOLOR=( 'SILVER' 'WHITE' ),
$
TYPE=ACROSSTITLE,
JUSTIFY=CENTER, SIZE=8, BACKCOLOR='SILVER',BORDER=LIGHT,
$
TYPE=ACROSSVALUE,
JUSTIFY=CENTER, SIZE=8, BACKCOLOR='SILVER', STYLE=BOLD, BORDER=LIGHT,
$
TYPE=SUBTOTAL,
SIZE=8, COLOR='BLACK', STYLE=BOLD, BORDER=OFF,JUSTIFY=CENTER,
$
TYPE=REPORT,
WRAP=0.6,
$
ENDSTYLE
END
>

With Regards
Shobia.J

-----------------------------------
WF 7.6.1,WinXP,HTML

I haven't found syntax for specifying ACROSS COMPUTE columns, but with the help of dialog manager you can address the column by its print position.

Run a query against the intermediate HOLD file to get the number of distinct across-field values, and compute the target column's print-order position from that:

  
TABLE FILE CAR
... as above ...
END
-*~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
TABLE FILE THEDATA
BY COUNTRY 
ON TABLE SAVE
END
-RUN
-SET &POS=&LINES+2;
-*~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

TABLE FILE THEDATA
SUM AVE.RETAIL_COST NOPRINT
... as above ...
-*~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
TYPE=DATA,COLUMN=P&POS,
SIZE=8, STYLE=BOLD+ITALIC, 
$
-*~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
ENDSTYLE
END

I don't know how much help this will be, but you can use SEQUENCE to position the AVERAGE column.

Instead of AVE.field NOPRINT and the COMPUTE after the ACROSS, do AVE.field AS 'AVERGAE' and then use SEQUENCE to move the field to after the ACROSS values, as in this example:

TABLE FILE CAR
SUM PCT.RETAIL_COST WITHIN COUNTRY
BY COUNTRY
BY BODYTYPE
ON TABLE HOLD AS THEDATA
END
-RUN
TABLE FILE THEDATA
SUM AVE.RETAIL_COST AS 'AVERAGE'
BY BODYTYPE
SUM RETAIL_COST
BY BODYTYPE
ACROSS COUNTRY

ON TABLE NOTOTAL
-*ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=LANDSCAPE,GRID=OFF,
$
DEFMACRO=RED, MACTYPE=RULE, WHEN=FLG EQ 1,
$
TYPE=REPORT,
BORDER=LIGHT, GRID=ON, FONT='ARIAL', SIZE=8, COLOR='BLACK', BACKCOLOR='NONE',
$
TYPE=TITLE,
STYLE=BOLD, BACKCOLOR='GREY',BORDER=LIGHT,
$
TYPE=HEADING, BORDER=OFF,
$
TYPE=HEADING, LINE=1, SIZE=8, FONT='ARIAL', STYLE=BOLD, WIDTH=4.5,COLOR='WHITE',
$
TYPE=DATA,
BORDER=LIGHT, SIZE=8, JUSTIFY=CENTER, BACKCOLOR=( 'SILVER' 'WHITE' ),
$
TYPE=ACROSSTITLE,
JUSTIFY=CENTER, SIZE=8, BACKCOLOR='SILVER',BORDER=LIGHT,
$
TYPE=ACROSSVALUE,
JUSTIFY=CENTER, SIZE=8, BACKCOLOR='SILVER', STYLE=BOLD, BORDER=LIGHT,
$
TYPE=SUBTOTAL,
SIZE=8, COLOR='BLACK', STYLE=BOLD, BORDER=OFF,JUSTIFY=CENTER,
$
TYPE=REPORT,
WRAP=0.6,
$

TYPE=REPORT, COLUMN=AVE.RETAIL_COST, SEQUENCE=9, $
ENDSTYLE
END
-RUN

There is one problem: On my test version of WF 7.6.5, for some unknown reason, the WF agent crashes when I un-comment "ON TABLE SET HTMLCSS ON".

Francis,

Sequence works and you can put any high number you want, so it is not necessary to calculate the exact position.

  
TABLE FILE CAR
SUM PCT.SALES WITHIN COUNTRY
BY COUNTRY
BY BODYTYPE
ON TABLE HOLD AS H1
END
-RUN
TABLE FILE H1
SUM AVE.SALES AS AVERAGE
BY BODYTYPE
SUM SALES AS ' '
BY BODYTYPE
ACROSS COUNTRY
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
GRID=ON,FONT='ARIAL', SIZE=8, COLOR='BLACK', BACKCOLOR='NONE',
$
TYPE=DATA,
JUSTIFY=CENTER, BACKCOLOR=( 'SILVER' 'WHITE' ),
$
TYPE=TITLE,
JUSTIFY=CENTER, SIZE=8, BACKCOLOR='SILVER', STYLE=BOLD,
$
TYPE=ACROSSTITLE,
JUSTIFY=CENTER, SIZE=8, BACKCOLOR='SILVER',
$
TYPE=ACROSSVALUE,
JUSTIFY=CENTER, SIZE=8, BACKCOLOR='SILVER', STYLE=BOLD,
$
TYPE=REPORT, COLUMN=P2, SEQUENCE=20, $
ENDSTYLE
END

You will notice that I have GRID=ON. When I run with BORDER it crashes the agent. Teething problems of 7.6.7...

quote:

TYPE=REPORT, COLUMN=AVE.RETAIL_COST, SEQUENCE=9

Danny, I knew that I usually use SEQUENCE=99.

As to the agent crash, since it's been happening since at least 7.6.5, teenager 7.6.7 shouldn't be teething any more...

Hi Francis & Danny,

Thanks a ton for this great help...!

But it is creating some other problem in subtotal title and subtotal values.

The subtotal title is coming in one line and subtotal values of across fields are coming one line below the subtotal title.

Please try the below code to see the effect.

-------------------------------------------------------------------------
TABLE FILE CAR
SUM PCT.RETAIL_COST WITHIN COUNTRY
BY COUNTRY
BY CAR
BY BODYTYPE
ON TABLE HOLD AS THEDATA
END
-RUN
TABLE FILE THEDATA
SUM AVE.RETAIL_COST AS 'AVERAGE'
BY CAR
BY BODYTYPE
SUM RETAIL_COST
BY CAR
BY BODYTYPE
ACROSS COUNTRY
ON TABLE NOTOTAL
ON CAR SUBTOTAL
AVE. AS 'Car Average'
-*ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=LANDSCAPE,GRID=ON,
$
DEFMACRO=RED, MACTYPE=RULE, WHEN=FLG EQ 1,
$
TYPE=REPORT,
BORDER=LIGHT, GRID=ON, FONT='ARIAL', SIZE=8, COLOR='BLACK', BACKCOLOR='NONE',
$
TYPE=TITLE,
STYLE=BOLD, BACKCOLOR='GREY',BORDER=LIGHT,
$
TYPE=HEADING, BORDER=OFF,
$
TYPE=HEADING, LINE=1, SIZE=8, FONT='ARIAL', STYLE=BOLD, WIDTH=4.5,COLOR='WHITE',
$
TYPE=DATA,
BORDER=LIGHT, SIZE=8, JUSTIFY=CENTER, BACKCOLOR=( 'SILVER' 'WHITE' ),
$
TYPE=ACROSSTITLE,
JUSTIFY=CENTER, SIZE=8, BACKCOLOR='SILVER',BORDER=LIGHT,
$
TYPE=ACROSSVALUE,
JUSTIFY=CENTER, SIZE=8, BACKCOLOR='SILVER', STYLE=BOLD, BORDER=LIGHT,
$
TYPE=SUBTOTAL,
SIZE=8, COLOR='BLACK', STYLE=BOLD, BORDER=OFF,JUSTIFY=CENTER,
$
TYPE=REPORT,
WRAP=0.6,
$
TYPE=REPORT, COLUMN=AVE.RETAIL_COST, SEQUENCE=9, $
ENDSTYLE
END
-------------------------------------------------------------------------

I tried in both way same is coming.

Thanks,
Ranjan.

quote:

Originally posted by Francis Mariani:

quote:

TYPE=REPORT, COLUMN=AVE.RETAIL_COST, SEQUENCE=9

Danny, I knew that I usually use SEQUENCE=99.

As to the agent crash, since it's been happening since at least 7.6.5, teenager 7.6.7 shouldn't be teething any more...

Unfortunately, that split subtotal problem has been around since the beginning of WebFOCUS. In some cases that can be fixed. Search for "subtotal on two lines" in this forum for some solutions. The suggestions may work, but then cause some other problem.