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     Display the report name in the HTML page dynamically based on a field

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Display the report name in the HTML page dynamically based on a field
 Login/Join
 
info4pal
Guru
posted
Hi,

Is there a way to display the report heading in a HTML page dynamically based on some field
value in the report :

Say this is the sample code :
TABLE FILE CAR
PRINT COUNTRY
END
-RUN
-EXIT

Say assuming that COUNTRY field has only 1 value and this value keeps on changing in the database and I need this field value
to be used as the report name in the HTML page.I tried using a textbox and other controls
but nothing is working.

Any hints/ideas on how to do this is appreciated.

Thanks a lot in advance.

Regards!


Webfocus 8105 Developer studio,Windows 7,HTML,Excel,PDF,Text,Infoassist,Graph,AHTML
 
Posts: 270 | Registered: October 30, 2014Report This Post
MartinY
Virtuoso
posted Hide Post
Have you tried assigning the value to a variable and then display it ?

Something such as (still assuming that COUNTRY as only one value):
TABLE FILE CAR
BY COUNTRY
WHERE RECORDLIMIT EQ 1;
ON TABLE HOLD AS TITLVAL FORMAT BINARY
END
-RUN
-READFILE TITLVAL
-RUN

-SET &#RPTTITLE = &COUNTRY;

-HTMLFORM BEGIN
<HTML>
<HEAD>
<TITLE>!IBI.AMP.#RPTTITLE;</TITLE>
</HEAD>
<BODY style="OVERFLOW: auto" thumbnailscale="4" elementtype="21" edaconnectionrequired="false">
<SPAN tabIndex=1 id=text1 style="HEIGHT: 40px; WIDTH: 300px; POSITION: absolute; LEFT: 130px; Z-INDEX: 1; TOP: 40px">!IBI.AMP.#RPTTITLE;</SPAN>
</HTML>
-HTMLFORM END


WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
 
Posts: 2409 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Report This Post
Danny-SRL
Virtuoso
posted Hide Post
You could also insert the value into TITLETEXT:
  
TABLE FILE CAR
BY COUNTRY
WHERE COUNTRY EQ 'ENGLAND';
ON TABLE HOLD AS TITLVAL FORMAT BINARY
END
-RUN
-READFILE TITLVAL
-RUN
TABLE FILE CAR
WHERE COUNTRY EQ 'ENGLAND';
PRINT SALES 
BY CAR BY MODEL BY BODYTYPE
ON TABLE SET STYLE *
TYPE=REPORT, TITLETEXT='&COUNTRY',$
ENDSTYLE
END


Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

 
Posts: 1980 | Location: Tel Aviv, Israel | Registered: March 23, 2006Report This Post
info4pal
Guru
posted Hide Post
Hi Martin,

Thanks a lot for the quick response.
But unfortunately am using the HTML Composer and is there any way to do it in the HTML Composer which is linked to the fex.

Please let me know.

Thanks!


Webfocus 8105 Developer studio,Windows 7,HTML,Excel,PDF,Text,Infoassist,Graph,AHTML
 
Posts: 270 | Registered: October 30, 2014Report This Post
info4pal
Guru
posted Hide Post
Hi Danny,

Thanks for the quick response as well.
Iam actually trying to add an Report heading in HTML page based on a field's value in a table.

Hope Iam clear.

Thanks!


Webfocus 8105 Developer studio,Windows 7,HTML,Excel,PDF,Text,Infoassist,Graph,AHTML
 
Posts: 270 | Registered: October 30, 2014Report This Post
Ram Prasad E
Master
posted Hide Post
Check below code. It will give you an idea.
TABLE FILE CAR
BY COUNTRY
WHERE READLIMIT EQ 1;
ON TABLE HOLD FORMAT ALPHA
END
-RUN
-READ HOLD &RPT_TITLE.A10.
-SET &COUNTRY = &RPT_TITLE;
-TYPE &RPT_TITLE

TABLE FILE CAR
PRINT
*
WHERE COUNTRY EQ '&COUNTRY';
HEADING
"Report Title : &RPT_TITLE"
""
ON TABLE SET PAGE-NUM NOLEAD
END


WebFOCUS 8.1.05
Windows
http://ibiwebfocus.wordpress.com
https://www.facebook.com/groups/ibi.webfocus/
 
Posts: 542 | Location: Dearborn, MI | Registered: June 03, 2009Report This Post
info4pal
Guru
posted Hide Post
Hi Ram,

Thanks for the response.
Iam actually trying to print &RPT_TITLE as the report heading in the HTML page.

Hope Iam clear now.

Thanks a lot in advance!


Webfocus 8105 Developer studio,Windows 7,HTML,Excel,PDF,Text,Infoassist,Graph,AHTML
 
Posts: 270 | Registered: October 30, 2014Report This Post
Tony A
Expert
posted Hide Post
As this is via HTML composer, I would suggest using an AJAX routine to execute a report that will return the value that you want and then insert that into the TITLE component of the DOM.

The jQuery code to change the title component is -
    $(document).ready(function() {
        document.title = 'blah';
    });


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
Rifaz
Guru
posted Hide Post
quote:
But unfortunately am using the HTML Composer and is there any way to do it in the HTML Composer which is linked to the fex.


May help, check this out.
Passing parameters by URL in HTML Composer


-Rifaz

WebFOCUS 7.7.x and 8.x
 
Posts: 406 | Location: India | Registered: June 13, 2013Report This Post
MartinY
Virtuoso
posted Hide Post
Hi,

My solution does work in HTML Composer. I gave you a HTML form just to show you my technique.

1- In the default domain, open HTML Composer (saved as myhtml.htm per example)
2- Add a text field
3- As the text in the text field put:
!IBI.AMP.#RPTTITLE;

4- Create a fex with the following:
TABLE FILE CAR
BY COUNTRY
WHERE RECORDLIMIT EQ 1;
ON TABLE HOLD AS TITLVAL FORMAT BINARY
END
-RUN
-READFILE TITLVAL
-RUN

-SET &#RPTTITLE = &COUNTRY;

-* syntax for version 8
-HTMLFORM IBFS:/WFC/Repository/DefaultDomain/std_reports/report/myhtml.htm

6- Execute fex in -5-

You should have your text field displaying the variable value.

This message has been edited. Last edited by: MartinY,


WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
 
Posts: 2409 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Report 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     Display the report name in the HTML page dynamically based on a field

Copyright © 1996-2020 Information Builders