Hi!
I have an output like this:

Group line Case Hours
A 12 56 45
A 34 4 45
---------------------
B 6 5 67
----------------------
C 12 23 22
C 4 4 5

After each Group I need a seperating line

My code:
TABLE FILE FINAL1
HEADING
"Monthly Metrics Cases "
"Run Date: &DATEMtrDYY"
"Period:&LAST_PERIOD, Dates: &START_DT_OF_PERIOD - &LAST_DT_OF_PERIOD"
""
PRINT
PLANT AS 'Branch'
GROUP AS 'Group'
TOTAL_CASE_LINES AS 'Total Case Line'
BY GROUP NOPRINT
WHERE NOT PLANT IN ('B01','B11','B44','B52','B59','B71','B79')
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET STYLE *
UNITS=IN,
LEFTMARGIN=0.1,
RIGHTMARGIN=0.1,
TOPMARGIN=0.1,
BOTTOMMARGIN=0.1,
SQUEEZE=ON,
PAGESIZE=LETTER,
ORIENTATION=LANDSCAPE,$
TYPE=REPORT,FONT=TIMES NEW ROMAN,SIZE=7,GRID=OFF,$
TYPE=DATA,JUSTIFY=CENTER,SIZE=7,$
TYPE=HEADING,FONT=TIMES NEW ROMAN,SIZE=7,COLOR=NAVY,STYLE=BOLD,JUSTIFY = CENTER,$
TYPE=FOOTING,SIZE =7,COLOR =BLACK,JUSTIFY= LEFT,$
ENDSTYLE
END

PLease advise, Thank you

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

Lera, BORDERs in Excel (EXL2K format) are not supported in your version of WebFOCUS. In fact, they were only introduced in WebFOCUS 7.6.9.

I thought the UNDER-LINE option might have been of help but it does not seem to work in Excel. Even producing the report in HTML and "reading" it in Excel using HTMLFORMTYPE=XLS did not seem to work either.

Hopefully someone else can provide a solution or workaround (that does not involve migrating to WF 7.6.9 )

- Neftali.

Neftali, Thanks!
I have been trying to find something that would do a sort of separation... NONE!

quote:

I have been trying to find something that would do a sort of separation

Would an empty line provide enough visual separation in the report? You may use a very light background colour to enhance the effect ... the sample code I provided does just that (except for the "very light colour").

Sorry, I think I accidentally edited my last post with the code I had and replaced it with the last message I sent.

TABLE FILE GGSALES
SUM UNITS DOLLARS
BY CATEGORY BY PRODUCT
HEADING
"Sales Report"
" "
ON CATEGORY SUBFOOT
" "
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET PAGE-NUM OFF
ON TABLE SET STYLE *
TYPE=SUBFOOT, BACKCOLOR='SILVER', $ 
ENDSTYLE
END

I tried to reduce the row height in the SUBFOOT to make it look like a line but I couldn't find how to accomplish that.

quote:

Originally posted by njsden:

quote:

I have been trying to find something that would do a sort of separation

Would an empty line provide enough visual separation in the report? You may use a very light background colour to enhance the effect ... the sample code I provided does just that (except for the "very light colour").

WHERE IS YOUR CODE?
Yes, a lighted colord line would help!

A thought.

ON CATEGORY SUBFOOT
"_________________"  

Valeriya, take a look at Prarie's idea! It might work provided the width of the columns in the report is fixed (see SQUEEZE=OFF and/or WRAP=n style definitions).

TRYING NOW... LET YOU KNOW!
tHANKS

SKIP-LINE will create a blank row in Excel output.

ON GROUP SKIP-LINE

quote:

Originally posted by njsden:
Valeriya, take a look at Prarie's idea! It might work provided the width of the columns in the report is fixed (see SQUEEZE=OFF and/or WRAP=n style definitions).

Your suggestion with an empty line worked well, I'm trying "___________" NOt shure what is SQUEEZE=OFF and/or WRAP are...

Dan,
Yes, thank you

Another option is to use colored bands to differentiate the groups. This may not be a good option if the report is likely to be printed.

TYPE=DATA, BACKCOLOR=(BY=GROUP 'SILVER' 'WHITE'), $

Coloured bands? Wow, that's pretty cool Dan. I did not know about that feature in WebFOCUS.

Thanks!

- Neftali.

Truth be told, I stole the idea from one of Ginny's earlier posts.

It is a cool technique, isn't it. And for those who want to, you can do it in the GUI.

Thank you, Dan. I will try it now.

quote:

Originally posted by Dan Satchell:
Another option is to use colored bands to differentiate the groups. This may not be a good option if the report is likely to be printed.

TYPE=DATA, BACKCOLOR=(BY=GROUP 'SILVER' 'WHITE'), $