Cognos Report Studio - II

Q. What is Condition Explorer in Report Studio?

Ø  Condition Explorer allows you to manage the variables that are being used in the report.

Q. What is a Page set in Cognos Report Studio?

Ø  The set of pages to render according to a grouping structure.

Q. What are classes in Cognos Report Studio?

Ø  Classes provide a default style to be applied to the objects.

Q. How you do “Conditional Highlighting” on a report in Report Studio?

Ø  The steps to add conditional highlighting to a report are listed below:

a)     Select the list column body for which you want to set conditional highlighting.

b)    From the Style toolbar, click Conditional Styles.

c)     In the New Conditional Style list, select Advanced Conditional Style.

d)    Type a name for the style. Click on New Advanced Condition.

e)     In the Expression Definition pane, specify terms for the expression.

f)     Select a style from the Style list. Edit to define a custom style.

g)    Click Ok and run the report.

  Q. How do you convert a list to cross-tab in Cognos Report Studio?

Ø  To convert a list to a cross-tab, follow the listed steps:

            1. Click the columns that you want to appear as columns or nested columns in the cross-tab.

            2. From the structure menu, click “Pivot List to Crosstab”.

Q. How can you hide an object in Report Studio?

Ø  Set its “Box Type” property to “None”.

Q. How do you hide the rows that have null values?

Ø  You can hide the rows having null values by applying conditional formatting as when you find null values in rows make the box type none in the properties.

Q. How can you hide a column in Report Studio?

Ø  For Crosstab reports –

a)     Group on the column and create aggregation to have the column total in the bottom row.

b)    Click the Unlock button on Report studio toolbar.

c)     Now select the “text item” and delete it.

d)    Select the empty crosstab node after deleting the text. Change its padding to 0 pixels and font to 0.001 pt size.

Q. How can you Specify what appears when no data is available in a report?

Ø  The steps  are as listed below:

a)     Select the data container in the report.

b)    From the properties pane, set the “No Data Contents” property to Yes.

c)     No data contents tab is displayed, which can be used to drop “Text item” or “Layout Calculation” to be displayed in case of no data in report.