COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: KoBy_BG on 27 Jan 2012 10:36:03 AM

Title: Visualize optional Data Items and Check boxes
Post by: KoBy_BG on 27 Jan 2012 10:36:03 AM
Hi there!

I'm a newbie with Cognos BI product and I'd like to ask you some fast developer questions.

1. Can I extend a simple table List report by optional Data Items (the values can differ for different rows) but if possible Cognos to display only the Data Items with attributes in use (Data Items with not empty column values)

2. Can Cognos display a simple List table, along with check boxes for every row, used to enable/disable a specific variable or store Data Item flag?

Thank you in advance and sorry for the rookie questions.
Title: Re: Visualize optional Data Items and Check boxes
Post by: KoBy_BG on 06 Feb 2012 02:47:32 AM
1. I don't want to display two Columns from the list report with many items, if the values in the second column are blank or null.
Can I create a boolean variable with the Expression "Column02 is Null", and put the Render Variable with "not to Display" when it is Yes?

2. I want to update specific table in Source.