Jump to content
The ibi Community has moved to a new platform: Please Sign In and choose Forgot Password to continue

I have recently downloaded App Studio 8.2.0.7 to my laptop a...


Paul Mueller 2

Recommended Posts

I have recently downloaded App Studio 8.2.0.7 to my laptop and we have the server version on our system servers. Most things from our perspective have gone smoothly, as I have tested all our current reports.

The issue I have is that we have 7 reports that our users runs from their UI that are shown in Word format. When I ran those reports, the way they worked before the upgrade has changed with the new version. Things like having borders around the fields that our customer needs and placement of fields on the report dont work as before.

I have been able to resolve most of the issues except for a few I am still trying to tweak. The kicker with these reports are that they are saved like this - ON TABLE HOLD AS ROUTPUT FORMAT HTMTABLE then they use HTMLFORM BEGIN and END with styling in that code section. But just prior to that we do this command: SET HTMLFORMTYPE=DOC.

Some of the commands in the HTMLFORM form section seem a bit odd too.

I have tried a lot of different things to replicate the correct output but I do not as of yet have it working to the satisfaction of the customer.

Not sure if something changed in how this type of code is interpreted since 8.2.0.2m

Here is the code from the CARS database that works correctly in 8.2.0.2m

SET PAGE = NOPAGE

TABLE FILE CAR

PRINT

CAR AS Car

MODEL AS Model

BODYTYPE AS Body Style

SEATS AS Seats

WEIGHT AS Weight

FUEL_CAP AS Gas Tank,Max

COMPUTE SGL_PART_TXT/A7 = AAAAAA; NOPRINT

COMPUTE FY_TXT/A40 = BBBBBBBBBBBBBBBBBBBBBBBBB; NOPRINT

COMPUTE SECT_TXT/A14= CCCCCCCCCC; NOPRINT

COMPUTE RPT_TITLE_1_UPPER/A100V = DDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDD; NOPRINT

COMPUTE RPT_TITLE_2_UPPER/A100V = EEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEE; NOPRINT

COMPUTE FOOTER_LEFT/A100V = FFFFF; NOPRINT

COMPUTE RPTSECT/A20 = GG; NOPRINT

COMPUTE FOOTER_RIGHT/A100V = HHHHHHHHHHH; NOPRINT

BY COUNTRY NOPRINT

BY COUNTRY AS Country

HEADING

<SGL_PART_TXT<FY_TXT

" "

IIIIIIIIII<SECT_TXT

" "

<RPT_TITLE_1_UPPER

<RPT_TITLE_2_UPPER

FOOTING BOTTOM

<FOOTER_LEFT<RPTSECT<FOOTER_RIGHT

ON TABLE NOTOTAL

ON TABLE HOLD AS ROUTPUT FORMAT HTMTABLE

ON TABLE SET HTMLENCODE OFF

ON TABLE SET HTMLCSS ON

ON TABLE SET STYLE *

UNITS=IN,

SQUEEZE=ON,

ORIENTATION=LANDSCAPE,

$

TYPE=REPORT,

FONT=NEW TIMES ROMAN,

SIZE=9,

$

TYPE=TITLE,STYLE=BOLD,JUSTIFY=CENTER,$

TYPE=HEADING,HEADALIGN=BODY,$

TYPE=HEADING,LINE=1,OBJECT=FIELD,ITEM=1,COLSPAN=3,CLASS=tHead1,$

TYPE=HEADING,LINE=1,OBJECT=FIELD,ITEM=2,COLSPAN=4,CLASS=tHead3,$

TYPE=HEADING,LINE=2,COLSPAN=7,CLASS=tHead0,$

TYPE=HEADING,LINE=3,OBJECT=TEXT,ITEM=1,COLSPAN=3,CLASS=tHead1,$

TYPE=HEADING,LINE=3,OBJECT=FIELD,ITEM=1,COLSPAN=4,CLASS=tHead3,$

TYPE=HEADING,LINE=4,COLSPAN=7,CLASS=tHead0,$

TYPE=HEADING,LINE=5,OBJECT=FIELD,COLSPAN=7,CLASS=tHead2,$

TYPE=HEADING,LINE=5,OBJECT=FIELD,COLSPAN=7,CLASS=tHead2,$

TYPE=HEADING,LINE=6,COLSPAN=7,CLASS=tHead0,$

TYPE=REPORT,CLASS=tBody,$

TYPE=REPORT,COLUMN=N2,CLASS=tCol1,$

TYPE=REPORT,COLUMN=N3,CLASS=tCol2,$

TYPE=REPORT,COLUMN=N4,CLASS=tCol3,$

TYPE=REPORT,COLUMN=N5,CLASS=tCol4,$

TYPE=REPORT,COLUMN=N6,CLASS=tCol5,$

TYPE=REPORT,COLUMN=N7,CLASS=tCol6,$

TYPE=REPORT,COLUMN=N8,CLASS=tCol7,$

TYPE=FOOTING,HEADALIGN=BODY,$

TYPE=FOOTING,LINE=1,ITEM=1,OBJECT=FIELD,COLSPAN=3,CLASS=tFoot2a,$

TYPE=FOOTING,LINE=1,ITEM=2,OBJECT=FIELD,CLASS=tFoot2a,$

TYPE=FOOTING,LINE=1,ITEM=3,OBJECT=FIELD,COLSPAN=3,CLASS=tFoot2b,$

ENDSTYLE

END

-*

SET HTMLFORMTYPE=DOC

-HTMLFORM BEGIN

 

@page landscape {size:LANDSCAPE;}

TABLE {page: landscape;}

body{size:landscape;}

.tBody { font-size: 8pt;font-family: 'Times New Roman';border-collapse:collapse;}

.tCol1 { width: 5px;border: 0px solid ;}

.tCol2 { width: 5px;border: 0px solid ;}

.tCol3 { width: 18px;border: 0px solid ;}

.tCol4 { width: 18px;border: 0px solid ;}

.tCol5 { width: 5px;border: 0px solid ;}

.tCol6 { width: 8px;border: 0px solid ;}

.tCol7 { width: 5px;border: 0px solid ;}

.tHead0 { border-collapse:collapse;border: 0px;}

.tHead1 { font-weight: bold; text-align: left;border-collapse:collapse;border: 0px;}

.tHead2 { font-weight: bold; text-align: center;border-collapse:collapse;border: 0px;}

.tHead3 { font-weight: bold; text-align: right;border-collapse:collapse;border: 0px;}

.tFoot2a { font-weight: bold; text-align: left;border-collapse:collapse;border: 0px;}

.tFoot2b { font-weight: bold; text-align: right;border-collapse:collapse;border: 0px;}

 

 

!IBI.FIL.ROUTPUT;

-HTMLFORM END

-RUN

-EXIT

When I run it it 8.2.0.7 I dont get all the borders I need.

I have a few screenshots I included below - a before and after (except they are reversed).

It looks like the code in the HTMLFORM didnt come through correctly, do I need to add some code around that part

Thanks for looking.

Paul Mueller

Federal Reserve Bank of St. Louis

paul.a.mueller@stls.frb.org

Test with CARS table - how it actually looks.jpg672638 97.3 KB

 

Test with CARS table - how it should look.jpg527796 122 KB

Link to comment
Share on other sites

  • 2 weeks later...

Paul-

When I ran your sample code, I didnt see the borders until I put style tags around the CSS:

-HTMLFORM BEGIN

<style>

@page landscape {size:LANDSCAPE;}

TABLE {page: landscape;} body{size:landscape;}

.tBody { font-size: 8pt;font-family: 'Times New Roman';border-collapse:collapse;}

.tCol1 { width: 5px;border: 0px solid ;} .tCol2 { width: 5px;border: 0px solid ;}

.tCol3 { width: 18px;border: 0px solid ;} .tCol4 { width: 18px;border: 0px solid ;}

.tCol5 { width: 5px;border: 0px solid ;} .tCol6 { width: 8px;border: 0px solid ;}

.tCol7 { width: 5px;border: 0px solid ;} .tHead0 { border-collapse:collapse;border: 0px;}

.tHead1 { font-weight: bold; text-align: left;border-collapse:collapse;border: 0px;}

.tHead2 { font-weight: bold; text-align: center;border-collapse:collapse;border: 0px;}

.tHead3 { font-weight: bold; text-align: right;border-collapse:collapse;border: 0px;}

.tFoot2a { font-weight: bold; text-align: left;border-collapse:collapse;border: 0px;}

.tFoot2b { font-weight: bold; text-align: right;border-collapse:collapse;border: 0px;}

</syle>

!IBI.FIL.ROUTPUT;

-HTMLFORM END

 

 

Not sure if that is your issue though, as I am not on release 8207.

Link to comment
Share on other sites

David,

I have style tags in my report - I did notice that what I posted here on the forum they were removed them for some reason,

So the report did work in 8.2.0.2m with the style tags around the CSS but now in 8.2.0.7 the borders are gone around the headings.

My apologies for not looking closer at the code that I posted here in the forum.

Thanks.

Paul

Link to comment
Share on other sites

Oh, OK, Paul. Thanks for the reply.

When you post code in myibi, youll see a button to apply Preformatted text styling. That will give your posted code a better chance of being fully displayed.

Hmmm. So yes your code looks fine to me. I wonder if, at some point, 82xx started having issues with setting up the CLASS StyleSheet attributes, in this particular scenario

Try setting up the borders on the WebFOCUS side with StyleSheet commands, rather than with CSS in the -HTMLFORM.

Here is an example, using your code, running in 8206, switching to the BORDER StyleSheet attribute:

SET PAGE = NOPAGE

TABLE FILE CAR

PRINT

CAR AS 'Car'

MODEL AS 'Model'

BODYTYPE AS 'Body Style'

SEATS AS 'Seats'

WEIGHT AS 'Weight'

FUEL_CAP AS 'Gas Tank,Max'

-*

COMPUTE SGL_PART_TXT/A7 = 'AAAAAA'; NOPRINT

COMPUTE FY_TXT/A40 = 'BBBBBBBBBBBBBBBBBBBBBBBBB'; NOPRINT

COMPUTE SECT_TXT/A14= 'CCCCCCCCCC'; NOPRINT

COMPUTE RPT_TITLE_1_UPPER/A100V = 'DDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDD'; NOPRINT

COMPUTE RPT_TITLE_2_UPPER/A100V = 'EEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEE'; NOPRINT

COMPUTE FOOTER_LEFT/A100V = 'FFFFF'; NOPRINT

COMPUTE RPTSECT/A20 = 'GG'; NOPRINT

COMPUTE FOOTER_RIGHT/A100V = 'HHHHHHHHHHH'; NOPRINT

BY COUNTRY AS 'Country'

HEADING

"<SGL_PART_TXT<FY_TXT"

" "

"IIIIIIIIII<SECT_TXT"

" "

"<RPT_TITLE_1_UPPER"

"<RPT_TITLE_2_UPPER"

FOOTING BOTTOM

"<FOOTER_LEFT<RPTSECT<FOOTER_RIGHT"

ON TABLE NOTOTAL

ON TABLE HOLD AS ROUTPUT FORMAT HTMTABLE

ON TABLE SET STYLE *

TYPE=REPORT, FONT='Calibri', SIZE=9,$

TYPE=HEADING,HEADALIGN=BODY,$

TYPE=HEADING,LINE=1,OBJECT=FIELD,ITEM=1,COLSPAN=3,$

TYPE=HEADING,LINE=1,OBJECT=FIELD,ITEM=2,COLSPAN=4,$

TYPE=HEADING,LINE=3,OBJECT=TEXT,ITEM=1,COLSPAN=3,$

TYPE=HEADING,LINE=3,OBJECT=FIELD,ITEM=1,COLSPAN=4,$

TYPE=HEADING,LINE=5,OBJECT=FIELD,COLSPAN=7,$

TYPE=HEADING,LINE=6,COLSPAN=7,$

TYPE=TITLE, STYLE=BOLD, JUSTIFY=CENTER,$

TYPE=DATA, BORDER=LIGHT,$

TYPE=FOOTING,HEADALIGN=BODY,$

TYPE=FOOTING,LINE=1,ITEM=1,OBJECT=FIELD,COLSPAN=3,$

TYPE=FOOTING,LINE=1,ITEM=2,OBJECT=FIELD,$

TYPE=FOOTING,LINE=1,ITEM=3,OBJECT=FIELD,COLSPAN=3,$

ENDSTYLE

END

-*

SET HTMLFORMTYPE=DOC

-RUN

-HTMLFORM BEGIN

<style>

 

@page

{

mso-page-border-surround-header: no;

mso-page-border-surround-footer: no;

}

 

@page Section1

{

size:841.9pt 595.3pt;

mso-page-orientation:landscape;

margin: 0.7cm 0.7cm 0.7cm 0.7cm;

mso-header-margin: 42.55pt;

mso-footer-margin: 49.6pt;

mso-paper-source: 0;

layout-grid: 18.0pt;

}

 

div.Section1

{

page: Section1;

}

</style>

<div class="Section1">

!IBI.FIL.ROUTPUT;

</div>

-HTMLFORM END

 

 

image.png1499886 57.7 KB

 

(I added some CSS to make the report display in a landscape orientation, as it looks like that is what you needed.)

Link to comment
Share on other sites

David,

I do get the borders around the titles by adding that in the stylesheet on the WF side - I didnt read your message closely enough, as I already did that.

We have only 7 reports that use the HTMLFORM BEGIN/END and I inherited them, so I am not very savvy with the stylesheets outside of WebFOCUS. I have been looking around and learning some things about them, but do you have a source where I could go to get more info - I am looking at w3schools, but am wondering about some attributes like @page and even the TABLE command inside the style command. I will keep researching.

I do get it to be about 99% of what it was, the only other issue is that my report using my actual data is 6 pages long and for whatever reason at the end of each page, the border does not close at the bottom each page. Still looking to find a way to do that.

Oh, and also, the report on the page itself is now wider than before, but not sure if there is a way with the CSS outside of WF to get it to be less wide,; probably something to do with left and right borders, so I will look into that as well.

The CARS example doesnt really show the wideness of the actual report since it is test data.

Thanks again,

Paul

Link to comment
Share on other sites

Your welcome!

Im not clear from your last post, if you are using the CSS from my post or not.

If you are using my CSS and not yours, you should see that the Word doc opens in landscape.

Also, hopefully , if you make the margin settings smaller (margin: 0.7cm 0.7cm 0.7cm 0.7cm; mso-header-margin: 42.55pt; mso-footer-margin: 49.6pt;), your report might have a bit more room to display/print.

Link to comment
Share on other sites

David,

Yes, I am using the CSS from your post, and I think I got it working as close to to the way it way before the new version of 8207.

As I mentioned, the only issue is that at the bottom of each page the borders do not close up neatly like they used to, but that may just be something our customer will need to understand and get used to going forward.

Thanks.

Paul

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
  • Create New...