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,

Do you mean freezing the headers ?

You could try HFREEZE

Hi,

Where do I use HFREEZE

Yes and need to freeze the column names as well

Thanks,
User1

Log to Knowledge Base and search for HFREEZE.

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,

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

Why do you have this line commented out?
-*ON TABLE PCHOLD FORMAT HTML

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.

Hi,

By mistake I marked that as commented.

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

Thanks,
User1

User1,

Read and look at my post from 8:55AM

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

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,

Hi,

Thanks for this..!!!

It worked.

Thanks,
User1

Edit your first post and add [SOLVED] at the beginning of the subject