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 TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.
From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
Request access to the private WebFOCUS User Group (login required) to network with fellow members.
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.
I just spent 15 miinutes or so browsing thru ACTIVE HTML forum posts. My issue is a simple one and I figure I must be missing a setting or something.
All my columns are squished together as soon as I switch from HTML report to an ACTIVE HTML report. It works fine - all the drop downs are there etc. It looks awefull. I need to spread the columns out a bit. There is plenty of room on screen. I am unsure what to do.
I tried: Min/Max/Trunacte/Wrap/None/Default etc....no matter what...it scrunches everything together....This message has been edited. Last edited by: <Kathryn Henning>,
I am on to something..perhaps someone can explain. When I deleted:
ON TABLE SET STYLE * INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/endeflt.sty,
then re-opened the GUI, I noticed I could now choose Column and Title Data and was able to set Column1 = Wrap 4 and column 2 = Wrap 10...suddenly it worked!
Where did that INCLUDE for the style come from...I think that is what is causing the problem?
ON TABLE SET STYLE * $ TYPE=REPORT, COLUMN=N2, WRAP=10.000000, $ TYPE=REPORT, COLUMN=N1, WRAP=4.000000, $ ENDSTYLE
I rebuilt my report. It looks better but I think I reach a page width threshold. It looks good in preview but when I run the report it looks like some things that I have set wider get squished. Is their a WIDTH setting?
Also..the WRAP never wraps...data is merely truncates.
New code: TABLE FILE PB_TRANSACTION_CHARGES_TBL SUM PB_TRANSACTION_CHARGES_TBL.PB_TRANSACTION_CHARGES_TBL.PROCEDURE_QUANTITY/P22C AS 'Units' PB_TRANSACTION_CHARGES_TBL.PB_TRANSACTION_CHARGES_TBL.RVU_WORK/P22C AS 'wRVUs' BY PB_TRANSACTION_CHARGES_TBL.PB_TRANSACTION_CHARGES_TBL.DOS AS 'Service,Date' BY LOWEST PB_TRANSACTION_CHARGES_TBL.PB_TRANSACTION_CHARGES_TBL.POSTDT AS 'Post,Date' BY J0.BILL_AREA_TBL.BILL_AREA_NUM AS 'Bill,Area' BY LOWEST PB_TRANSACTION_CHARGES_TBL.PB_TRANSACTION_CHARGES_TBL.PATIENT_NAME AS 'Patient' BY LOWEST J1.CPT_CODE_TBL.CPT_CODE AS 'Cpt' BY LOWEST J1.CPT_CODE_TBL.CPT_NAME AS 'Cpt Name' BY LOWEST PB_TRANSACTION_CHARGES_TBL.PB_TRANSACTION_CHARGES_TBL.FIRST_MODIFIER_ID AS 'M1' BY LOWEST PB_TRANSACTION_CHARGES_TBL.PB_TRANSACTION_CHARGES_TBL.SECOND_MODIFIER_ID AS 'M2' BY LOWEST PB_TRANSACTION_CHARGES_TBL.PB_TRANSACTION_CHARGES_TBL.THIRD_MODIFIER_ID AS 'M3' WHERE ( J2.PROVIDER_TBL.PROVIDER_NAME CONTAINS 'KNOUSE' ) AND ( J3.TBLMSTR_CALENDARPERIODEPIC.ROLLINGMONTHS GE -6 ) AND ( J3.TBLMSTR_CALENDARPERIODEPIC.ROLLINGMONTHS LT 0 ); ON TABLE SET PAGE-NUM NOLEAD ON TABLE SET BYDISPLAY ON ON TABLE NOTOTAL ON TABLE PCHOLD FORMAT AHTML ON TABLE SET HTMLCSS ON ON TABLE SET STYLE * $ TYPE=DATA, COLUMN=N7, FONT='ARIAL', COLOR='BLACK', BACKCOLOR='WHITE', $ TYPE=DATA, COLUMN=N8, FONT='ARIAL', COLOR='BLACK', BACKCOLOR='WHITE', $ TYPE=DATA, COLUMN=N9, FONT='ARIAL', COLOR='BLACK', BACKCOLOR='WHITE', $ TYPE=DATA, COLUMN=N5, FONT='ARIAL', COLOR='BLACK', BACKCOLOR='WHITE', $ TYPE=DATA, COLUMN=N6, FONT='ARIAL', COLOR='BLACK', BACKCOLOR='WHITE', $ TYPE=DATA, COLUMN=N4, FONT='ARIAL', $ TYPE=DATA, COLUMN=N3, FONT='ARIAL', $ TYPE=DATA, COLUMN=N1, FONT='ARIAL', COLOR='BLACK', BACKCOLOR='WHITE', $ TYPE=DATA, COLUMN=N2, FONT='ARIAL', $ TYPE=DATA, COLUMN=N10, FONT='ARIAL', $ TYPE=DATA, COLUMN=N11, FONT='ARIAL', $ TYPE=TITLE, COLUMN=N7, FONT='ARIAL', COLOR='WHITE', BACKCOLOR='NAVY', $ TYPE=TITLE, COLUMN=N8, FONT='ARIAL', COLOR='WHITE', BACKCOLOR='NAVY', $ TYPE=TITLE, COLUMN=N9, FONT='ARIAL', COLOR='WHITE', BACKCOLOR='NAVY', $ TYPE=TITLE, COLUMN=N5, FONT='ARIAL', COLOR='WHITE', BACKCOLOR='NAVY', $ TYPE=TITLE, COLUMN=N6, FONT='ARIAL', COLOR='WHITE', BACKCOLOR='NAVY', $ TYPE=TITLE, COLUMN=N4, FONT='ARIAL', COLOR='WHITE', BACKCOLOR='NAVY', $ TYPE=TITLE, COLUMN=N3, FONT='ARIAL', COLOR='WHITE', BACKCOLOR='NAVY', $ TYPE=TITLE, COLUMN=N1, FONT='ARIAL', COLOR='WHITE', BACKCOLOR='NAVY', $ TYPE=TITLE, COLUMN=N2, FONT='ARIAL', COLOR='WHITE', BACKCOLOR='NAVY', $ TYPE=TITLE, COLUMN=N10, FONT='ARIAL', COLOR='WHITE', BACKCOLOR='NAVY', $ TYPE=TITLE, COLUMN=N11, FONT='ARIAL', COLOR='WHITE', BACKCOLOR='NAVY', $ TYPE=REPORT, COLUMN=N7, WRAP=1.000000, $ TYPE=REPORT, COLUMN=N8, WRAP=1.000000, $ TYPE=REPORT, COLUMN=N9, WRAP=1.000000, $ TYPE=REPORT, COLUMN=N5, WRAP=1.000000, $ TYPE=REPORT, COLUMN=N6, WRAP=1.000000, $ TYPE=REPORT, COLUMN=N4, WRAP=4.000000, $ TYPE=REPORT, COLUMN=N1, WRAP=2.000000, $ TYPE=REPORT, COLUMN=N2, WRAP=2.000000, $ TYPE=REPORT, COLUMN=N10, WRAP=1.000000, $ TYPE=REPORT, COLUMN=N11, WRAP=1.000000, $ ENDSTYLE END