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
Solved-Fixed header
 Login/Join
 
User1
Silver Member
posted
Hi All,

I need fixed header for the column names.

Below is the the fex code , this report then will embedded into the html page.

ENGINE DB2 SET DEFAULT_CONNECTION CNAME
-SET ECHO = ALL;
-DEFAULT &FROM_DATE='2015/07/21'
-DEFAULT &TO_DATE='2015/08/21'

SET ASNAMES = ON
SQL DB2 EX SYSPROC.Q9WEBSP('&FROM_DATE','&TO_DATE')@
;
TABLE FILE SQLOUT
ON TABLE SUBHEAD
" STOP PAYMENT COUNT BY CHANNEL"
SUM CNT.STOP_PYMT_CHANNEL AS COUNT_STOP_PYMT
BY STOP_PYMT_CHANNEL
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
-*ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = IBFS:/EDA/STP/_EDAHOME/ETC/endeflt.sty,
$
TYPE=TABHEADING,
LINE=1,
OBJECT=TEXT,
ITEM=1,
SIZE=9,
COLOR='NAVY',
BACKCOLOR='WHITE',
STYLE=BOLD,
$
ENDSTYLE
END

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


WebFOCUS 8
Windows, All Outputs
 
Posts: 37 | Registered: September 05, 2015Report This Post
Waz
Expert
posted Hide Post
Do you mean freezing the headers ?

You could try HFREEZE


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
User1
Silver Member
posted Hide Post
Hi,

Where do I use HFREEZE

Yes and need to freeze the column names as well

Thanks,
User1


WebFOCUS 8
Windows, All Outputs
 
Posts: 37 | Registered: September 05, 2015Report This Post
MartinY
Virtuoso
posted Hide Post
Log to Knowledge Base and search for HFREEZE.


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
User1
Silver Member
posted Hide Post
Hi,

I tried the below code, but its not working.

ENGINE DB2 SET DEFAULT_CONNECTION ADC1DB2D
-SET ECHO = ALL;
SET ASNAMES = ON
-DEFAULT &FDATE1='2015/07/21'
-DEFAULT &TDATE1='2015/08/21'
-DEFAULT &ACC_NO='371056897009000';

SET ASNAMES = ON
SQL DB2 EX SYSPROC.Q9WEBSP('&FDATE1','&TDATE1')@
;
TABLE FILE SQLOUT
ON TABLE SUBHEAD
"STOP PAYMENT DETAILS"
PRINT
CUST_ACCT_NO AS 'ACCOUNT NUMBER'
PYMT_SRCE_DS AS 'PAYMENT INITIATION CHANNEL'
PYMT_TRANS_PRCS_LOC_TS AS 'PAYMENT INITIATION TS'
LOB
STOP_PYMT_TS AS 'PAYMENT STOPPED TS'
STOP_PYMT_CHANNEL AS 'PAYMENT STOPPED CHANNEL'
INIT_PYMT_AM AS AMOUNT
COMPUTE COUNTER/I6=1; NOPRINT
BY CUST_ACCT_NO NOPRINT
WHERE CUST_ACCT_NO='&ACC_NO'
ON CUST_ACCT_NO SUBFOOT
"TOTAL NO OF STOP PAYMENTS ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
-*ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = IBFS:/EDA/STP/_EDAHOME/ETC/endeflt.sty,
$
-*TYPE=REPORT, SQUEEZE=1, WRAP=OFF,$
TYPE=REPORT, HFREEZE=ON,$

-*TYPE=REPORT, COLUMN=CUST_ACCT_NO, WRAP=1.0, $
-*TYPE=REPORT, COLUMN=PYMT_SRCE_DS, WRAP=1.0, $
-*TYPE=REPORT, COLUMN=PYMT_TRANS_PRCS_LOC_TS, WRAP=2.0, $
-*TYPE=REPORT, COLUMN=LOB, WRAP=2.0, $
-*TYPE=REPORT, COLUMN=STOP_PYMT_TS, WRAP=2.0, $
-*TYPE=REPORT, COLUMN=STOP_PYMT_CHANNEL, WRAP=2.0, $
-*TYPE=REPORT, COLUMN=INIT_PYMT_AM, WRAP=2.0,
$
ENDSTYLE
END

Can anyone please suggest for this..!!

Thanks in advance.

Thanks,
User1

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


WebFOCUS 8
Windows, All Outputs
 
Posts: 37 | Registered: September 05, 2015Report This Post
MartinY
Virtuoso
posted Hide Post
Difficult to help without the error.....


But, at least, I can say that you have a double quote at the beginning of the line where it shouldn't or you're missing one somewhere:
quote:
"TOTAL NO OF STOP PAYMENTS ON TABLE SET PAGE-NUM NOLEAD


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
Msondra
Silver Member
posted Hide Post
Why do you have this line commented out?
-*ON TABLE PCHOLD FORMAT HTML


WebFOCUS 8.1.05
Windows, All Outputs
 
Posts: 35 | Location: Minnesota | Registered: May 17, 2013Report This Post
MartinY
Virtuoso
posted Hide Post
quote:
Why do you have this line commented out?-*ON TABLE PCHOLD FORMAT HTML


It don't really matter because HTML is the default output format if not specified.


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
User1
Silver Member
posted Hide Post
Hi,

By mistake I marked that as commented.

But not getting any output even if I un commented that part.

Thanks,
User1


WebFOCUS 8
Windows, All Outputs
 
Posts: 37 | Registered: September 05, 2015Report This Post
MartinY
Virtuoso
posted Hide Post
User1,

Read and look at my post from 8:55AM


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
User1
Silver Member
posted Hide Post
Hi,

I am not getting any error but that HFREEZE=ON
its not working.

When I am moving the scroll bar the column names are also moving.

Check the below code,
ENGINE DB2 SET DEFAULT_CONNECTION CNAME
-SET ECHO = ALL;
SET ASNAMES = ON
-DEFAULT &FDATE1='2015/07/21'
-DEFAULT &TDATE1='2015/08/21'
-DEFAULT &ACC_NO='371056897009000';

SET ASNAMES = ON
SQL DB2 EX SYSPROC.Q9WEBSP('&FDATE1','&TDATE1')@
;
TABLE FILE SQLOUT
ON TABLE SUBHEAD
"STOP PAYMENT DETAILS"
PRINT
CUST_ACCT_NO AS 'ACCOUNT NUMBER'
PYMT_SRCE_DS AS 'PAYMENT INITIATION CHANNEL'
PYMT_TRANS_PRCS_LOC_TS AS 'PAYMENT INITIATION TS'
LOB
STOP_PYMT_TS AS 'PAYMENT STOPPED TS'
STOP_PYMT_CHANNEL AS 'PAYMENT STOPPED CHANNEL'
INIT_PYMT_AM AS AMOUNT
COMPUTE COUNTER/I6=1; NOPRINT
BY CUST_ACCT_NO NOPRINT
WHERE CUST_ACCT_NO='&ACC_NO'
ON CUST_ACCT_NO SUBFOOT
"TOTAL NO OF STOP PAYMENTS ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = IBFS:/EDA/STP/_EDAHOME/ETC/endeflt.sty,
$
-*TYPE=REPORT, SQUEEZE=1, WRAP=OFF,$
TYPE=REPORT,HFREEZE=ON, $

-*TYPE=REPORT, COLUMN=CUST_ACCT_NO, WRAP=1.0, $
-*TYPE=REPORT, COLUMN=PYMT_SRCE_DS, WRAP=1.0, $
-*TYPE=REPORT, COLUMN=PYMT_TRANS_PRCS_LOC_TS, WRAP=2.0, $
-*TYPE=REPORT, COLUMN=LOB, WRAP=2.0, $
-*TYPE=REPORT, COLUMN=STOP_PYMT_TS, WRAP=2.0, $
-*TYPE=REPORT, COLUMN=STOP_PYMT_CHANNEL, WRAP=2.0, $
-*TYPE=REPORT, COLUMN=INIT_PYMT_AM, WRAP=2.0,

ENDSTYLE
END

Thanks,
User1


WebFOCUS 8
Windows, All Outputs
 
Posts: 37 | Registered: September 05, 2015Report This Post
MartinY
Virtuoso
posted Hide Post
But still... you have an error as I specified. You must fix it, maybe it's only that. Sometime Focus generates report even with a small error as this but without applying code following the error : here your styling.

And look at : Supported Browser

It works with this simple example:
TABLE FILE CAR
SUM RETAIL_COST
BY COUNTRY
BY CAR
BY MODEL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
TYPE=REPORT,
     HFREEZE = ON,
$
ENDSTYLE
END
-RUN

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
User1
Silver Member
posted Hide Post
Hi,

Thanks for this..!!!

It worked.

Thanks,
User1


WebFOCUS 8
Windows, All Outputs
 
Posts: 37 | Registered: September 05, 2015Report This Post
MartinY
Virtuoso
posted Hide Post
Edit your first post and add [SOLVED] at the beginning of the subject


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


Copyright © 1996-2020 Information Builders