 |
|||||
|
As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Join the TIBCO Community
Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community. | |||||
Read-Only TopicGo | Search | Notify | Tools |
| [CLOSED] Compound Excel Report | Login/Join |
| Gold member |
Hello Everyone, I had a requirement for a report where the Table headings needs to be vertically aligned. To achieve this, I did a HOLD AS HTMTABLE and then used SET HTMLFORMTYPE=XLS and defined the stylesheet which would align the column vertically. Below is the example using CAR file.
TABLE FILE CAR
SUM COUNTRY
ACROSS MODEL
BY CAR
ON TABLE SET CENT-ZERO ON
ON TABLE SET PAGE-NUM OFF
ON TABLE HOLD AS REP001 FORMAT HTMTABLE
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
TYPE=REPORT, TITLETEXT='Car Example', $
TYPE=ACROSSVALUE,CLASS=rotate,$
ENDSTYLE
END
SET HTMLFORMTYPE=XLS
-RUN
-HTMLFORM BEGIN
<HTML>
<STYLE>
.rotate
{
mso-rotate:90;
vertical-align:bottom;
height:180;
font-size:9px;
font-family:TREBUCHET MS;
font-style:bold;
}
</STYLE>
<BODY>
<TABLE>
<TR>
<TD>!IBI.FIL.REP001;</TD>
</TR>
</BODY>
</TABLE>
</HTML>
Now my problem is, 1. I need to rename the TITLETEXT from WFServlet to Report Name. 2. I need to add another sheet into the Excel output. Does anyone knows how to solve any of the problem? Thanks in Advance!This message has been edited. Last edited by: Kerry, Webfocus 7.7.03 Windows XP Excel, PDF, HTML, APDF, AHTML, Maintain | ||
|
| Expert |
HEre is a technique that will allow a compound excel document, but relies on knowing the class name that WebFOCUS produces. DEFINE FILE CAR
STYLE/A130 = '<STYLE> .xl101{mso-rotate:90;vertical-align:bottom;height:180;font-size:9px;font-family:TREBUCHET MS;font-style:bold;}</STYLE>' ;
END
SET COMPOUND = OPEN
TABLE FILE CAR
HEADING
"<STYLE"
SUM COUNTRY
ACROSS MODEL
BY CAR
ON TABLE SET CENT-ZERO ON
ON TABLE SET PAGE-NUM OFF
ON TABLE PCHOLD AS REP001 FORMAT EXL2K
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
TYPE=REPORT, TITLETEXT='Car Example', $
TYPE=ACROSSVALUE,CLASS=rotate,$
ENDSTYLE
END
SET COMPOUND = CLOSE
TABLE FILE CAR
HEADING
"<STYLE"
SUM COUNTRY
ACROSS BODYTYPE
BY CAR
ON TABLE SET CENT-ZERO ON
ON TABLE SET PAGE-NUM OFF
ON TABLE PCHOLD AS REP001 FORMAT EXL2K
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
TYPE=REPORT, TITLETEXT='Car Example 2', $
TYPE=ACROSSVALUE,CLASS=rotate,$
ENDSTYLE
ENDWaz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Gold member |
Hi Waz, It indeeds solves my above problems. But somehow, when I try to apply the styling for the DATA attribute, it doesnt work. I just applied following and it stopped working. TYPE=DATA,BACKCOLOR=(RGB(255 255 255) RGB(235 235 240)),$ Webfocus 7.7.03 Windows XP Excel, PDF, HTML, APDF, AHTML, Maintain | |||
|
| Expert |
As mentioned abouve, this technique relies on knowing what class names WebFOCUS produces. I you suggest holding/saving the output and opening in a text editor, then check out the class name the data is using. Waz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicCopyright © 1996-2020 Information Builders
| View $GS_USERNAME's Public Profile |
| Add $GS_USERNAME to my Ignore List |
| View Recent Posts by $GS_USERNAME |
| Notify me of New Posts by $GS_USERNAME |