202 Report Studio
Changes in the Model Are Not Reflected in the Report If
Model Versioning Is Used
If you make changes to the model in Framework Manager and republish the package, you may
not see the changes when you run the report. This is because the version of the model has
When you republish a model, you are adding a new version of the model to the package. When
you run a report, the report uses the model that it was initially created with or last edited with.
To correct the problem, do one of the following:
Edit the report and then save it.
The report is set to the latest version of the model.
Before you republish the model in Framework Manager, in the Publish wizard, select the
option Delete all previous model versions.
All reports linked to the model are moved to the latest version of the model.
Before you republish the model in Framework Manager, in the Publish wizard, set the model
version limit to 1.
Model versioning is disabled.
Problems When Printing a PDF Manual
You print a document in PDF format, but the print job is incomplete. For example, the job stops
printing when it reaches a particular graphic.This is an Adobe Acrobat Reader issue that can
occur when printing some PDFs using some versions of Acrobat Reader and some printer models.
The same PDF may print correctly under one or both of the following conditions:
using a different version of Acrobat Reader
using a different printer
If you print from an Acrobat 4.0 or later product, you can try the following solution.
Steps to Force a Page to Print as an Image
1. In Acrobat Reader, from the File menu, click Print.
2. In the Printer section, select the Print as image check box.
Because files print more slowly using this option, make sure you specify only the nonprinting
3. In the Print Range section, click Pages from and Pages to, type only the page number of the
nonprinting page, and then click OK.
You can print the rest of the PDF by resending the job starting on the next page.
4. Clear the Print as image check box.
5. In the Print Range section, click Pages from and Pages to, type the page range for the
remaining pages, and then click OK.
Although you can use the Print as image option to print the file, this setting does not resolve
the original printing problem. For more information, see the Adobe Web site.
A Running Total in Grouped Reports Gives Unexpected
You have a running total calculation in a grouped report that returns unexpected values.
Because tabulation of the running total calculation depends on the order in which the grouping is
executed, you must ensure that the grouped totals are tabulated before applying the running total.
C# Word - Word Create or Build in C#.NET
but also offer them the ability to count the page numbers of generated Besides, using this Word document adding control, you can add some Create Word From PDF. add page pdf reader; add and remove pages from a pdf
User Guide 203
To ensure that the grouping is executed in correct order, define a running total calculation as a
freestanding calculation outside the query subject in Framework Manager, and ensure that the
Regular Aggregate property is set to Automatic.
This may also be an issue with other running, moving, and ranking aggregations.
The java.lang.OutOfMemory Error Message Appears in
Cognos Connection or Report Studio
When working in Cognos Connection or Report Studio, this java error message may appear if not
enough memory is allocated to the dispatcher.
Steps to Increase the Memory Allocated to the Dispatcher
1. Start Cognos Configuration.
2. Stop the Cognos 8 service.
3. In the Explorer window, under Environment, Cognos 8 service, click Cognos 8.
4. Click the Value box next to the Dispatcher maximum memory in MB property and type a
We recommend you change the value to 768.
5. From the File menu, click Save.
6. Restart the Cognos 8 service.
Report Studio Does Not Start
You may not be able to start Report Studio if you are using pop-up blocking software on your
When you start Report Studio, it opens in a new browser window. In addition, a new browser
window opens when you run a report and when an error is detected.
To correct the problem, disable any pop-up blocking software when working in Report Studio.
A Report is Not Rendered Properly
In Report Studio, if a report uses empty blocks, table rows, or table columns to space the report
components, the report may not render properly.
The recommended way to add spaces between report components is to define the padding or
margin properties for the objects. If you use empty blocks, table rows, or table columns, define a
height or width for them.
Unable to Delete a Prompt
You delete a prompt from the design page of a report. When you run the report, the prompt still
The prompt continues to appear because it is saved to the query filter, and not the design page.
You must delete the prompt from the query filter.
1. From the Data menu, click Filters.
2. Select the prompt you wish to delete, then click Delete.
3. Click OK.
4. Run the report.
204 Report Studio
User Guide 205
Cognos 8 includes sample reports. When installed, you can find them in the Public Folders tab in
Sample Reports in the GO Sales Package
The following reports are found in the GO Sales and Retailers package.
The report uses a prompt page to query a chart and a list report.
The report shows that the legend can be customized in a similar way to the titles.
This report shows the default style applied to List Column Title and the List Column Body in a
The report displays combination charts with drill through options.
Retailer Report (Multiple Prompt Values)
List report that accepts multiple prompt values.
Returns by Order Method - Prompted Chart
This report uses a bar chart and a list to show the reasons why products are returned. It uses a
prompt to filter on the return description. It is illustrated in the Getting Started tutorial.
Revenue by Sales Territory
The report shows a chart and a crosstab display with conditional formatting that drills through to
the Orders Report report.
Top 5 Sales Staff
List report that embeds a bar chart that shows the top five sales representatives by sales targets
Top Revenue (Conditional)
List report that conditionally hides the Product Line group footers for the revenue lower than the
206 Report Studio
Sample Reports in the GO Sales and Retailers Package
The following reports are found in the GO Sales and Retailers package.
Actual Sales Against Target Sales
Report showing a simple list with conditional formatting that drills through to the Sales
Representative Contact List report.
Actual Sales Against Target Sales - Burst
Report that is set up for bursting to email addresses. The email addresses point to sales
representatives in the Sales reps table in the GOSales database.
Banded report that shows Product name, Quantity, and Revenue with sales opportunities for each
Product line category.
Basket Analysis with Total Contribution (Top 10 Rank)
Pairing analysis report that uses prompts to compare two products. Orders are totaled and
ranked, and the top ten orders are shown.
Business Details Drill Through
Report that shows product details in charts. This report is a drill-through target report for the GO
Business View report. You can also run it as a product-prompted report.
Complex report that shows a list chart, bar chart and product images to illustrate revenue by
Cost of Goods
Crosstab report illustrating conditional formatting.
Report showing the ability to group products with conditional statements. For example, show all
products that start with the letter S.
Report illustrating The Great Outdoors Company invoice statement.
Book style report that uses multiple pages and charts to show global sales results.
Global Sales (1)
A cut down version of the Global Sales report. It is discussed in the section Try It Yourself - Create
a Multiple-Page Report (p.188).
User Guide 207
GO Business View
Two-page business report showing a combination of metrics across the Great Outdoors company.
Multiple charting types are used.
Report that uses a media file in combination with multiple charting types.
Template style report illustrating a multilingual mailing list for retailers of the Great Outdoors
Margin Cost and Volume Report
Report showing volume and production cost using various chart types. The report drills through
on Product line.
Report that reads two fact tables, each at different levels of granularity, and combines them.
Bookmarks are used to permit easy navigation within the report.
Report showing similar information on one page using multiple chart types. Visual representation
Pairing analysis report that prompts the user for two products, and shows the orders that they
both appear in.
Percent Contribution by Country
Report showing the percentage of products sold by country as well as a percentage comparison
across other countries. Bookmarks are used for easy navigation throughout the report.
Product Comparison Charts
Report using multiple charts to reveal trends and relationships that are not evident in tabular
reports. For more information, see Try It Yourself - Create Charts (p.175).
Product Line by Year
Nested line chart. For more information, see Try It Yourself - Add Prompts (p.187).
Product Line by Year-Prompt
Report illustrating the use of adding a prompt to an existing report. For more information, see Try
It Yourself - Add Prompts (p.187).
Group list report that uses a list header. For more information, see Try It Yourself - Create a List
208 Report Studio
Product Revenue - Lifetime/Q2
Pairing analysis report showing lifetime revenue for each product with sales from Q2 in 2002.
Report that uses a prompt page to query a list.
Products Ranked by Revenue
Pairing analysis report that prompts the user to select a product, order year, and revenue. The
results are ranked by revenue.
Quantity by Retailer
Grouped list report that drills through to the Retailer Contact report. Part of the Report Studio
Report showing order quantity by country, using bookmarks for navigation. The report is the
drill-through target report for the Margin Cost and Volume report.
Report with Totals
List report that uses prompts to show product sales by date and product value lifetime
List report that uses a prompt page. It is also used as a drill-through report.
Retailer Contact (Multiple Prompt Values)
List report that accepts multiple prompt values. It is referenced by the Event Studio User Guide
and the Event Studio Quick Tour.
Returns by Order Method
Report showing the percentage lost by return orders.
Revenue by Date and Amount
Pairing analysis report showing revenues in a specified month whose life to date revenues exceed a
Sales Representative Contact List
Report illustrating multiple prompt styles on the same report page. It is also used as a
Sales Reps Performance
Report using a text prompt to query the performance of all sales reps by lowest percentage of
User Guide 209
Report using tabular table joins to create a complex crosstab.
Waterfall and pareto charts used in combination with a crosstab to show various metrics. Hover
with your mouse over Product line to see Product line images.
Sample Reports in the GO Data Warehouse Package
The following reports are found in the GO Data Warehouse package.
Multiple-page report showing the assets of the Great Outdoors Company. From this report, you
can drill through to the Current Liabilities report.
Shows the payables of the Great Outdoors Company for the year 2004.
Human resources report showing data for each employee.
Sales Target by Region
Report showing sales target by region, using a prompt to provide values for the report.
Report that shows tool tips and baselines in chart.
Sample Reports in the Great Outdoors Company Package
The following reports are found in the Great Outdoors Company package.
Margins and Revenue Map for United States
Map report that shows revenue and margins for each sales branch in the United States.
Product Cost by Years
Report that shows product details using a 3-D combination chart and a crosstab display. It is a
drill-through target for the Product Report sample in the Analysis Studio Samples folder.
Profit and Revenue Combination Chart
Combination bar chart and line-with-markers chart that shows revenue and gross profit. It also
shows the totals for product lines by year.
Revenue by Product Line
Report that uses conditional formatting to highlight revenue. You can also drill through to an
Analysis Studio report.
210 Report Studio
Revenue by Sales Branch
List report that shows revenue by country, sales branch and sales staff.
Revenue by Year over Year Growth
Stacked column chart that shows year-over-year growth. The list report shows revenue growth by
product line and year.
Revenue Chart by Sales Territory and Year
Report that contains a chart that compares the revenue contribution of different sales territories to
the series total by year. The data is also included in a list report.
Revenue for Specified Order Method and Sales Territory
Report that shows revenue filtered by year, product line, order method and sales territory.
Sales Territory Map
Report that uses a map-style chart to show revenue by sales territory. You can drill through to
different reports in Report Studio.
Report that shows dimensional filters applied to the cells of the crosstab but not the rows or
Documents you may be interested
Documents you may be interested