Are there any Cognos experts out there that can provide me with the syntax to do a while loop in cognos. It is to be used in a prompted report prompted on dates start date = ?START? and end date ?END?
The query is as follows
While ?START?< ?END?
Select startdate, EndDate , NoEmployees as noemp
Where Fromdate <= ?END? And EndDate >= ?START?
and LKContractTypeID = 8
Set ?START? = dateadd(m,1,@startdate)