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>,

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.

Here is a LINK to that discussion.

Cheers,

Monica

This message has been edited. Last edited by: <Mabel>,

Oh and here is another link to a helpful discussion.

This message has been edited. Last edited by: <Mabel>,

Thanks, Monica and Pietro....

you put me in the right direction and it's working great. This is starting to make sense. ....

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.