Martin Yergeau

Thanks David

Yep

Hi community, In a dashbord, I am trying to update report-2 according to report-1 drill selection. How to accomplish that already?

Even have tried with a regular bar chart and similar result where the four bar charts per row takes large space to display (need to scroll left / right) to see them all where when the report it ran alone they all fit in desired area of about 6 inches

Hi, I have a multi-pie chart that render as I wish when ran by itself. Meaning that I have 4 pie per row squeezed within about a width of 6 inches. However, when I add the fex into a portal (8204), it still have 4 pie per row but they takes about 12 inches each. Meaning that I have to scroll left/right to see them all. What is missing ? ENGINE INT CACHE SET ON SET PAGE-NUM=NOLEAD SET HTMLENCODE=ON SET ARGRAPHENGINE=JSCHART SET EMBEDHEADING=ON SET GRAPHDEFAULT=OFF -DEFAULTH &WF_STYLE_UNITS='PIXELS'; -DEFAULTH &WF_STYLE_HEIGHT='180.0'; -DEFAULTH &WF_STYLE_WIDTH='150.0'; GRAPH FILE RPTDATA SUM MEAS/P12C AS '' BY AGINGWK NOPRINT BY CAT1CODE ON GRAPH PCHOLD FORMAT JSCHART ON GRAPH SET VZERO OFF ON GRAPH SET GRWIDTH 4 ON GRAPH SET UNITS &WF_STYLE_UNITS ON GRAPH SET HAXIS &WF_STYLE_WIDTH ON GRAPH SET VAXIS &WF_STYLE_HEIGHT ON GRAPH SET LOOKGRAPH PIE ON GRAPH SET AUTOFIT ON ON GRAPH SET STYLE * *GRAPH_SCRIPT setPieDepth(0); setPieTilt(0); setDepthRadius(0); setPlace(true); setCurveFitEquationDisplay(false); setPieFeelerTextDisplay(1); *END *GRAPH_JS_FINAL "pieProperties": { holeSize: "60%", totalLabel: {visible: true, font: 'Bold 12pt Sans-Serif', color: 'rgb(23,86,62)', numberFormat: '{{auto}}'} }, "agnosticSettings": { "chartTypeFullName": "Pie_Multi" } *END ENDSTYLE END Expected On portal

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