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>
Please check the topic, "Heading alignment".
It's not the easiest thing in the world, but there may be hints in the thread.
MonicaThis message has been edited. Last edited by: <Mabel>,
July 13, 2004, 07:47 PM
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
Thanks, Monica and Pietro....
you put me in the right direction and it's working great. This is starting to make sense. ....
July 13, 2004, 09:33 PM
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.