 |
|||||
|
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] HTML Subfoot Formatting | Login/Join |
| Platinum Member |
I have a subfoot row in my EXL2K report that has four cells, each holding a formula, but displaying the result of that formula. I'm trying to align the displayed result of the formula so that it is centered in the cell.
ON TABLE RECAP
FLDA/A200='<tr><td>Section Total:</td>';
FLDB/A250='<td align=center x:num x:fmla=''=IF(SUM(B8:INDIRECT("B" & ROW()-2),)>0,SUM(B8:INDIRECT("B" & ROW()-2),),"")''>0</td><tr>';
ON TABLE SUBFOOT
"<FLDA<FLDB"
I've tried changing the HTML, and using TABFOOTING and SUBFOOT in the stylesheet, but can't sem to find the right combination. Does anyone know how to do this?This message has been edited. Last edited by: Kerry, Production - 7.6.4 Sandbox - 7.6.4 | ||
|
| Virtuoso |
So are you wanting HTML as your topic suggests, or EXL2K as your post suggests? They are not the same thing. HTML is not displayed in the cells of Excel. Also, the individual components of your subfoot line are not placed in their own cell - they are just part of a text line. If you want them in their own columns/cells, they will have to be part of some sort of subtotal (SUBTOTAL,RECOMPUTE,SUMMARIZE,RECAP) Regards, Darin In FOCUS since 1991 WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex WF Client: 77 on Linux w/Tomcat | |||
|
| Platinum Member |
EXL2K output. In order to get the formula into the excel spreadsheet, but have it display as the result of the formula, I have to pass it out as HTML. Production - 7.6.4 Sandbox - 7.6.4 | |||
|
| Expert |
Have you tried TYPE=TABFOOTING, ITEM=1, JUSTIFY=CENTER, $ TYPE=TABFOOTING, ITEM=2, JUSTIFY=CENTER, $ Francis  Give me code, or give me retirement. In FOCUS since 1991 Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server | |||
|
| Platinum Member |
This did not work. I tried TABFOOTING and SUBFOOT. I just spoke with my customer. They are willing to accept the row totals as not centered. Production - 7.6.4 Sandbox - 7.6.4 | |||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only Topic | 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 |