Jump to content

David Beagan

Members
  • Posts

    261
  • Joined

  • Last visited

  • Days Won

    9

David Beagan last won the day on May 25

David Beagan had the most liked content!

3 Followers

Recent Profile Visitors

326 profile views

David Beagan's Achievements

Community Regular

Community Regular (8/14)

  • Reacting Well Rare
  • Dedicated Rare
  • Week One Done
  • One Month Later
  • One Year In

Recent Badges

28

Reputation

24

Community Answers

  1. This is a nice technique. Playing around with this, it seems to work fine for a global variable in yyyymmdd format. For defaulting to today’s date, a Designer Default value of &YYMD worked for me. For a date other than today, I coded this into the edasprof.prf to give me a date three months ago: -SET &&DATE_MO3 = AYM(&DATEH6, -3, 'I6YYM') | &DATED; Which assigned a value of 20240224 to the variable. Then I put the global variable into Designer Default value: When I run it, I see the desired date.
  2. On our WebFOCUS release 9.1.0 on the search results page, I can hover over the separator line on the search results screen and see the mouse cursor change to a <-||-> pointer and then I can change the width. After adjusting the width of the Name column: Your screenshot looks a little different so yours must be a different release where this resizing feature is not implemented. As an alternative, I tried hitting the gear icon and removing the display of some of the columns, thinking that would make room for the others. Nope, doesn't work.
  3. Yes good to know about UFMT. In my testing this would only work if the Reporting Server is set to code page 65001 - Unicode (UTF-8).
  4. Reposting this code solution so that it is readable and usable for anyone who may find this in the future: DEFINE FILE ggsales AMP_YYMD/YYMD = &YYMD; DATE_YYMD/YYMD = AMP_YYMD - SEQ_NO + 1; DATE_YYMt/YYBMt = DATE_YYMD; DATE_D/D = DATE_YYMD; END GRAPH FILE ggsales SUM UNITS BY DATE_YYMt BY DATE_D WHERE WHERE SEQ_NO FROM 50 TO 70 ON GRAPH PCHOLD FORMAT JSCHART ON GRAPH SET VZERO OFF ON GRAPH SET LOOKGRAPH BAR ON GRAPH SET AUTOFIT ON ON GRAPH SET STYLE * TYPE=DATA, COLUMN=N1, BUCKET=x-axis, $ TYPE=DATA, COLUMN=N2, BUCKET=x-axis, $ TYPE=DATA, COLUMN=N3, BUCKET=y-axis, $ *GRAPH_SCRIPT setFillColor(getSeries(0),new Color(#5388be)); setLabelStagger(getO1Label(),true); *GRAPH_JS_FINAL "xaxis": { "labels": { "nestingConcatSymbol": undefined } } *END ENDSTYLE END
  5. Good one Erin. Note that this behavior is dependent on the setting HTMLENCODE which I think defaults to OFF, the setting you want in this situation. If you turn it on (or it was defaulted to ON in your environment): SET HTMLENCODE=ON TABLE FILE CAR PRINT COUNTRY COMPUTE HTML/A999 = '<a href=https://www.ibi.com>ibi</a>'; END it results in showing the actual HTML code: Also, if the report output's to PDF or Excel, you will probably want to alter the DEFINE to do something different.
  6. You could use SQL passthru to submit your query that uses the two length functions. Then use the results returned to WebFOCUS to determine the next action.
  7. Can you right-click the report window and choose <-- Back ?
  8. A couple others... 102 FOCUS Basic Reporting 126 FOCUS Internals Good point Clayton: "Training fuels adoption and expansion with the organization"
  9. I see that Patrick had *.fex for the Filters in his example. You have .fex
  10. Can you provide a list of future locations for ibi Summits?
  11. Good Patrick, especially if you are already using Notepad++.
  12. Under root_content/WFC/Repository you should find all the Workspace or Domains and their subfolers and fexes. You can use a file search tool to locate strings of interest. It seems most of us use a tool called Agent Ransack to search the files. Windows seach doesn't alsways seem to give expected results.
×
  • Create New...