Report Studio

This topic describes some common situations you may encounter while using Report Studio, and gives suggestions for handling those.

• Prompt for webpage access to clipboard

  When using Report Studio in Internet Explorer you may see the following message:

  "Do you want to allow this webpage to have access to your Clipboard?"

  You can answer Yes to this message. To prevent this message from appearing again, enable the Allow Programmatic clipboard access security setting in Internet Explorer.

   

• Unrecognized values in multilingual query items

  A report may be created in one language, and then run in a different language. When you filter for specific values on multilingual query items, the filter does not recognize the values because they exist only in the original language.

  When creating filters in multilingual reports, try to use non-multilingual query items, such as numerical identifiers, for the search criteria, because they are applicable in all languages. For example, use the product code rather than a multilingual product name.

• Changes in the model not reflected in existing reports

  If changes are made to the reporting model and the package is republished, you may not see those changes when you run a report. This is because the version of the model has changed.

  When a package is republished, a new version of the model is added 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 the following:

  • Edit the report and then save it.
    The report is set to the latest version of the model.
• Problems printing a PDF

  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 page.
  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.
• Unexpected results in running total in grouped report

  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.

  Note: The Total function is valid for numeric fields. If used on non-numeric fields (Date fields for example) an error displays when you run the report.

• Browser doesn't display report

  A report with an exceptionally large number of columns may exceed the browsers capability to render HTML. The report does not display and no error message appears.

  To correct the problem, try a different report structure or layout. For example, swap rows and columns and run the report again. Another option is to run the report in PDF format with horizontal pagination.

• Unexpected alignment of items in report

  If the same data item is used more than once in Report Studio Reports, the alignment may not be the same for all instances when you run the report. For example, the data is right-aligned in one column, and left-aligned in another column. The difference is due to the default settings of the objects associated with the data item.

  To correct the problem, the formatting of the query item in the reporting model must be changed.

• Report Studio does not start

  You may not be able to start Report Studio if you are using pop-up blocking software on your computer.

  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 an error is detected.

  To correct the problem, configure your pop-up blocking software to allow pop-ups for the Daptiv PPM web site.

  Note: Daptiv PPM uses pop-up windows throughout. You should allow pop-ups for the Daptiv website.

• Report Studio does not launch

  The Report Studio "hangs" when opening.This may be due to the security settings for your browser. The Daptiv site needs to be added to your Trusted Sites.

  To Add the Daptiv PPM URL to Trusted Sites:

  1. In Internet Explorer, click on Tools.
  2. Select Internet Tools from the drop down.
  3. Click on the Security Tab.
  4. Select Trusted Sites.
  5. Click on Sites.
  6. In the field labeled Add this web site to the zone field type: http://*.daptiv.com .
  7. Click Add.
  8. In the same field type: http:*.daptiv.com (note, no "s").
  9. Click OK twice.
• 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 appears.

  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.

  To delete a prompt:

  1. In Report Studio, from the Data menu, click Filters.
  2. Select the prompt you wish to delete, then click Delete.
  3. Click OK.
  4. Run the report.
• Division by Zero Operation Appears Differently in Lists and Crosstabs

  If you have a list that accesses a relational data source, a calculation containing a division by zero operation appears as a null value, such as an empty cell. In a crosstab, the division by zero operation appears as /0. This happens when the Avoid Division by Zero property is set to Yes, which is the default..

  To have a consistent display of null values in lists and crosstabs, define an if-then-else statement in the expression in the crosstab cell that changes the value /0 to the value null.

• Background Color in Template Does Not Appear

  When creating a Query Studio template in Report Studio, if you add a list object and change its background color, the color change does not appear when you apply the template to a Query Studio report.

  To work around this problem, do one of the following:

  • Edit the style sheet (CSS) class for lists in Report Studio.
  • Do not add any objects to the page body when you are creating a Query Studio template.
  • Leave the page body blank.
    
• Chart Labels Overwrite One Another

  In Report Studio and Query Studio, if you define a chart and render it in HTML or PDF format using the default sizes, the axis labels of the chart may overwrite each other.

  To avoid this problem, make the chart wider or taller by modifying the height and width properties of the chart or enable the Allow Skip property.

• Chart Shows Only Every Second Label

  You create a report that includes a chart. The Allow Skip option is set to false, but when you run the report, labels are skipped.

  This can occur if there is not enough room for all labels and the options Allow 45 Degree Rotation, Allow 90 Degree Rotation and Allow Stagger are also set to false. Cognos has no options for making the labels fit, so it skips every second label.

• Chart Gradient Backgrounds Appear Gray in Internet Explorer

  In Report Studio, you can define a custom palette for a chart that includes a gradient. When the chart is rendered in HTML format in Microsoft Internet Explorer, the chart background appears gray. This is an Internet Explorer issue. To avoid this problem, select the chart and define the color white as the chart background..

Related Topics:

• Problems Editing Reports—Troubleshooting common problems when editing Report Studio reports.
• Problems Filtering Data—Troubleshooting common problems when filtering Report Studio reports.
• Problems Running Reports—Troubleshooting common problems when running Report Studio reports.
• Problems When Drilling Through—Troubleshooting common problems when drilling through in Report Studio reports.

Copyright © 2018 Daptiv Solutions, LLC. All Rights Reserved