Re: Dynamic ally display column name

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