Focal Point
Headings

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

July 13, 2004, 04:33 PM
Lloyd
Headings
Hey Guys, is there a simple way in WEBFOCUS to format a report such as the follwing:




--WEEKLY--- --MONTHLY-
ACCOUNT TY PL LY TY PL LY
DEPT ST.(ST.LOU) .00 .00 .00 .00 .00 .00
DEPT STORE (FL) .00 .00 .00 .00 .00 .00

This report runs as multi verb request the get the TY, PL and LY as sum based on date selections. But I would like to put the Weekly, monthly title over each set. Acroos doesn't work it puts both titles over the rightmost request.

This message has been edited. Last edited by: <Mabel>,
July 13, 2004, 05:01 PM
<Pietro De Santis>
Lloyd,

Please check the topic, "Heading alignment".

It's not the easiest thing in the world, but there may be hints in the thread.

Pietro.
July 13, 2004, 07:46 PM
<monte2000>
Here is a LINK to that discussion.

Cheers,

Monica

This message has been edited. Last edited by: <Mabel>,
July 13, 2004, 07:47 PM
<monte2000>
Oh and here is another link to a helpful discussion.

This message has been edited. Last edited by: <Mabel>,
July 13, 2004, 09:15 PM
Lloyd
Thanks, Monica and Pietro....

you put me in the right direction and it's working great. This is starting to make sense. Wink ....
July 13, 2004, 09:33 PM
susannah
Lloyd, you might want to make ACROSS work, by defining a variable, to reflect how you group your data.
DEFINE FILE ...
GROUPVAR/A10=IF frequency IS 'W' THEN '....WEEKLY....' ELSE '.....MONTHLY....'
END
then
SUM X Y Z ACROSS HIGHEST GROUPVAR AS ''
primitive, but it'll work.