COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Topic started by: Kutti on 10 Dec 2010 12:01:55 AM

Title: Drill down from source to target with columns to be shown and hidden
Post by: Kutti on 10 Dec 2010 12:01:55 AM
Hi All,

Please help me to get the below requirement implemented.

In my project I have a report type as a prompt with 3 types A, B C and another prompt with customer names . From Report type A and B has drill through to target report.

my requirement is in report A  there are 1,2,3 columns  and values in those columns (any one or two or three)will be filled based on the selected customer from prompt . In drill down report i will have same 3 columns but out of  three columns only those columns should be displayed in the drill down report which have value in report A

Ex: If in report A col 1 and 3 are filled with Data based on the filter then in the drill down col1 and col3 should be displayed and col2 needs to be hidden.


Title: Re: Drill down from source to target with columns to be shown and hidden
Post by: mrcool on 16 Dec 2010 04:47:00 PM
I think you are passing customer to the target report as well. if so the columns which are null in the parent report will be null in the target report as well. Do conditional formating by creating a boolean varaible with condition as ColumnA is null. If that condition is true hide the column by putting boxtype= none. repeat the same for other columns .
Hope this helps.

Cheers,
Mrcool
Title: Re: Drill down from source to target with columns to be shown and hidden
Post by: Kutti on 19 Dec 2010 10:51:14 PM
Hi Mrcool,

Thanks for your reply. I understood your reply but just want to know do i need to write a case statement to implement the condition. I know how to create variable but after including the condition in the expression how should i go abt the setting box type to None. Do i need to just include the condition in the expression and change that column render variable to my variable name and change box type to "none" in the properties.

I am lill bit confused. Can u please give me more explanation

Thanks.