Martin Yergeau

TABLE FILE TBLMSTR_CALENDARPERIOD PRINT TBLMSTR_CALENDARPERIOD.TBLMSTR_CALENDARPERIOD.FISCALYEAR TBLMSTR_CALENDARPERIOD.TBLMSTR_CALENDARPERIOD.PERIOD WHERE TBLMSTR_CALENDARPERIOD.TBLMSTR_CALENDARPERIOD.ROLLINGMONTHS EQ -4; ON TABLE HOLD AS YRPER END -RUN -READFILE YRPER -DEFAULTH &FISCALYEAR = '' -DEFAULTH &PERIOD = '' -TYPE FISCALYEAR = &FISCALYEAR -TYPE PERIOD = &PERIOD The above will automatically generates two variables (&FISCALYEAR, &PARIOD) having the same name as the table fields where their values are what you are looking for. Those variables can be used where ever you want. The -TYPE are there only to display the variable's value

I got it to work using HEADING & FOOTING and combining with dummy data column having the WRAP styling key word DEFINE FILE CAR DUMMY1 /A1 = ''; DUMMY2 /A1 = ''; DUMMY3 /A1 = ''; END TABLE FILE CAR SUM DUMMY1 AS '' BY DUMMY2 AS '' BY DUMMY3 AS '' BY COUNTRY NOPRINT HEADING "324523523523452345234523452345234523452345234523452345" "WGSDGSG45GWRG45TRTGW45TGRT" FOOTING "c1C1C1C1C1C1C1C1C1C1<+0>c2C2C2C2C2C2C2C2C2C2C2C2C2<+0>c3C3C3C3C3C3C3C3C3C3C3C3C3C3C3C3C3C3C3C3C3C3C3C3" "c11<+0>c22<+0>c33" "c111<+0>c222<+0>c333" WHERE RECORDLIMIT EQ 1 ON TABLE SET PAGE-NUM NOLEAD ON TABLE SET ASNAMES ON ON TABLE NOTOTAL ON TABLE PCHOLD FORMAT XLSX ON TABLE SET XLSXPAGESETS ON ON TABLE SET HTMLCSS ON ON TABLE SET STYLE * INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/warm.sty, $ TYPE=REPORT, COLUMN=DUMMY1, WRAP=2, $ TYPE=REPORT, COLUMN=DUMMY2, WRAP=3, $ TYPE=REPORT, COLUMN=DUMMY3, WRAP=6, $ TYPE=FOOTING, HEADALIGN=BODY, $ TYPE=FOOTING, LINE=1, OBJECT=TEXT, ITEM=1, COLSPAN=1, JUSTIFY=LEFT, $ TYPE=FOOTING, LINE=1, OBJECT=TEXT, ITEM=2, COLSPAN=1, JUSTIFY=LEFT, $ TYPE=FOOTING, LINE=1, OBJECT=TEXT, ITEM=3, COLSPAN=1, JUSTIFY=LEFT, $ TYPE=FOOTING, LINE=2, OBJECT=TEXT, ITEM=1, COLSPAN=1, JUSTIFY=LEFT, $ TYPE=FOOTING, LINE=2, OBJECT=TEXT, ITEM=2, COLSPAN=1, JUSTIFY=LEFT, $ TYPE=FOOTING, LINE=2, OBJECT=TEXT, ITEM=3, COLSPAN=1, JUSTIFY=LEFT, $ TYPE=FOOTING, LINE=3, OBJECT=TEXT, ITEM=1, COLSPAN=1, JUSTIFY=LEFT, $ TYPE=FOOTING, LINE=3, OBJECT=TEXT, ITEM=2, COLSPAN=1, JUSTIFY=LEFT, $ TYPE=FOOTING, LINE=3, OBJECT=TEXT, ITEM=3, COLSPAN=1, JUSTIFY=LEFT, $ ENDSTYLE END

Hi, As an Excel format, is there a way to reproduce the "Alignment Grid" option without the HEADALIGN=BODY which is set by default ? I am trying to produce a second Excel tab that only contains "documentation" and not a real report. So, I have tried to only includes several HEADING rows where some rows have multiple text data that must by positioned explicitly. In HTML, the display is as expected, but in Excel everything is displayed within one cell per row There is several options in styling (LEFTGAP, RIGHTGAP, POSITION, WIDTH, COLSPAN, ...) but none seems to work with Excel Here what I am trying to reproduce in Excel

That is exactly what I was looking for Thanks David Briars

Hi Cummunity, I remember that there is a SET, command, key word, ... to put into a report to prevent a page break that result of having the same BY to become on two pages. In other words let say that I have a sales report sorted by product and where each product can have up to two lines; one per year. So, one product may have two displayed lines (2 years) and another only one. Each page can only have X number of rows displayed and when this max is reach, a page break is automatically generated. However, it is possible that row number 1 of product ABC is on page 1 when row number 2 is one page 2. I want to prevent that and I know that there is an option in WF to do that but can't remember what it is and can't find back a place where I've used it. Someone can help ? Regards,

Your issue seems to be related with EXL2K format. On my end with XLSX your code works as expected with dynamic formating

Nerver mind I found the error : there was another master file definition stored elsewhere that has the old format. Once deleted, all good

Hi, I had to add new fields in my MODIFY statement and then I always receive the error in subject of this topic. However my FIXFORM and target master file contains the appropriated new fields in the right labelling, format and position. Any ideas ? MODIFY FILE PRODUCT_MAINTENANCE_REQUEST FIXFORM FROM REQUESTDATA MATCH REQUESTTYPE PARTNUM REQUESTEDDATE ON NOMATCH INCLUDE ON MATCH REJECT DATA ON REQUESTDATA END -RUN

With the following it seems to work as expected (As far as I understand what you are looking to do) -SET &REG2 = '[~`!#$%¬^&*()+={}¢Ý¦¨|\:;"<>?/]';

You may have to adapt a little, but I use often the following to search the Repo

Chaining is a great way to populate controls but the more you have chained and/or the larger number of data each control has, the longer it takes to have them populated. There is option using js but it needs you to code. An option that you can try is to check the option "Cache Run Time Data" for each involved controls. At first load it will takes longer to populate but then it's going to be faster while you stay in that report

It's good to illustrate several technic into one sample 🙂 For those who may not know, good to highlight when using MORE for each used files: 1- Need same number of fields 2- Need same field's name 3- Need same field's format 4- Need same field's order

Or if I can suggest another sample from yours Clayton

Also, the obvious choice is to change the Excel settings

Following Patrick's answer, I have mine set to 420 (7hr) and I'd never experience your issue David. For sure it's a good try to performed