Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!news-feed01.roc.ny.frontiernet.net!logbridge.uoregon.edu!newsfeed.stanford.edu!postnews1.google.com!not-for-mail
From: ningli2000@hotmail.com (Nick Li)
Newsgroups: comp.databases.oracle.misc
Subject: Dynamic ally display column name
Date: 4 Apr 2003 09:03:38 -0800
Organization: http://groups.google.com/
Lines: 13
Message-ID: <bfc81ac6.0304040903.3ddda193@posting.google.com>
NNTP-Posting-Host: 208.21.14.73
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1049475819 9586 127.0.0.1 (4 Apr 2003 17:03:39 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 4 Apr 2003 17:03:39 GMT
Xref: newsfeed1.easynews.com comp.databases.oracle.misc:95846
X-Received-Date: Fri, 04 Apr 2003 10:03:20 MST (news.easynews.com)

Hi,

   I have a column in an Oracle table called fiscal_year. I created
some reports by each fiscal_year, such as 2000, 2001, 2002, etc. For
each yearly report, the fiscal_year value will be unique and of that
particular year, say 2000. I would like to dynamically use the vaule
the year such as "2000" to replace the default column name of the
report("fiscal_year"). Could anyone give some advice on how that could
be done?

   Thanks in advance.

   Nick