report studio question

[katdbc]

Hello Pppl,

I have a report with a chart( x axis: months with year, Y1 and Y2 with measures) .X axis is expected to display only the last 6 month numbers as default.

The report also required to have prompt which should filter the chart by last 6 to 15 months( 6,7,8,9...15).

so how would i implement this.

How can i initially make the chart to filter to display the last 6 month as default and then filter by prev 15 months which might run into previous years.


Thank you in advance.,

[blom0344]

I would break this down into 2 seperate data queries; query 1 to fetch the default 6 months ; query 2 to fetch 6-15 months. Depending on the logic required you can then decide to show/hide the appropriate chart.

[katdbc]

Sir thank you for your prompt reply!!!

Since i have been realtively new with cognos. I havent encountered on how to do the show/hide the queries , in a report.

can you help me on how to implement that.

Thanks in advance