Focal Point Banner


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.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] HTML ACTIVE REPORT QUESTION

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] HTML ACTIVE REPORT QUESTION
 Login/Join
 
Master
posted
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>,


WebFOCUS 8206.08
Windows, All Outputs
 
Posts: 603 | Registered: June 28, 2013Report This Post
Expert
posted Hide Post
Please post your code so we can see your STYELSHEET, mostly. SQUEEZE OFF, WRAP ###?
 
Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005Report This Post
Master
posted Hide Post
trying something....

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


WebFOCUS 8206.08
Windows, All Outputs
 
Posts: 603 | Registered: June 28, 2013Report This Post
Master
posted Hide Post
FYI..I deleted all the formatting..I then clicked the first column and set DATA = WRAP 4 and the second column DATA= WRAP 8 in the GUI.

It generated this code:
TYPE=REPORT,
COLUMN=N2,
WRAP=8.000000,
$
TYPE=REPORT,
COLUMN=N1,
WRAP=4.000000,

It still Squished everything when run.

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


WebFOCUS 8206.08
Windows, All Outputs
 
Posts: 603 | Registered: June 28, 2013Report This Post
Master
posted Hide Post
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


WebFOCUS 8206.08
Windows, All Outputs
 
Posts: 603 | Registered: June 28, 2013Report This Post
Master
posted Hide Post
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


WebFOCUS 8206.08
Windows, All Outputs
 
Posts: 603 | Registered: June 28, 2013Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] HTML ACTIVE REPORT QUESTION

Copyright © 1996-2020 Information Builders