SAP Knowledge Base Article - Public

1766696 - Teradata query banding implemented in a Universe not working in Crystal Reports

Symptom

  • Teradata Query Banding not working.
  • In Crystal Reports, when reporting off a Universe based off Teradata, the query banding information is not passed to database.
  • When creating a Web Intelligence document off the same Universe, the query banding information is passed to Teradata.

Environment

  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016
  • SAP Crystal Reports 2020

Reproducing the Issue

  1. In the Universe Designer, create a connection to a Teradata data source.
  2. Set the BEGIN_SQL parameter in the Universe for the query banding. ( SET QUERY_BAND )
  3. Save and export the Universe to the BusinessObjects Enterprise repository.
  4. In Crystal Reports, create a report off the Universe.

Notice the query banding information is not passed to the Teradata data source.

Cause

  • The reason Query Banding setting is not sent to Crystal Reports, it's because Crystal Reports does not support Query Banding.

Resolution

  • Teradata Query Banding can be implemented in a Universe, which is supported in Web Intelligence, but not in Crystal Reports.

Keywords

CR , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

Product

SAP Crystal Reports 2013 ; SAP Crystal Reports 2016 ; SAP Crystal Reports 2020