David Beagan

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

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.

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.

Thanks John. I just tried it -- had to create the metadata first -- and it worked great.

Can you right-click the report window and choose <-- Back ?

A couple others... 102 FOCUS Basic Reporting 126 FOCUS Internals Good point Clayton: "Training fuels adoption and expansion with the organization"

I was wondering about Derby, too.

I see that Patrick had *.fex for the Filters in his example. You have .fex

Can you provide a list of future locations for ibi Summits?

Good Patrick, especially if you are already using Notepad++.

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.

I used the employee sample table, put something together: The first dropdown has empid_dd.fex to populate it. Each of the others get populated by the other one emp_dd.fex. Like this so that it doesn't try to pull the other ones until an EMP_ID is selected. And then chained like this: When I run the page, it works but it is a bit slow. Seems like nearly a second to populate the boxes after selecting an EMP_ID. There are only about 19 records in employee.

Diana, I'm not sure that changing them to edit boxes stops it from doing all the work. I wonder if chaining Employee Name directly to Title, Department, Supervisor and Class rather than all in a line (assumption on my part) maybe it would make some difference.

I've been using WebFOCUS 9.1 for over a year now. I went into an old WF 8.2.07 installation to check for something. On the 8.2.07 Hub for workspaces, list view, I was immediately struck by what seemed to be the superior interface. The different icons for .fex and .htm and .sch files etc. had a little color making it much easier to differentiate them. There was a search bar right on that page. The tree structure of the Workspaces and subfolders was clearer with + sign icons to click for folder expansion. I'm interested to hear if any one else has observed this or agrees or disagrees.