Can anyone tell me how can I display yesterday's date in my report heading.
Thanks,
Vick.
Create a data item containing the following function:
current_date - 1 day
Insert the data item in your report heading.
Chuck
Thank You. I will check it out.
Vick
use query caluculation add_days(date,-1)
You'll probably need to associate the the query that provides the date calculation with the page of the page header. Otherwise the page header will only accept report expressions..
Chuck,
When I create data item with current_date -1 it gives me following error when I run the report.
An error on or around the position '0'. The variable named '[Query1].[Data Item1]' is invalid.
Thanks,
Vick.
Vick, read Blom0344's post. Your invalid Variable error is solved if you do what Blom0344 suggests.
If you are on Cognos 8.3 you can use a Singleton instead
Associate the Query to th report Page
Create a query calculation _add_days(current_date, -1)
Display it in the report header