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.
0
There are 0 best solutions below
Related Questions in COGNOS-10
- Should always pull the monday of the week beginning
- Cognos Report not suppressing the prompt coming from unrendered prompt page
- Cognos Report not returning the total of a calculation in the report
- Cognos excel report name not showing based on page break while scheduling why?
- Difficulty displaying a date in a Cognos BI 10.2.2 crosstab node member
- IBM Cognos IF/casewhen + _days_between
- Cognos Analytics 11.x - Find database vendor type in a query subject definition
- Errors in cognos schedule by trigger
- Total value on the x axis using Marimekko widget using IBM Cognos
- How to generate Authentication Token in Cognos Analytics 11.x
- Cognos 10 Row cumulative expression
- Need a help to Run reports without html pagination
- Cognos Analytics Rest Api/Api-docs 404 not found issue
- Cognos 10 Framework manager crashes with 'BMTUI2' error. 'An error is at the origin of this program malfunction. Close the program'
- How to show data label values in Cognos 11
Related Questions in DATAITEM
- NULL Value from SQL Server DB becomes " " when evaluating its cell in RadGrid
- Kendo grid dataItem always null
- How to fix: cs1061 error dealing with Control and Dataitem
- Receive dataItem in handheld from wear Android Kotlin
- Input string was not in a correct format - when passing NULL value
- Wearable DataClient onDataChanged is never called
- How to read the value from a TreeItem / DataItem using Windows Application Driver / C#?
- Dynamic Memory Allocation for Struct in C Language
- Get DataItem from Kendo Grid with custom button in Angular
- Kendo Grid.dataItem loop not working
- Page set cognos Date field
- 2 basic repeaters that communicate the same DataItemIndex
- Data item current values not updated: internal-work queues get next item: blueprism
- fetch item with json file and ItemFileReadStore dont fetch items
- Kendo grid: Make multiple cells dirty in a row using jQuery
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular # Hahtags
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?