Hi all. Please forgive me if this has been asked before here, I have searched but didn't find anything. I have a query that gets data for a rolling 12 month period. Each column has the months data (ex: Jan 2009, Feb 2009). This report will be run once a month, so I would need the column headers to change each month for the data. Is this possible? Thanks in advance.
Yes we can create a dynamic column headers,
I think ypu need to create a 12 new data items
for each mnth
like example for january month
if(extract (month,current_date)=1)
then 'January'
else''
u can try this