SAP Knowledge Base Article - Public

1257344 - Adding picture to a cross-tab

Symptom

  • Unable to add a picture, image, graphic to a cross-tab
  • Database Field containing a picture are not available to add in a cross-tab

Reproducing the Issue

Environment

  • Crystal Reports 9
  • Crystal Reports 10
  • Crystal Reports XI R1
  • Crystal Reports XI R2
  • Crystal Reports 2008

Cause

  • Cross-tab is an object that summarise data in a column and row format
  • Field defined in the database as: Text, Number or Date, can be summarised.
  • It is not possible to create a summary on a picture

Resolution

Workaround:

  1. Create a custom cross-tab, which is a technique used to create a report that looks like a cross-tab.
       ( See SAP Note 1212953 which describe how to create a custom cross-tab.)
  2. Add the database field containing a picture to the custom cross-tab.

Keywords

picture, image, cross-tab, crystal reports , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , How To

Product

Crystal Reports 2008 V0 ; SAP Crystal Reports 10.0 ; SAP Crystal Reports XI ; SAP Crystal Reports XI R2