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] Spacing Over an ACROSS and a COMPUTE

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] Spacing Over an ACROSS and a COMPUTE
 Login/Join
 
Platinum Member
posted
I am trying to space over an ACROSS field and a Compute column where I am generating a checkmark for an HTML report. I am trying to use SET STYLEMODE FIXED with positioning with the IN command and not having success. I am also trying to play around with the width of the columns as well. Does anyone have any suggestions?

This message has been edited. Last edited by: FP Mod Chuck,


WebFOCUS 8.2.06
SQL Server
HTML, PDF, Excel, etc
 
Posts: 168 | Registered: August 22, 2019Report This Post
Virtuoso
posted Hide Post
As usual, to make your request clear to understand and to avoid giving you answers that do not answers what you are looking for, please give us a SAMPLE of the result - "draw" it at worst using the code tag as per below.

-* I need something such as this
TABLE FILE abc
SUM sum
BY row
ACROSS across
END

-* That will create something such as this but with an increase space (blank row) between row and across
    across across

row    sum    sum
row

I may be the only one, but once again it's not clear what your need is.
What do you mean by : "to space over an ACROSS and Compute column" ?

You are requesting space "over" (?) an ACROSS field (which is a of "BY" field that creates a column instead of a row) and a COMPUTE (which is "most of the time") used as a PRINT/SUM field

The more detailed you'll be, the more precise, accurate and faster is going to be our answer.

Thanks


WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
 
Posts: 2409 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Report This Post
Platinum Member
posted Hide Post
MartinY - Thanks for your reply. Here is the main part of my actual code below. Also, here is the representation of the output below. I need to space over the CLDR_DT date across field and the CHK Compute field which is generating a check mark based on the condition. It seems to me that it is difficult to play with the spacing of a field that is generated by this type of function.

The code below creates something like this for the most part:

CLDR_DT CLDR_DT CLDR_DT
VBR_PRCG_SCHD_NM CHK CHK CHK

I need to space over the CLDR_DT field and the checkmark field (CHK). Let me know if I can clarify anything else.


  
DEFINE FILE PMR_PROV_VAL_BASE_CLUSTER
CLDR_DT/MDYY = DATECVT(ICURD_CLDR, 'I8YYMD', 'MDYY');
CHK/A10 = IF (VBR_PRCG_SCHD_NM EQ 'Select Provider Plus 5%' OR 'Select Provider Plus 10%' OR 'Select Provider Plus 15%' OR 'Select Provider Plus 20%' OR 'Select Provider Plus 25%' OR 'Select Provider Plus 30%') THEN '&|#x2714' ELSE '';
END


TABLE FILE PMR_PROV_VAL_BASE_CLUSTER
SUM COMPUTE CHK/A10 = IF (VBR_PRCG_SCHD_NM EQ 'Select Provider Plus 5%' OR 'Select Provider Plus 10%' OR 'Select Provider Plus 15%' OR 'Select Provider Plus 20%' OR 'Select Provider Plus 25%' OR 'Select Provider Plus 30%') THEN '&|#x2714' ELSE '';
-*ACROSS ICURD_CLDR AS ''
ACROSS CLDR_DT AS ''
BY VBR_PRCG_SCHD_NM AS ''
WHERE VBR_PRCG_PCT_VAL NE 0;
WHERE SPEC_CD EQ 'AC' OR 'PD' OR 'OB';
WHERE PRIM_LCTN_SW EQ 'Y'
WHERE VBR_PRCG_SCHD_NM NE MISSING;
WHERE ICURD_CLDR NE MISSING;
WHERE PMR_PROV_VAL_BASE_CLUSTER.PROV_DMN.PROV_NPI EQ &NPI;
-*WHERE RECORDLIMIT EQ 10000;
-*-INCLUDE /WFC/Repository/PMR/common/fex/PMR_com_filter_include.fex
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET PAGE-NUM NOPAGE
ON TABLE SET AUTOFIT ON
ON TABLE SET TITLELINE ON
-*ON TABLE SET SPACES 1
-*ON TABLE SET STYLEMODE FIXED
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *


WebFOCUS 8.2.06
SQL Server
HTML, PDF, Excel, etc
 
Posts: 168 | Registered: August 22, 2019Report This Post
Platinum Member
posted Hide Post
I noticed when I posted the last post I lost the spacing in the representation of the output. There is probably something to embed spacing in the post. Anyway, each CLDR_DT is actually suppose to be over each CHK.


WebFOCUS 8.2.06
SQL Server
HTML, PDF, Excel, etc
 
Posts: 168 | Registered: August 22, 2019Report This Post
Virtuoso
posted Hide Post
quote:
I noticed when I posted the last post I lost the spacing in the representation of the output.

Put your sample output in code tag same as when you post sample code

Still not sure to understand. Below code have Countries aligned with CHK...
TABLE FILE CAR
SUM COMPUTE CHK/A10 = IF SEATS GT 2 THEN '&|#x2714' ELSE ''; AS ''
BY CAR AS ''
ACROSS COUNTRY AS ''
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET PAGE-NUM NOPAGE
ON TABLE SET AUTOFIT ON
ON TABLE SET TITLELINE ON
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
END


WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
 
Posts: 2409 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Report This Post
Platinum Member
posted Hide Post
 
                  CLDR_DT  CLDR_DT  CLDR_DTVBR 
VBR_PRCG_SCHD_NM  CHK      CHK      CHK

 


Thanks...put the output above in the code tags. I am filtering my output where it will on have one row. My Dates are aligned with CHK also. I would like to space both of them over a bit.

In your CAR example, it would be similar to spacing over Countries and CHK a bit ...even though you have multiple records generating.


WebFOCUS 8.2.06
SQL Server
HTML, PDF, Excel, etc
 
Posts: 168 | Registered: August 22, 2019Report This Post
Virtuoso
posted Hide Post
A simple method could be to create a dummy column such as below

TABLE FILE CAR
SUM COMPUTE CHK/A10 = IF SEATS GT 2 THEN '&|#x2714' ELSE ''; AS ''
    COMPUTE DUMMY/A1 = ''; AS ''
BY CAR AS ''
ACROSS COUNTRY AS ''
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET PAGE-NUM NOPAGE
ON TABLE SET AUTOFIT ON
ON TABLE SET TITLELINE ON
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
END


WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
 
Posts: 2409 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Report This Post
Platinum Member
posted Hide Post
The dummy column would allow me to move over those two?


WebFOCUS 8.2.06
SQL Server
HTML, PDF, Excel, etc
 
Posts: 168 | Registered: August 22, 2019Report This Post
Master
posted Hide Post

Expanding on MartinY's suggestion, there are a number of different check mark character codes that you could use: https://www.amp-what.com/unicode/search/check. You just need to make sure that you escape the & symbol with a pipe character when using these in IBI code, like MartinY did.

The table below shows the normal HTML codes that will produce the corresponding check marks:

HTML Entity Decimal Hexadecimal
✓
✓
✓ ✓
✔ ✔
🗸 🗸 🗸
🗹 🗹 🗹
✔️ ✔️ ✔️
✅ ✅
☑️ ☑️ ☑&#xfe0f

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


Hallway

 
Prod: 8202M1
Test: 8202M4
Repository:
 
OS:
 
Outputs:
 
 
 
 
 
Posts: 608 | Location: Salt Lake City, UT, USA | Registered: November 18, 2015Report This Post
Platinum Member
posted Hide Post
I need to space over the checkmark and across field above it. Does the dummy field allow me to do that?


WebFOCUS 8.2.06
SQL Server
HTML, PDF, Excel, etc
 
Posts: 168 | Registered: August 22, 2019Report This Post
Master
posted Hide Post
Well, that is the weirdest IBI quirk I have seen (okay maybe not weirdest).

By putting in a border color on the report in the styles, the rest of the justification works. Take out the border color and the justification breaks.
 
DEFINE FILE car
CHK/A150V=IF SEATS GT 2 THEN '&|#x2714;&|#xfe0f;' ELSE '';
END

TABLE FILE car
SUM CHK AS ''
BY CAR
ACROSS COUNTRY AS ''
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET PAGE-NUM NOPAGE
ON TABLE SET AUTOFIT ON
ON TABLE SET TITLELINE ON
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
TYPE=REPORT, BORDER-COLOR=RGB(#ffffff), $
TYPE=TITLE, ACROSSCOLUMN=N1, JUSTIFY=CENTER, STYLE=NORMAL, $
TYPE=DATA, ACROSSCOLUMN=N1, JUSTIFY=CENTER, $
TYPE=ACROSSTITLE, ACROSS=N1, JUSTIFY=CENTER, STYLE=NORMAL, $
TYPE=ACROSSVALUE, ACROSS=N1, JUSTIFY=CENTER, $
ENDSTYLE
END
-RUN
 


Hallway

 
Prod: 8202M1
Test: 8202M4
Repository:
 
OS:
 
Outputs:
 
 
 
 
 
Posts: 608 | Location: Salt Lake City, UT, USA | Registered: November 18, 2015Report This Post
Platinum Member
posted Hide Post
Is the #xfe0f generating spaces after the checkmark? This is not working for my code. Is it spacing over the Country and CHK? It's hard to tell. That's what I need to do.


WebFOCUS 8.2.06
SQL Server
HTML, PDF, Excel, etc
 
Posts: 168 | Registered: August 22, 2019Report This Post
Master
posted Hide Post
quote:
Originally posted by AMC2:
Is the #xfe0f generating spaces after the checkmark? This is not working for my code. Is it spacing over the Country and CHK? It's hard to tell. That's what I need to do.


No. &|#x2714;&|#xfe0f is the check mark.

Really we are just guessing what it is that you need. Could you be more specific as to what you are needing?

Are you saying that you want actual space characters before the check mark within the same table cell as the check mark? If so, why?

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


Hallway

 
Prod: 8202M1
Test: 8202M4
Repository:
 
OS:
 
Outputs:
 
 
 
 
 
Posts: 608 | Location: Salt Lake City, UT, USA | Registered: November 18, 2015Report This Post
Platinum Member
posted Hide Post
I just want to move over the checkmark and the Date in my case. In your CAR example it would be the checkmark and the Country. My report is the first report in a compound HTML report. I would like to move over those two fields to line it up with the fields in the 2nd report. Let me know if you need me to clarify anymore.


WebFOCUS 8.2.06
SQL Server
HTML, PDF, Excel, etc
 
Posts: 168 | Registered: August 22, 2019Report This Post
Master
posted Hide Post

Without knowing the layout of the other report and where the columns are, it makes it impossible to align.

This sample code here shows that the check mark is in the middle of each column:

    DEFINE FILE car
    CHK/A150V=IF SEATS GT 2 THEN '&|#x2714;&|#xfe0f;' ELSE '';
    END
    
    TABLE FILE car
    SUM CHK AS ''
    BY CAR
    ACROSS COUNTRY AS ''
    ON TABLE PCHOLD FORMAT HTML
    ON TABLE SET PAGE-NUM NOPAGE
    ON TABLE SET AUTOFIT ON
    ON TABLE SET TITLELINE ON
    ON TABLE SET HTMLCSS ON
    ON TABLE SET STYLE *
    TYPE=TITLE, ACROSSCOLUMN=N1, JUSTIFY=CENTER, STYLE=NORMAL, $
    TYPE=DATA, ACROSSCOLUMN=N1, JUSTIFY=CENTER, $
    TYPE=ACROSSTITLE, ACROSS=N1, JUSTIFY=CENTER, STYLE=NORMAL, $
    TYPE=ACROSSVALUE, ACROSS=N1, JUSTIFY=CENTER, $
    TYPE=REPORT,      
        BORDER-TOP=LIGHT,
        BORDER-TOP-STYLE=SOLID,
        BORDER-TOP-COLOR='GREY',
        BORDER-RIGHT=LIGHT,
        BORDER-RIGHT-STYLE=SOLID,
        BORDER-RIGHT-COLOR='GREY', 
        BORDER-BOTTOM=LIGHT,
        BORDER-BOTTOM-STYLE=SOLID,
        BORDER-BOTTOM-COLOR='GREY',
        BORDER-LEFT=LIGHT,
        BORDER-LEFT-STYLE=SOLID,
        BORDER-LEFT-COLOR='GREY',
    $
    ENDSTYLE
    END
    -RUN

It returns a table like this

ENGLAND FRANCE ITALY JAPAN W GERMANY
CAR
ALFA ROMEO . .   . .
AUDI . . . . ✔️
BMW . . . . ✔️
DATSUN . . . ✔️ .
JAGUAR ✔️ . . . .
JENSEN ✔️ . . . .
MASERATI . .   . .
PEUGEOT . ✔️ . . .
TOYOTA . . . ✔️ .
TRIUMPH   . . . .
           


Hallway

 
Prod: 8202M1
Test: 8202M4
Repository:
 
OS:
 
Outputs:
 
 
 
 
 
Posts: 608 | Location: Salt Lake City, UT, USA | Registered: November 18, 2015Report This Post
Platinum Member
posted Hide Post
Ok, so just how would you move over to the right a few spaces your Country across field and the checkmark here respectively?


WebFOCUS 8.2.06
SQL Server
HTML, PDF, Excel, etc
 
Posts: 168 | Registered: August 22, 2019Report This Post
Platinum Member
posted Hide Post
Also, here is the main code below for the whole compound report. I am trying to move over the Date and checkmark fields to try to align them with the columns of the 2nd report.


  
DEFAULTH &NPI = _FOC_NULL;
-IF &NPI NE _FOC_NULL THEN GOTO CONTINUE;
-INCLUDE IBFS:/WFC/Repository/PMR/common/fex/PMR_com_npi_inc.fex
-CONTINUE
-***************************************************

-*-GOTO 2ND_RPT

-*TABLE FILE PMR_PROV_VAL_BASE_CLUSTER
-*PRINT PROV_NPI
-*	  VBR_PRCG_SCHD_NM
-*	  COMPUTE CHK/A10 = IF (VBR_PRCG_SCHD_NM EQ 'Select Provider Plus 5%' OR 'Select Provider Plus 10%' OR 'Select Provider Plus 15%' OR 'Select Provider Plus 20%' OR 'Select Provider Plus 25%' OR 'Select Provider Plus 30%') THEN '&|#x2714' ELSE '';
-*BY PMR_PROV_VAL_BASE_CLUSTER.PROV_DMN.LAST_NM
-*BY PMR_PROV_VAL_BASE_CLUSTER.PROV_DMN.FST_NM
-*BY ICURD_CLDR
-*WHERE VBR_PRCG_PCT_VAL NE 0;
-*WHERE SPEC_CD EQ 'AC' OR 'PD' OR 'OB';
-*WHERE PRIM_LCTN_SW EQ 'Y';
-*-*WHERE PROV_NPI EQ 1649227471;
-*WHERE PMR_PROV_VAL_BASE_CLUSTER.PROV_DMN.PROV_NPI EQ &NPI;
-*-*ON TABLE HOLD AS HOLD1
-*END
-*-RUN
-*-EXIT

-*******1st Report
SET ASNAMES = ON;
SET COMPOUND = OPEN NOBREAK;
SET ACROSSPRT = COMPRESS;

DEFINE FILE PMR_PROV_VAL_BASE_CLUSTER
CLDR_DT/MDYY = DATECVT(ICURD_CLDR, 'I8YYMD', 'MDYY');
CHK/A10 = IF (VBR_PRCG_SCHD_NM EQ 'Select Provider Plus 5%' OR 'Select Provider Plus 10%' OR 'Select Provider Plus 15%' OR 'Select Provider Plus 20%' OR 'Select Provider Plus 25%' OR 'Select Provider Plus 30%') THEN '&|#x2714' ELSE '';
END


TABLE FILE PMR_PROV_VAL_BASE_CLUSTER
SUM COMPUTE CHK/A10 = IF (VBR_PRCG_SCHD_NM EQ 'Select Provider Plus 5%' OR 'Select Provider Plus 10%' OR 'Select Provider Plus 15%' OR 'Select Provider Plus 20%' OR 'Select Provider Plus 25%' OR 'Select Provider Plus 30%') THEN '&|#x2714;&|#xfe0f;' ELSE '';
-*ACROSS ICURD_CLDR AS ''
ACROSS CLDR_DT AS ''
BY VBR_PRCG_SCHD_NM AS ''
WHERE VBR_PRCG_PCT_VAL NE 0;
WHERE SPEC_CD EQ 'AC' OR 'PD' OR 'OB';
WHERE PRIM_LCTN_SW EQ 'Y'
WHERE VBR_PRCG_SCHD_NM NE MISSING;
WHERE ICURD_CLDR NE MISSING;
WHERE PMR_PROV_VAL_BASE_CLUSTER.PROV_DMN.PROV_NPI EQ &NPI;
-*WHERE RECORDLIMIT EQ 10000;
-*-INCLUDE /WFC/Repository/PMR/common/fex/PMR_com_filter_include.fex
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET PAGE-NUM NOPAGE
ON TABLE SET AUTOFIT ON
ON TABLE SET TITLELINE ON
-*ON TABLE SET SPACES 1
-*ON TABLE SET STYLEMODE FIXED
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
TYPE=REPORT,
	CSSURL=IBFS:/WFC/Repository/PMR/common/css/PMR_com_css_main_css.css,
$
TYPE=REPORT,
	 GRID=OFF ,
     FONT='OpenSans',
     SIZE=11,
	 STYLE=NORMAL,
	 SQUEEZE=ON,
	 JUSTIFY=CENTER,
$

TYPE=ACROSSVALUE, STYLE=BOLD, WRAP=ON, $

TYPE=REPORT, ACROSSCOLUMN=CLDR_DT, SQUEEZE=4.0, WIDTH=0.1, $

-*TYPE=DATA, COLUMN=N4, COLOR=RED, STYLE=BOLD, $

ENDSTYLE
END
-RUN


-2ND_RPT

-*******2nd Report
SET ACROSSLINE = OFF
SET ACROSSTITLE = SIDE

DEFINE FILE PMR_PROV_VAL_BASE_CLUSTER
PRCG_SCHD/A5 = IF VBR_PRCG_SCHD_NM EQ 'Select Provider Plus 5%'  THEN '5%'  ELSE
               IF VBR_PRCG_SCHD_NM EQ 'Select Provider Plus 10%' THEN '10%' ELSE
			   IF VBR_PRCG_SCHD_NM EQ 'Select Provider Plus 15%' THEN '15%' ELSE
			   IF VBR_PRCG_SCHD_NM EQ 'Select Provider Plus 20%' THEN '20%' ELSE
			   IF VBR_PRCG_SCHD_NM EQ 'Select Provider Plus 25%' THEN '25%' ELSE
			   IF VBR_PRCG_SCHD_NM EQ 'Select Provider Plus 30%' THEN '30%' ELSE '';

CLDR_DT/MDYY = DATECVT(ICURD_CLDR, 'I8YYMD', 'MDYY');
END

TABLE FILE PMR_PROV_VAL_BASE_CLUSTER
SUM VBR_GAIN_AMT/D12!d   AS 'Estimated' OVER
    VBR_PD_ELG_AMT/D12!d AS 'Potential' OVER
	COMPUTE MISOPP/D12!d = VBR_PD_ELG_AMT - VBR_GAIN_AMT; AS 'Missed Opportunity'
-*ACROSS ICURD_CLDR AS ''
ACROSS CLDR_DT AS '' NOPRINT
ACROSS PRCG_SCHD AS ''
WHERE VBR_PRCG_PCT_VAL NE 0;
WHERE SPEC_CD EQ 'AC' OR 'PD' OR 'OB';
WHERE PRIM_LCTN_SW EQ 'Y'
WHERE VBR_PRCG_SCHD_NM NE MISSING;
WHERE ICURD_CLDR NE MISSING;
WHERE PMR_PROV_VAL_BASE_CLUSTER.PROV_DMN.PROV_NPI EQ &NPI;
-*WHERE RECORDLIMIT EQ 10000;
-*-INCLUDE /WFC/Repository/PMR/common/fex/PMR_com_filter_include.fex
ON TABLE PCHOLD FORMAT HTML CLOSE
ON TABLE SET PAGE-NUM NOPAGE
ON TABLE SET AUTOFIT ON
ON TABLE SET TITLELINE ON
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
TYPE=REPORT,
	CSSURL=IBFS:/WFC/Repository/PMR/common/css/PMR_com_css_main_css.css,
$

TYPE=REPORT,
	 GRID=OFF ,
     FONT='OpenSans',
     SIZE=11,
	 STYLE=NORMAL,
	 SQUEEZE=ON,
	 JUSTIFY=CENTER,
$


TYPE=ACROSSVALUE, STYLE=BOLD, WRAP=ON, $

TYPE=REPORT, ACROSSCOLUMN=PRCG_SCHD, SQUEEZE=2, WIDTH=3.0, $

-* style Potential using bottom border
TYPE=DATA, COLUMN=VBR_PD_ELG_AMT, BORDER-BOTTOM=LIGHT, $
TYPE=DATA, ACROSSCOLUMN=VBR_PD_ELG_AMT, BORDER-BOTTOM=LIGHT, $
TYPE=TITLE, COLUMN=VBR_PD_ELG_AMT, BORDER-BOTTOM=LIGHT, $

-* style Estimated using top border
TYPE=DATA, COLUMN=VBR_GAIN_AMT, BORDER-TOP=LIGHT, $
TYPE=DATA, ACROSSCOLUMN=VBR_GAIN_AMT, BORDER-TOP=LIGHT, $
TYPE=TITLE, COLUMN=VBR_GAIN_AMT, BORDER-TOP=LIGHT, $


WebFOCUS 8.2.06
SQL Server
HTML, PDF, Excel, etc
 
Posts: 168 | Registered: August 22, 2019Report This Post
Master
posted Hide Post
Thanks for posting the code. I can't run it on my end though. I would just surround the fields with a span and apply padding-left in the style attribute
  
DEFINE FILE car
    CHK/A150V=IF SEATS GT 2 THEN '<span style="padding-left:40px;">&|check;</span>' ELSE '';
    CNTRY/A50V = '<span style="padding-left:40px;">'|| COUNTRY || '</span>';
END

TABLE FILE car
SUM CHK AS ''
BY CAR
ACROSS CNTRY AS ''
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET NODATA ''
ON TABLE SET PAGE-NUM NOPAGE
ON TABLE SET AUTOFIT ON
ON TABLE SET TITLELINE ON
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
TYPE=REPORT,      
    BORDER-TOP=LIGHT,
    BORDER-TOP-STYLE=SOLID,
    BORDER-TOP-COLOR='GREY',
    BORDER-RIGHT=LIGHT,
    BORDER-RIGHT-STYLE=SOLID,
    BORDER-RIGHT-COLOR='GREY', 
    BORDER-BOTTOM=LIGHT,
    BORDER-BOTTOM-STYLE=SOLID,
    BORDER-BOTTOM-COLOR='GREY',
    BORDER-LEFT=LIGHT,
    BORDER-LEFT-STYLE=SOLID,
    BORDER-LEFT-COLOR='GREY',
$
ENDSTYLE
END
-RUN



Hallway

 
Prod: 8202M1
Test: 8202M4
Repository:
 
OS:
 
Outputs:
 
 
 
 
 
Posts: 608 | Location: Salt Lake City, UT, USA | Registered: November 18, 2015Report This Post
Platinum Member
posted Hide Post
Ok, I'm not getting that to work. Here's the code with your last example with the span:

 
DEFINE FILE PMR_PROV_VAL_BASE_CLUSTER
CLDR_DT/MDYY = DATECVT(ICURD_CLDR, 'I8YYMD', 'MDYY');
CLDR_DT2/A20V = '<span style="padding-left:40px;">'|| CLDR_DT2 || '</span>';
CHK/A10 = IF (VBR_PRCG_SCHD_NM EQ 'Select Provider Plus 5%' OR 'Select Provider Plus 10%' OR 'Select Provider Plus 15%' OR 'Select Provider Plus 20%' OR 'Select Provider Plus 25%' OR 'Select Provider Plus 30%') THEN '&|#x2714;' ELSE '';
END


TABLE FILE PMR_PROV_VAL_BASE_CLUSTER
SUM COMPUTE CHK/A10 = IF (VBR_PRCG_SCHD_NM EQ 'Select Provider Plus 5%' OR 'Select Provider Plus 10%' OR 'Select Provider Plus 15%' OR 'Select Provider Plus 20%' OR 'Select Provider Plus 25%' OR 'Select Provider Plus 30%') THEN '<span style="padding-left:40px;">&|#x2714 </span>' ELSE '';
-*ACROSS ICURD_CLDR AS ''
ACROSS CLDR_DT2 AS ''
BY VBR_PRCG_SCHD_NM AS ''
WHERE VBR_PRCG_PCT_VAL NE 0;
WHERE SPEC_CD EQ 'AC' OR 'PD' OR 'OB';
WHERE PRIM_LCTN_SW EQ 'Y'
WHERE VBR_PRCG_SCHD_NM NE MISSING;
WHERE ICURD_CLDR NE MISSING;
WHERE PMR_PROV_VAL_BASE_CLUSTER.PROV_DMN.PROV_NPI EQ &NPI;
-*WHERE RECORDLIMIT EQ 10000;
-*-INCLUDE /WFC/Repository/PMR/common/fex/PMR_com_filter_include.fex
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET PAGE-NUM NOPAGE
ON TABLE SET AUTOFIT ON
ON TABLE SET TITLELINE ON
-*ON TABLE SET SPACES 1
-*ON TABLE SET STYLEMODE FIXED
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
 


WebFOCUS 8.2.06
SQL Server
HTML, PDF, Excel, etc
 
Posts: 168 | Registered: August 22, 2019Report This Post
Master
posted Hide Post
quote:
CSSURL=IBFS:/WFC/Repository/PMR/common/css/PMR_com_css_main_css.css


You are going to have to inspect the HTML page in the browser dev tools and see what is overriding the style setting in the span then. I suspect that the css file listed above might be overriding it.

Without knowing all of the styling details and not having any data to test against, I can't help you any further.

If you could replicate the report using master files from ibisamp that I could run on my end, I would be able to dig in further.


Hallway

 
Prod: 8202M1
Test: 8202M4
Repository:
 
OS:
 
Outputs:
 
 
 
 
 
Posts: 608 | Location: Salt Lake City, UT, USA | Registered: November 18, 2015Report This Post
Platinum Member
posted Hide Post
Hallway - Thanks for the info with the SPAN. However, I was able to apply a WIDTH on the Date and Checkmark fields in the styling with the following below to space over those two lines to be aligned with the other columns in 2nd report. It was too difficult to get the SPAN to work for my code.

TYPE=DATA, ACROSSCOLUMN=CLDR_DT, WIDTH=0.1, $
TYPE=DATA, ACROSSCOLUMN=CHK, WIDTH=0.1, $

However, oddly enough, it put a top border line above the Date field for some odd reason. Any ideas on that?


WebFOCUS 8.2.06
SQL Server
HTML, PDF, Excel, etc
 
Posts: 168 | Registered: August 22, 2019Report This Post
Master
posted Hide Post
Not without seeing all of the different styles being applied and how the page was rendered in the browser. If using Chrome or FireFox, right click on the the line and select inspect. Then find the element that is creating the line. Probably a border on a table cell. Then look at the css in the dev tools to see what is causing that line to be drawn. CSS stands for Cascading Style Sheet. This means that multiple styles can be applied to the same element, but usually the one lowest on the 'Cascade' wins. So you need to look at the dev tools in the browser and see which styles were applied and which ones were overridden.

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


Hallway

 
Prod: 8202M1
Test: 8202M4
Repository:
 
OS:
 
Outputs:
 
 
 
 
 
Posts: 608 | Location: Salt Lake City, UT, USA | Registered: November 18, 2015Report This Post
Platinum Member
posted Hide Post
It kind of resolved itself. I was playing around with the WIDTH sizing, and all of a sudden, the top border line above the Date line is not generating any longer from my recollection of what I've done. I am working on few different things at the same time, but this is what I recollect.

Thanks Hallway and the rest of you for your responses on this issue.


WebFOCUS 8.2.06
SQL Server
HTML, PDF, Excel, etc
 
Posts: 168 | Registered: August 22, 2019Report This Post
Platinum Member
posted Hide Post
I actually overlooked what I did here....had multiples things going. This is what actually resolved removing the border line above the date field here:

TYPE=REPORT, ACROSSCOLUMN=CLDR_DT, WIDTH=0.1, $
TYPE=REPORT, ACROSSCOLUMN=CHK, WIDTH=0.1, $

Putting this styling at the report level as opposed to at the data level is what strangely removed it. I had it at the data level initially.

I integrated this report onto a portal page. Another issue I am having is that when the report runs individually, like in App Studio, the checkmark generates as being green in color, but when it run on the portal, it generates as a black checkmark. Green is the color I need it stay when it generates on the portal.

Anyone has any ideas as to why or any suggestions?


WebFOCUS 8.2.06
SQL Server
HTML, PDF, Excel, etc
 
Posts: 168 | Registered: August 22, 2019Report This Post
Expert
posted Hide Post
In the documents, you'll see that WIDTH is only supported at TYPE=REPORT levels.

T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
 
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004Report This Post
Platinum Member
posted Hide Post
Ah....thanks Tony!


WebFOCUS 8.2.06
SQL Server
HTML, PDF, Excel, etc
 
Posts: 168 | Registered: August 22, 2019Report This Post
Platinum Member
posted Hide Post
So I noticed I still have an alignment issue with my compound HTML report above....the columns of the 1st report and the columns of the 2nd report for some of the records it run for. I've tried to play around with WIDTH, WRAP, SIZE, etc in the styling, but no success to get it line up across the board.

Please let me know if anyone has any additional suggestions.


WebFOCUS 8.2.06
SQL Server
HTML, PDF, Excel, etc
 
Posts: 168 | Registered: August 22, 2019Report 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] Spacing Over an ACROSS and a COMPUTE

Copyright © 1996-2020 Information Builders