[SOLVED] I need to Underline records by a GROUP styling in Excel
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 youThis message has been edited. Last edited by: Kerry,
Valeriya
WebFOCUS 764 Servlet - MRE/Dashboard/Self Service/ReportCaster - Windows 2000
April 28, 2010, 05:05 PM
njsden
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, Thanks! I have been trying to find something that would do a sort of separation... NONE!
Valeriya
WebFOCUS 764 Servlet - MRE/Dashboard/Self Service/ReportCaster - Windows 2000
April 28, 2010, 05:14 PM
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").
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.
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!
Valeriya
WebFOCUS 764 Servlet - MRE/Dashboard/Self Service/ReportCaster - Windows 2000
April 28, 2010, 05:24 PM
Prarie
A thought.
ON CATEGORY SUBFOOT
"_________________"
April 28, 2010, 05:29 PM
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).
WebFOCUS 764 Servlet - MRE/Dashboard/Self Service/ReportCaster - Windows 2000
April 28, 2010, 05:49 PM
Dan Satchell
SKIP-LINE will create a blank row in Excel output.
ON GROUP SKIP-LINE
WebFOCUS 7.7.05
April 28, 2010, 05:50 PM
vkrugman
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...
Valeriya
WebFOCUS 764 Servlet - MRE/Dashboard/Self Service/ReportCaster - Windows 2000
April 28, 2010, 05:55 PM
vkrugman
Dan, Yes, thank you
Valeriya
WebFOCUS 764 Servlet - MRE/Dashboard/Self Service/ReportCaster - Windows 2000
April 28, 2010, 06:44 PM
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.
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.