Reputation: 9
I need to create a Cognos report, the SQL query has data for last 3 months. I want 3 different report pages for each month. I have data items as date_insert which is datetimestamp field. I want all the dates with Jan month on page 1, Feb on page 2, and March on page 3. I have created data items with month and year with date_insert, and then applied page set on it, but it is not showing correct results. Please suggest.
Upvotes: 0
Views: 36