Contact us
Jump to content

David Beagan

Members
 View Profile  See their activity

  • Posts

    391

  • Joined

  • Last visited

  • Days Won

    33

David Beagan last won the day on June 27

David Beagan had the most liked content!

6 Followers

Recent Profile Visitors

1,320 profile views

David Beagan's Achievements

Rising Star

Rising Star (9/14)

  • Very Popular Rare
  • Reacting Well Rare
  • Dedicated Rare
  • Week One Done
  • One Month Later

Recent Badges

128

Reputation

43

Community Answers

  1. David Beagan
    Yes, hopefully the GUI would provide. But until that day, A Designer (Assemble Visualizations) page I worked on I had a standard set of parameters to be passed to all the content fexes. I created one standard include with all the parameters and just included it from each fex. For example -TYPE &COUNTRY.(FIND COUNTRY IN CAR). -TYPE &CAR.(FIND CAR IN CAR). . . .
  2. David Beagan
    You can also have a value to display and a value to pass. Also the dropdowns can be chained. See Developing Reporting Applications pg 221
  3. David Beagan
    If you code it like this, then you should get a dropdown: TABLE FILE CAR PRINT COUNTRY WHERE COUNTRY EQ '&COUNTRY.(FIND COUNTRY IN CAR).Enter Country.' END
  4. David Beagan
    If chart is FORMAT JSCHART then the ON GRAPH SET AUTOFIT ON should do it. For example, if I run: GRAPH FILE ggsales SUM UNITS BY REGION ON GRAPH PCHOLD FORMAT JSCHART ON GRAPH SET AUTOFIT ON END I can resize the browser window and the chart instantly resizes it fit.
  5. David Beagan
    I did a write-in of Hardcoded Filter
  6. David Beagan
    You could create a fex/htm that references the image, making the image 100% height and width. -HTMLFORM BEGIN <!DOCTYPE html> <html> <body> <img style="height:99.9%;width:100%;position:absolute;left:0;top:0;" src="/ibi_apps/run.bip?BIP_REQUEST_TYPE=BIP_RUN&|BIP_folder=IBFS:/WFC/Repository/shareddo/others/&|BIP_item=excel_logo.png"> </body> </html> -HTMLFORM END
  7. David Beagan
    Using FOC_NONE to optionally suppress components of the WHERE statement seems to work out pretty cleanly. If there is a Case 0 where both are blank, the result would be no output. SET PAGE = OFF -* Case 1 -DEFAULT &UNITS = 1387 -DEFAULT &DOLLARS = 17985 -* Case 2 -* -DEFAULT &UNITS = '' -* -DEFAULT &DOLLARS = 17985 -* Case 3 -* -DEFAULT &UNITS = 1387 -* -DEFAULT &DOLLARS = '' -SET &UNITS = IF &UNITS EQ ' ' THEN 'FOC_NONE' ELSE &UNITS; -SET &DOLLARS = IF &DOLLARS EQ ' ' THEN 'FOC_NONE' ELSE &DOLLARS; TABLE FILE GGSALES "Filters | UNITS &UNITS | DOLLARS &DOLLARS " PRINT SEQ UNITS/I9C DOLLARS/I9C WHERE 1 EQ 0 OR UNITS EQ '&UNITS' OR DOLLARS EQ '&DOLLARS' END
  8. David Beagan
    Yes, still works for me.
  9. David Beagan
    Seems like you pretty much have the right idea. DEFINE FILE CAR SEAT_DESC/A40 = IF SEATS EQ 2 THEN 'TWO-SEATER' ELSE IF SEATS EQ 4 THEN 'FOUR-SEATER' ELSE IF SEATS EQ 5 THEN 'FIVE-SEATER' ELSE '?'; END TABLE FILE CAR PRINT COUNTRY CAR MODEL SEATS SEAT_DESC END
  10. David Beagan
    I think this fex addresses two of your requests. (See Creating Reports manual for doc on FOC_NONE). -DEFAULT &CATEGORY = ' '; -DEFAULT &PCD = ' '; -DEFAULT &PRODUCT = ' '; -DEFAULT &REGION = ' '; -SET &CATEGORY = IF &CATEGORY EQ ' ' THEN 'FOC_NONE' ELSE &CATEGORY; -SET &PCD = IF &PCD EQ ' ' THEN 'FOC_NONE' ELSE &PCD; -SET &PRODUCT = IF &PRODUCT EQ ' ' THEN 'FOC_NONE' ELSE &PRODUCT; -SET &REGION = IF &REGION EQ ' ' THEN 'FOC_NONE' ELSE &REGION; TABLE FILE GGSALES PRINT SEQ_NO CATEGORY PCD PRODUCT REGION COMPUTE CATEGORY_HI/I1 = IF UPPER(CATEGORY) CONTAINS UPPER('&CATEGORY') THEN 1 ELSE 0; NOPRINT COMPUTE PCD_HI/I1 = IF UPPER(PCD) CONTAINS UPPER('&PCD') THEN 1 ELSE 0; NOPRINT COMPUTE PRODUCT_HI/I1 = IF UPPER(PRODUCT) CONTAINS UPPER('&PRODUCT') THEN 1 ELSE 0; NOPRINT COMPUTE REGION_HI/I1 = IF UPPER(REGION) CONTAINS UPPER('&REGION') THEN 1 ELSE 0; NOPRINT BY SEQ_NO NOPRINT WHERE 1 EQ 1 AND UPPER(CATEGORY) CONTAINS UPPER('&CATEGORY') AND UPPER(PCD) CONTAINS UPPER('&PCD') AND UPPER(PRODUCT) CONTAINS UPPER('&PRODUCT') AND UPPER(REGION) CONTAINS UPPER('&REGION') ON TABLE SET PAGE NOLEAD ON TABLE SET LINES 9999 ON TABLE SET STYLE * TYPE=DATA, COLUMN=CATEGORY, COLOR=RED, WHEN=CATEGORY_HI EQ 1, $ TYPE=DATA, COLUMN=PCD, COLOR=RED, WHEN=PCD_HI EQ 1, $ TYPE=DATA, COLUMN=PRODUCT, COLOR=RED, WHEN=PRODUCT_HI EQ 1, $ TYPE=DATA, COLUMN=REGION, COLOR=RED, WHEN=REGION_HI EQ 1, $ TYPE=TITLE, BACKCOLOR=RGB(245 245 245), $ END You can run this and get autoprompt and type in your search terms, for example, I typed in 144 and est Run it and get
  11. David Beagan
    David, when you did the review and compare of the masters created, did you find many differences?
  12. David Beagan
    Maybe this would work for you. -SET &DOTDATE = EDIT(DATECVT( DATEMOV( '&DATEYYMD', 'BOM' ), 'YYMD', 'A8DMYY'), '99.99.9999');
  13. David Beagan
    Are you starting with a date field or &variable ? Do you want the result to be a field or a &variable ?
  14. David Beagan
    This works in 9.1.0 too and maybe for you? Create a hold file with the values: TABLE FILE ggsales PRINT SEQ_NO COMPUTE DISPLAY/A20 = DECODE SEQ_NO (1 'Sales' 2 'Budget'); COMPUTE FIELD/A50 = DECODE SEQ_NO (1 'CNT.DOLLARS AS Dollar,Sales ' 2 'BUDDOLLARS'); WHERE SEQ_NO LE 2 ON TABLE HOLD AS foccache/metrics FORMAT ALPHA END Once you've run it to create the metrics file. Then run your fex with this: SUM &SumFlds.(AND(FIND FIELD,DISPLAY IN METRICS)).Metric.
  15. David Beagan
    Must have tightened things up on the syntax. I'm on 9.1.0.
×
×
  • Create New...
© 2025 Cloud Software Group, Inc. All rights reserved.