Paul Mueller 2 Posted October 13, 2021 Share Posted October 13, 2021 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 More sharing options...
Manoj Chaurasia Posted October 22, 2021 Share Posted October 22, 2021 Paul If this is still an issue please open a case with techsupport if you havent already. Link to comment Share on other sites More sharing options...
Paul Mueller 2 Posted October 22, 2021 Author Share Posted October 22, 2021 Thanks for the reply. Ye this is still an issue; just been busy with other things. I will get a case opened soon. Paul Link to comment Share on other sites More sharing options...
David Briars Posted October 22, 2021 Share Posted October 22, 2021 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 More sharing options...
Paul Mueller 2 Posted October 22, 2021 Author Share Posted October 22, 2021 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 More sharing options...
David Briars Posted October 22, 2021 Share Posted October 22, 2021 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 More sharing options...
Paul Mueller 2 Posted October 25, 2021 Author Share Posted October 25, 2021 Thanks David. I can also get the report to do what you did, the only thing that is missing is the borders around the titles. I will have to see if that is OK with our customer. Appreciate your help. Thanks. Paul Link to comment Share on other sites More sharing options...
Paul Mueller 2 Posted October 25, 2021 Author Share Posted October 25, 2021 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 More sharing options...
David Briars Posted October 25, 2021 Share Posted October 25, 2021 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 More sharing options...
Paul Mueller 2 Posted October 26, 2021 Author Share Posted October 26, 2021 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 More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now