Cognos: Creating Gantt Chart using Crosstab

Cognos do not include a Gantt chart as an available option in chart dialogs. We can achieve this by using Crosstab object. The steps below will discuss creating the Gantt chart.

1. Tables used

We are going to use following two tables

(I)Minute    

(II) Jobs

2. Create two Queries, Jobs and Minute, with all data items available in Jobs and Minute tables respectively.

3. Drag a third Query item and a Join object, which will join Minute and Jobs Query.

3. Double click Query1 and drag the data items into it.

4. Insert a Data Item called Range with following expression

5. Insert a filter to it with following condition:

[JOB] NOR Null

6. Insert a Crosstab object, Select the Query as Query1

7. Insert the data items into crosstab.

8. Sort the MIN column in ascending order.

9. Run the report, you can see the output

10.  Insert a Boolean Variable with following expression

[Query1].[Range]>0

11. Select Crosstab Intersection, Go to Condition Expression, Select Yes under Boolean Variable

12. Select Style Variable Property as Boolean1, Select Background and foreground color

13. After saving and Running the Report, You can see the following Gantt chart