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.



Read-Only Read-Only Topic
Go
Search
Notify
Tools
HTMLFORM command
 Login/Join
 
DD
Gold member
posted
Hi,
Can some one guide me why this code does not work?

-SET &L_HTM_FORM = 'testdoma/app/test_uat';
-HTMLFORM &L_HTM_FORM

It throws an error: ERROR: ERROR_MR_FEX_NOT_FOUND Can't create item object based on provided item key &L_HTM_FORM.htm

Thanks,
Ram.


WebFocus 7.7.01
Desktop: Windows and Server: Unix
Excel, HTML, PDF
 
Posts: 69 | Registered: September 12, 2009Report This Post
njsden
Virtuoso
posted Hide Post
Ram,

-HTMLFORM and -INCLUDE require an actual file name to be provided *before* parsing time in the MRE.

What you want to achieve (use dynamic form names via amper variables) can only be done in the Reporting Server -- MRE dialogue manager is a bit "less flexible" so to speak.


Prod/Dev: WF Server 8008/Win 2008 - WF Client 8008/Win 2008 - Dev. Studio: 8008/Windows 7 - DBMS: Oracle 11g Rel 2
Test: Dev. Studio 8008 /Windows 7 (Local) Output:HTML, EXL2K.
 
Posts: 1533 | Registered: August 12, 2005Report This Post
DD
Gold member
posted Hide Post
Thank You!!!
Yes, we need to pass the html form name dynamically at runtime. We get this file from oracle table


WebFocus 7.7.01
Desktop: Windows and Server: Unix
Excel, HTML, PDF
 
Posts: 69 | Registered: September 12, 2009Report This Post
njsden
Virtuoso
posted Hide Post
Hmmm, the only choices I see are:

1. Move all your forms to the Reporting Server so -HTMLFORM &myform works ... not so simple, especially if they have internal references to MRE objects (domains, folders and .fex files)

2. If the list of possible .htm files is "manageable" you can add -HTMLFORM for each .htm file branching to the appropriate one depending on &_HTM_FORM. Somehitng like this:
-IF &L_HTM_FORM EQ 'testdoma/app/test_uat' THEN GOTO :FORM1;
-IF &L_HTM_FORM EQ 'testdoma/app/test_dev' THEN GOTO :FORM2;
-IF &L_HTM_FORM EQ 'testdoma/app/test_prd' THEN GOTO :FORM3;
-IF &L_HTM_FORM EQ 'otherdom/app/other_form' THEN GOTO :FORM4;
-*
-* ... more -IF's as needed
-*
-TYPE Form &L_HTM_FORM not recognized! Call Ram for support! :)
-EXIT
-*
-* Load form
-:FORM1
-HTMLFORM testdoma/app/test_uat
-GOTO :ENDFORM;
-:FORM2
-HTMLFORM testdoma/app/test_dev
-GOTO :ENDFORM;
-:FORM3
-HTMLFORM testdoma/app/test_prd
-GOTO :ENDFORM;
-:FORM4
-HTMLFORM otherdom/app/other_form
-GOTO :ENDFORM;
-*
-* ... more -HTMLFORM's as needed ...
-*
-:ENDFORM
-* ... Continue process ...


As you will end up creating a .htm file anyway for each new form reference you add to your database, it is just a matter of discipline to always adjust this routine and add the proper -IF/-HTMLFORM for it.

Not perfect, but I think it's easier to implement and maintain than option 1.


Prod/Dev: WF Server 8008/Win 2008 - WF Client 8008/Win 2008 - Dev. Studio: 8008/Windows 7 - DBMS: Oracle 11g Rel 2
Test: Dev. Studio 8008 /Windows 7 (Local) Output:HTML, EXL2K.
 
Posts: 1533 | Registered: August 12, 2005Report This Post
DD
Gold member
posted Hide Post
Thanks njsden. Option1 is tough to implement as you said, the html form stores domain, folder, subfolder names in it.
But option2 is great idea. I can generate those IF else lines by writing small oracle PL/SQL package for all the forms as they were stored in a table.
The other thread: on the Fly Fex pointing was also opened by my friend for the same purpose. Since it is not possible to pass a parameter in the self service app link to Fex, we are trying to create a pointer Fex and read the report_id paramter in the url and set prependpath and build html launch page and call it using HTMLFORM command. It is very simple, but the HTMLFORM restriction (can't parse amper variable) killed this simple solution.

Thank You Verymuch for your time and help. Really appreciated.

DD.


WebFocus 7.7.01
Desktop: Windows and Server: Unix
Excel, HTML, PDF
 
Posts: 69 | Registered: September 12, 2009Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic


Copyright © 1996-2020 Information Builders