Can Any one tell How to dynamicly set headings in asql report....
:D

set heading ('&HEADING', 'NO HEADING')

Sujit Ku. Mahapatra

SET PAGESIZE 71 NEWPAGE 0 LINESIZE 90;
SET PAUSE OFF TERMOUT OFF VERIFY OFF ECHO OFF TAB OFF DOC ON HEAD OFF;
SET FEEDBACK OFF SPACE 1;
SET RECSEP OFF;
set underline off;


COLUMN t1 Heading format 99990G999;
COLUMN t2 Heading format 99990G999;
COLUMN t3 Heading format 99990G999;


SELECT Ename t1,SAL t2,Deptno t3 From Emp;

SET TERMOUT ON HEAD ON;

SPOOL ON
SPOOL C:\TEST.LST
/
SPOOL OFF;
ttitle off;
CLEAR BREAKS;
CLEAR COLUMNS;
SET EMBEDDED ON;
SET HEADING OFF;
******************

Now Instead of T1 i want some other value from a varable