IBM Cognos 10 Report Studio Cookbook Second Edition
Report Authoring Basic Concepts
Summary filters and detail filters
Aggregation and rollup aggregation
Implementing if-then-else in filters
Formatting data – dates, numbers, and percentages
Prompts – display value versus use value
Creating a nested report – defining the master-detail relationship
Playing with conditional styles
Using conditional blocks – many reports in one
Defining drill-through from crosstab intersection
Overriding crosstab intersection drill-through definitions
Using JavaScript Files – Tips and Tricks
Defining dynamic default values for prompts
Changing the title of the value prompt
Showing/hiding prompt controls at runtime
Selecting and submitting values automatically
Manipulating the Date Time control
Creating a variable width bar chart using JavaScript
The Report Page – Tips and Tricks
Showing images dynamically (traffic light report)
Handling the missing image issue
Dynamic links to an external website (a Google Maps example)
Worksheet name in Excel output
Changing drill targets quickly
Copying and pasting drill links
Removing references to old packages or items
A hidden gem in XML – row level formatting
Controlling the container size and rows per page
Defining page orientation and size (and overriding them for one page)
Avoiding page title repetition
Page numbering with horizontal pagination
Choosing the output format from a prompt
Cautions about HTML items and JavaScript files
Displaying the report name in a footer
Working with Dimensional Models
List report or crosstab report
Adding a prompt into Slicer and its limitations
Aggregation versus preaggregated values
Swapping dimensions using MUN manipulation
Adding data-level security using the CSVIdentityMap macro
Using the Prompt macro in native SQL
Using the prompt() and promptmany() macros in query subjects
Showing the prompt values in a report based on security
String operations to get it right
Showing a username in the footer
Using Report Studio Efficiently
Using Report Studio's environmental options
Copying and pasting partial or full reports
Upgrading report specifications
Handling slow report validation
Browsing values from the data expression window
Picking up and applying styles
Using the "grab them all" practice
Filtering data using Data Check Box Group
Converting a chart to another chart type
Getting started with bullet charts
Getting started with scatter charts
Missing values versus zero values
Overriding data formatting using patterns
Setting up conditional drill-throughs
Dynamically switching between reports using an iFrame
Reducing the number of query items
Using relative paths for images
Controlling JavaScript file execution
Customizing classes for report-wide effect
Naming data containers (lists, crosstabs, and charts) for use in Cognos Workspace
Enabling a larger worksheet size for Excel 2007
Recommendations and References
Recommendations and References
Recommendations and References
Recommendations and References
Recommendations and References
Recommendations and References
Recommendations and References
Recommendations and References
Recommendations and References
Recommendations and References