Diana Watkins Posted July 15, 2021 Share Posted July 15, 2021 If I am creating a compound XLSX, and one of the tabs has no results, the next tabs column titles disappear. If I tweak the report to show results in the first tab, the column titles show up again. For instance SHEET1 dislays all items in inventory that are red, SHEET2 displays all items that are blue. If there are no results for SHEET1, the column titles for SHEET2 disappear - even if there are results for SHEET2. Any ideas I am using v.8202 Link to comment Share on other sites More sharing options...
Martin Yergeau Posted July 15, 2021 Share Posted July 15, 2021 Can you share your code to let us see which compound technic youve used Link to comment Share on other sites More sharing options...
Diana Watkins Posted July 16, 2021 Author Share Posted July 16, 2021 Sure thing, here you go: JOIN CLEAR * -SET &ISO1=DATECVT(DATEADD(DATECVT(&YYMD,I8YYMD,YYMD),D,-1),YYMD,I8YYMD); JOIN INNER DRCODE IN DRSTATDET TO UNIQUE DRCODE IN DRIVERS AS J7 END JOIN INNER DRDV# IN DRSTATDET TO UNIQUE XCDIV IN DIVXBU AS J8 END TABLE FILE DRSTATDET PRINT DRDV# AS Division DRFMGR AS FOM DRSUPR AS FM DRUNIT AS Truck# BY DRCODE AS Driver,Code WHERE (ENTDATE2 EQ &ISO1) AND (DRSTATDET.DRSTATDET.DRSTAT EQ B) AND (DRIVERS.DRIVERS.DRSTAT EQ B); WHERE BU2 EQ GLASS; WHERE CTYPE EQ DEDICATED; ON TABLE SET BYDISPLAY ON ON TABLE SET EMPTYREPORT ON ON TABLE SET PAGE-NUM NOLEAD ON TABLE PCHOLD FORMAT XLSX OPEN ON TABLE SET HTMLEMBEDIMG ON ON TABLE SET HTMLCSS ON ON TABLE SET STYLE * $ INCLUDE = IBFS:/WFC/Repository/Public/Style/np_gphc_theme.sty, $ TYPE=REPORT, TITLETEXT=B Stat, $ ENDSTYLE END JOIN CLEAR * JOIN LEFT_OUTER DRCODE IN FILLINS1 TO UNIQUE DRCODE IN HOMEDV2 AS J15 END JOIN LEFT_OUTER DRCODE IN FILLINS1 TO UNIQUE DRCODE IN INF2 AS J16 END TABLE FILE FILLINS1 PRINT DRNAME DRUNIT DRSTAT DRSUPR DRFMGR COIC AS Driver,Type AVAIL AS Avail,Status @ISOFMTUSA AS PTA PTATIME AS PTA Time HOME_DIV AS Home,Div TRTRDE AS Date,Trans COMPUTE DAYS1/P33=&TODAYH-TRTRDH; AS Days,Fill in JBTYP_DESC AS Fill in,Desc HOME_FM AS FM Trans, From BY CTYPE AS CUST,TYPE BY BU2 AS BU BY DRDV# AS DIV BY DRCODE AS CODE WHERE HOME_DIV EQ MSN; WHERE JBTYP_DESC CONTAINS DOCK; ON TABLE SET BYDISPLAY ON ON TABLE SET EMPTYREPORT ON ON TABLE PCHOLD FORMAT XLSX CLOSE ON TABLE SET HTMLCSS ON ON TABLE SET STYLE * $ INCLUDE = IBFS:/WFC/Repository/Public/Style/np_gphc_theme.sty, $ TYPE=REPORT, TITLETEXT=Dock Fill ins, $ ENDSTYLE END Link to comment Share on other sites More sharing options...
Martin Yergeau Posted July 16, 2021 Share Posted July 16, 2021 I have created a similar sample and all seems ok. But, some of your code seems not to have been included correctly. Please use the tag code or type (without the spaces) : [ code ] <your code here> [ /code] A thing that Ive noticed is that if I use the quotes from your code the result is not good. Maybe the issue is there because the text editor normally display in light blue text between quotes and from your code it doesnt. Working sample TABLE FILE CAR PRINT CAR AS 'Car #' BY COUNTRY AS 'Country' WHERE COUNTRY EQ 'ALLO'; ON TABLE SET BYDISPLAY ON ON TABLE SET EMPTYREPORT ON ON TABLE SET PAGE-NUM NOLEAD ON TABLE PCHOLD FORMAT XLSX OPEN ON TABLE SET HTMLEMBEDIMG ON ON TABLE SET HTMLCSS ON ON TABLE SET STYLE * $ TYPE=REPORT, TITLETEXT='B Stat', $ ENDSTYLE END TABLE FILE CAR PRINT MODEL AS 'Car,Model' BY CAR AS 'Car' ON TABLE SET BYDISPLAY ON ON TABLE SET EMPTYREPORT ON ON TABLE PCHOLD FORMAT XLSX CLOSE ON TABLE SET HTMLCSS ON ON TABLE SET STYLE * $ TYPE=REPORT, TITLETEXT='Dock Fill ins', $ ENDSTYLE END Not rendering properly TABLE FILE CAR PRINT CAR AS Car # BY COUNTRY AS Country WHERE COUNTRY EQ ALLO; ON TABLE SET BYDISPLAY ON ON TABLE SET EMPTYREPORT ON ON TABLE SET PAGE-NUM NOLEAD ON TABLE PCHOLD FORMAT XLSX OPEN ON TABLE SET HTMLEMBEDIMG ON ON TABLE SET HTMLCSS ON ON TABLE SET STYLE * $ TYPE=REPORT, TITLETEXT=B Stat, $ ENDSTYLE END TABLE FILE CAR PRINT MODEL AS Car,Model BY CAR AS Car ON TABLE SET BYDISPLAY ON ON TABLE SET EMPTYREPORT ON ON TABLE PCHOLD FORMAT XLSX CLOSE ON TABLE SET HTMLCSS ON ON TABLE SET STYLE * $ TYPE=REPORT, TITLETEXT=Dock Fill ins, $ ENDSTYLE END Link to comment Share on other sites More sharing options...
Diana Watkins Posted July 16, 2021 Author Share Posted July 16, 2021 Like this Here is another one that I put together as kind of a test: JOIN DRIVERS.DRIVERS.DRCODE IN drivers TO UNIQUE PRPUD.PRPUD.UDCH2 IN prpud TAG J5 AS J5 END JOIN J5.PRPUD.UDER AND J5.PRPUD.UDEN IN drivers TO UNIQUE PRPMS.PRPMS.PRER AND PRPMS.PRPMS.PREN IN prpms TAG J6 AS J6 END JOIN J6.PRPMS.PRDOHH IN drivers TO UNIQUE ALLDATESWF.ALLDATESWF.@100YEAR IN alldateswf TAG J7 AS J7 END JOIN LEFT_OUTER J6.PRPMS.PRDHAH IN drivers TO UNIQUE ALLDATESWF.ALLDATESWF.@100YEAR IN alldateswf TAG J8 AS J8 END TABLE FILE DRIVERS PRINT DRNAME UDER UDEN @ISOFMTUSA AS 'Infinium,Date of Hire' @ISOFMTUSA AS 'Infinium Adj.,Date of Hire' COMPUTE ICC_HIRE/I8YYMD = GREGDT(DRIVERS.DRIVERS.DRHDAT, 'I8YYMD'); AS 'ICC_HIRE,I8YYMD' BY DRCODE WHERE DRIVERS.DRIVERS.DRCODE EQ 'DWATKI'; ON TABLE SET EMPTYREPORT ON ON TABLE SET PAGE-NUM NOLEAD ON TABLE SET BYDISPLAY ON ON TABLE NOTOTAL ON TABLE PCHOLD FORMAT XLSX OPEN ON TABLE SET XLSXPAGESETS ON ON TABLE SET HTMLCSS ON ON TABLE SET STYLE * INCLUDE = IBFS:/WFC/Repository/Public/Style/np_gphc_theme.sty, $ TITLETEXT='NULL', $ ENDSTYLE END TABLE FILE DRIVERS PRINT DRNAME UDER UDEN @ISOFMTUSA AS 'Infinium,Date of Hire' @ISOFMTUSA AS 'Infinium Adj.,Date of Hire' COMPUTE ICC_HIRE/I8YYMD = GREGDT(DRIVERS.DRIVERS.DRHDAT, 'I8YYMD'); AS 'ICC_HIRE,I8YYMD' BY DRCODE WHERE J6.PRPMS.PRTEDH EQ 0; ON TABLE SET EMPTYREPORT ON ON TABLE SET PAGE-NUM NOLEAD ON TABLE SET BYDISPLAY ON ON TABLE NOTOTAL ON TABLE PCHOLD FORMAT XLSX CLOSE ON TABLE SET XLSXPAGESETS ON ON TABLE SET HTMLCSS ON ON TABLE SET STYLE * INCLUDE = IBFS:/WFC/Repository/Public/Style/np_gphc_theme.sty, $ TITLETEXT='NOT NULL', $ ENDSTYLE END Link to comment Share on other sites More sharing options...
Diana Watkins Posted July 16, 2021 Author Share Posted July 16, 2021 I should also add, I was in Text Editor when I ran it. If I open it up normally in App Studio it removes the OPEN and CLOSE in the XLSX formatting 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