Is is possible to include a field in the Header / Footer of a Report?

[#1]

I have a Report and would like to include the Date in text format i.e "July 2010". Currently I have to manually update this on a monthly basis.

Ideally I'd like to automate this using the [Date] parameter. The only options for this however format this as a date when what I need is the month in a full text style.

Is this possible? I also have a field in my QVW which holds the date. If I include this in the footer however as [Table.Date] or even &[Table.Date] this just displays this as text without translation into a value.

Can anyone help?

[#2 · Accepted solution]

Hi

Put in a = first

=[Table.Date]

Anders

[#3]

Not sure which date you want in the footer but formatting with full monthname and year is done as follows:

=date(today(),'MMMM-YYYY')

Regards
/Michael

[#4]

Hi Riccardinho,

Did you tried this funtion in the window title.

=MonthName(Today())

Regards,

R.Srinivasan .

[#5]

ansch wrote:
Hi
Put in a = first
=[Table.Date]
Anders
 <div></div>

Perfect, thanks Anders!