Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Can I embed a !IBI.FIL in the HTML Composer?

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] Can I embed a !IBI.FIL in the HTML Composer?
 Login/Join
 
Virtuoso
posted
I'm trying to be a good boy and play nice with the HTML Composer, but it seems so limited. I wanted to have a string that says "Data Available from 7/1/2012 through 2/8/2104" on the screen where the two dates are pulled from the data source on the fly. I tried calling from a fex and embedding the dates with amper variables and it just said no. So I'm trying to have them in holds so that I can fill them with a !IBI.FIL reference. That's a no-go as well.

Here's the question -- how do you fill text on the fly when you're running in HTML Composer?

J.

This message has been edited. Last edited by: <Kathryn Henning>,



 
Posts: 1012 | Location: At the Mast | Registered: May 17, 2007Report This Post
Virtuoso
posted Hide Post
John --

If all else fails, you can make it a one-line report, automatically run at load, aimed at a short, fat iframe.


- Jack Gross
WF through 8.1.05
 
Posts: 1925 | Location: NYC | In FOCUS since 1983 | Registered: January 11, 2005Report This Post
Virtuoso
posted Hide Post
Yeah, that seems to be the operative phrase. "When all else fails." Part of the problem when parachuting in to clients with existing materials is that you have to play be their rules. So I'll need to weasel stuff onto the screen as best I can. Thanks for responding.

J.



 
Posts: 1012 | Location: At the Mast | Registered: May 17, 2007Report This Post
Expert
posted Hide Post
Jack's idea is one way to achieve what you need to do.

When I want to play nice (which is getting rarer by the day) this is what I do:

Add a text box and make it hidden. Populate the text box dynamically (internal code or external fex). Then I use JavaScript to write the contents of the hidden text box to wherever I need to on the screen. Alternatively, make the text box not hidden but read-only and use CSS to remove the text box border.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Expert
posted Hide Post
John,

If you have the fex already then populate your control using a dynamic external procedure.

Say, for instance, I create a fex as follows (just for demonstration purposes) -
DEFINE FILE CAR
  DATA_TEXT/A50 ='Data Available from 7/1/2012 through 2/8/2104';
END
TABLE FILE CAR
  SUM FST.DATA_TEXT
   BY COUNTRY NOPRINT
   BY DATA_TEXT
IF RECORDLIMIT EQ 1
ON TABLE SET HOLDLIST PRINTONLY
ON TABLE PCHOLD FORMAT XML
END

Then in HTML composer, I add a text box (for instance). Click the parameters tab, right click on the control and click "Properties and Settings".
From here I check Dynamic, External Procedure and then click the ellipses to locate and select my fex. Et voila, text box populated with the string I require.

Is this what your requirement is?

T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
 
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004Report This Post
Master
posted Hide Post
J.

We have this in place. Although used for an input field it should work fine with a text-item.

Make the .htm as you please ( let say: inputpage.htm )
Add a text-item ( name it 'infolabel' ).

Then, instead of letting the end-user start a html, let them start a fex. ( let's say starter.fex )


starter.fex
-SET &DYNAMIC_INFOLABEL = 'I am sure you know how to fill this parameter with dynamic text :-)';

-HTMLFORM app/inputpage.htm

-HTMLFORM BEGIN
<SCRIPT LANGUAGE='JSCRIPT'>
document.getElementById('infolabel' ).value = '!IBI.AMP.DYNAMIC_INFOLABEL;';
</SCRIPT>
-HTMLFORM END


We use this to allow a end-user to select an item from a list.
With a drill the user is send to an html-input-page. The selected item in the list is 'entered' in a inputbox in a form and even to automatically click the 'run' button. ( document.getElementById('form1Submit').click(); )


_____________________
WF: 8.0.0.9 > going 8.2.0.5
 
Posts: 668 | Location: Veghel, The Netherlands | Registered: February 16, 2010Report This Post
Master
posted Hide Post
I think Tony is on the right track, except that John presumably wants the from and to dates to be dynamic. So a little bit of additional pre-processing will be required to get those values, convert them to a string and then concatenate them into the text required.


WebFOCUS 7.7.05 Windows, Linux, DB2, IBM Lotus Notes, Firebird, Lotus Symphony/OpenOffice. Outputs PDF, Excel 2007 (for OpenOffice integration), WP
 
Posts: 674 | Location: Guelph, Ontario, Canada ... In Focus since 1985 | Registered: September 28, 2010Report This Post
Virtuoso
posted Hide Post
I like that. A couple of tags wrapped around the target location lets me drop bits and pieces into a string of text without too much trouble. A little different from what I'm used to but likely more versatile.

I'll be honest -- I've scrapped the existing Composer stuff in favor of a cleaner html interface that lets me customize as I see fit. (I just couldn't get the calendars to work in a useful, dependable way.) But the concept still stands regardless of the source of the target page.

J.



 
Posts: 1012 | Location: At the Mast | Registered: May 17, 2007Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Can I embed a !IBI.FIL in the HTML Composer?

Copyright © 1996-2020 Information Builders