Re: Dynamic ally display column name

Hi,

   I am trying to put the value of the fiscal_year, such as "2000" on the report column heading. I am using sqlplus to generate the reports.

   Thanks.

   Nick

"Karsten Farrell" <kfarrell_at_belgariad.com> wrote in message news:MPG.18f78ddf9c96e69b98971c_at_news.la.sbcglobal.net...
> ningli2000_at_hotmail.com said...
> > 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
> >
> Can you restate your question?
>
> I am not sure what you are trying to replace with the fiscal year ...
> the filename of the report (eg, report_2000.rpt), the title of your
> report (eg, "Some Stuff From 2000"), the report column heading (eg,
> "2000"), a parameter that you use in the WHERE clause (eg, where
> fiscal_year = "2000"), or something else.
>
> Where do you use _report("fiscal_year")_? What language are you writing
> your reports in (sqlplus or something else)?
> --
> /Karsten
> DBA > retired > DBA
Received on Fri Apr 04 2003 - 21:22:40 CST