Its really helpful.
I am able to use Now() function .
But i am facing a problem.
when ever i used Now().year function in cloumn heading , it gives me year like 2016 but in data in that coumn is showing 2014,2015,2016 as i am using (fields.order_year).
So i want to know how i can control to take only 2016 year as i am using now().year in column heading,
I have a column of order date and i have created year through this order date.Now i want to show sum(amount) against current year of order date .means 2016 and employe id.
employe id now().year amount
1 2016 50
2 2016 60
now().year is the column of order date of 2016.
Only those data whose order is year 2016.
Please tell me expression or any suggestion.