COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Report Studio => Topic started by: mdesouza on 21 Dec 2007 08:59:23 AM

Title: Report Help
Post by: mdesouza on 21 Dec 2007 08:59:23 AM
Hi all

Can someone point me in the right direction or suggest how ways i can build the following report

one of our client wants to report so it will automatically return information based on the current date (today) less 13 months. 

Anyone got a sample report using the sample data in cognos

Thanks
Mike
Title: Re: Report Help
Post by: FatCat on 16 Jan 2008 01:38:57 PM
In the filter for the Datestamp do a

[Datestamp] >  currentmonth -13

You may have to play around with casting the Datestamp