Custom Reports

When standard reports do not support your business requirement, you can create custom reports as per the requirement by using the folders and elements of IBM Suite Reporting Framework Model. You can also use a standard report as a template for creating custom reports.

When you create a custom report, you are actually creating a report specification. The report specification defines the queries and prompts that are used to retrieve data.

You can generate report outputs in the HTML, PDF, Microsoft Excel spreadsheet, CSV, and XML format.

For detailed procedural information on how to create a custom report, refer Cognos documentation.

Known Issues

When you create a custom report, if you are using Filter For Report option for a report column that contains special characters in the report, then an error type DPR-ERR-2065 occurs.

The following special control characters can cause errors, if they exist in the reporting data source:
  • & (ampersand)
  • < > (angle brackets)
  • " (straight quotation mark)
  • ' (single straight quotation mark)
The following are identified as the other characters that can also cause errors:
  • ! (exclamation point)
  • # (number sign)
  • $ (dollar sign)
  • % (percent)
  • ( ) (opening and closing parenthesis)
  • , (comma)
  • : (colon)
  • ; (semi-colon)
  • = (equal sign)
  • [ ] (brackets)
  • \ (backslash)
  • ^ (caret, circumflex)
  • ` (acute accent)
  • { | } (braces and pipe)
  • ? (question mark)
  • ~ (tilde)

Any character that is not considered a valid XML 1.0 character (for example, a Unicode control character) can cause issues.