Access Keys:
Skip to content (Access Key - 0)

Format Cognos Reports Quick Reference Card

On this page:

Return to the Main Page

Setting Report Layout

Pagination

  1. Page and set PDF Page Setup to Landscape
    1. Go to Page Properties and select PDF Page Set up.
    2. Click the ellipse and check the box Override the page setup for this page.
    3. Switch the Orientation to Landscape and click OK.
  2. List and Page and under Pagination, uncheck "Allow horizontal pagination"
    1. Go to Page Properties, select Pagination and click the ellipse.
    2. Uncheck the box Enable horizontal page numbering and click OK.
    3. Switch to List Properties.
    4. Select Pagination and click the ellipse.
    5. Uncheck the box Enable horizontal page numbering and click OK.
  3. Set rows per page to 10000
    1. Go to List Properties and select Rows per page.
    2. Type 10000.
    3. Divide footer table in thirds,
    4. Click the report footer area and select the first cell.
    5. Go to Properties and click Size and Over flow then click the ellipse
    6. Set the width to  34.33%
    7. Repeat steps for each cell in footer.

Footers

  1. Divide footer table in thirds,
    1. Click the report footer area and select the first cell.
    2. Go to Properties and click Size and Over flow then click the ellipse
    3. Set the width to  34.33%
    4. Repeat steps for each cell in footer.
  2. Set the table Properties
    1. Select the footer table. Table: Select: Table
    2. Click on the Font Property, choose the ellipse.
    3. Set size to 8 pt. and click OK.
    4. Go to Box: Padding, click the ellipse and enter 10 in the Top area and click OK.
  3. Set the date
    1. Select the first cell.
    2. Drag and drop a Text Item object enter the text “ Run On:”
    3. Set the date object to the right of the Text Item object.
  1. Set the Page Number
    1. Select the second cell page number object.
    2. Go to Properties and choose Number style and click the ellipse.
    3. Click 1 of 3 and Click OK.
  1. Set the Run By
    1. Select the third cell and delete time.
    2. Drag and drop a Text item object in to the third cell with the text “Run By:”
    3. Click and drag a Query Calculation next to the text box object.
    4. Name it Users.
    5. Set the expression to be #sq($account.defaultName)# and click OK.

Screen tips

Adding screen tip to a report listing

  1. From IBM Cognos Connection go to My folders.
  2. From the list of reports click the Properties button next to the report you need to set Tool Tips.
  3. In the Properties window type the tip for the report in the Tool Tips text box and click OK.

Adding screen tips to column headers.

  1. From Design View, click the Unlock button  to unlock the report.
  2. Go to the Toolbox. drag the  HTML Item * *to the left of the column heading.
  3. Double click the yellow HTML Item  to open the dialog box and type  <span title=” ”>, placing the tooltip between the quotes, then click OK.
  4. Click and drag another HTML Item  to the right of the column heading.
  5. Double click the yellow HTML Item and type </span> in the dialogue box and click OK.
  6. Run the report to test the tool tip.
  7. Go back to design view.  Click the Lock  button to lock the report.
  8. Save the report.

Conditional Formating

  1. Select the records area of the field you want to set the conditional formatting.
  2. Choose Conditional Styles under Properties and choose the ellipses button.
  3. Click the New Conditional Style button and choose New conditional style.
  4. Make sure field is selected and click OK.
  5. Click New String button and choose option.
  6. Multiple selection allows you to choose specific items from the records.
  7. Enter values allows you to type values for conditional setting
  8. Enter string criteria allows you to choose contains, Begins with, Ends with, Matches, Does not contain, does not begins with, does not ends with,  or does not match and then you type the string.
    1. Click the Edit Style button and set your formatting for the criteria.
    2. Repeat steps 1-6 until all conditions set and click OK.

Formatting Prompt Pages

Formatting prompts

  1. Drag and drop a Table object on to the page. 
  2. Insert all Prompt objects in to cells of the table.
  3. Select the prompt object block.
  4. Go to Properties, choose Font and click the ellipse.
  5. Choose 9 pt and click OK.
  6. Go to Background color and click the ellipse,
  7. Click Custom Color and set the following:
    1. Red EO
    2. Green EE
    3. Blue FF
  8. Click and drag buttons to go next to object tables.

Editing a Prompt to be multi-select

  1. Select the prompt object and go to Properties
  2. Set Multi Select to Yes.
  3. Go to the Query page and select the prompt expression.
  4. Delete the = and type IN.

Add reference to prompt in report

You can add a reference to the prompt that is set for the report as part of the heading or listed in the report, so it is clear it is a filtered report using a Query calculation from the Toolbox.

  1. Click and drag Add Query Calculation from the Toolbox area in the place it should be displayed.
    To create a space for the Query calculation you may want to click and drag a block to the report layout.
  2. Enter a name for the new object and click OK.
  3. Choose Parameters  button and double click the name of the prompt that should be displayed.
  4. Run the report.

Add reference to a multi-select prompt in report

  1. Drag over Layout Calculation  and select the Department parameter from the parameter list.
  2. The trick is to be sure that the expression reads ParamDisplayValue (Department).
  3. Click and drag Layout Calculation from the Toolbox area in the place it should be displayed.
    To create a space for the Query calculation you may want to click and drag a block to the report layout.
  4. 4.     Choose Parameters  button and double click the name of the prompt that should be displayed.
    Note: Expression reads ParamDisplayValue (”Name of parameter”).
  5. Run the report.

Insert Blocks

  1. From Design View of the report, click the Toolbox  button.
  2. Click and drag the Block  object to where you want it located.
  3. Insert a block to place the text.
  4. Click and drag the tool Text Item   into the block.
  5. Enter the text and format.

Insert Text Box objects

  1. Insert a block to place the text.
  2. Click and drag the tool Text Item   into the block.
  3. Enter the text and format.

Community

Documentation and information provided by the MIT Community


Last Modified:

March 25, 2013

Get Help

Request help
from the Help Desk
Report a security incident
to the Security Team
Labels:
cognos cognos Delete
reports reports Delete
format format Delete
footers footers Delete
headers headers Delete
screen_tips screen_tips Delete
conditional_format conditional_format Delete
prompt prompt Delete
pagination pagination Delete
c-cognos c-cognos Delete
Enter labels to add to this page:
Please wait 
Looking for a label? Just start typing.
Feedback
This product/service is:
Easy to use
Average
Difficult to use

This article is:
Helpful
Inaccurate
Obsolete
Adaptavist Theme Builder (4.2.3) Powered by Atlassian Confluence 3.5.13, the Enterprise Wiki