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,

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

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 *

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.

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

 
                  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.

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

The dummy column would allow me to move over those two?

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,

I need to space over the checkmark and across field above it. Does the dummy field allow me to do that?

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
 

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.

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,

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.

Ok, so just how would you move over to the right a few spaces your Country across field and the checkmark here respectively?

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, $

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

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 *
 

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 - 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?

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,

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.

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?

In the documents, you'll see that WIDTH is only supported at TYPE=REPORT levels.

T

Ah....thanks Tony!

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.