1290291 - How to show serial numbers in cross tab in Crystal Reports?

SAP Knowledge Base Article - Public

1290291 - How to show serial numbers in cross tab in Crystal Reports?

Symptom

  • Cross tab shows Rows, Columns and Summarized fields however does not show the serial numbers.
  • Is it possible to show the serial numbers for rows or columns

Reproducing the Issue

  • Crystal Reports XI Release 1
  • Crystal Reports XI Release 2
  • Crystal Reports 2008

Cause

Cross-tab is a grid object and we can not customize it to much extent. There is no direct option to include the serial numbers in a Cross-Tab for rows or columns.

Resolution

The following steps could be used as a workaround.

  1. Open the Crystal Reports Designer.
  2. Create a report and insert a Cross-Tab.
  3. To show the serial numbers with rows right click on the row field and click on the Format Field to open the Format Editor.
  4. Go to Common tab.
  5. Click on the X-2 button in front of ‘Display String’ to open the Formula Workshop.
  6. Write below code to it.

WhilePrintingRecords;

NumberVar x;

x:= x+1;

totext(x,"##") + " " + ToText(CurrentFieldValue);

  1. Ensure that there is no syntactical error by clicking on X-2 button.
  2. Save and close the Formula editor and Format Editor.
  3. Preview the report and observe that the Serial numbers are added with the row names.

Same procedure can be followed to add serial numbers with columns.

See Also

 

Keywords

numbered list, cross tab numbering, CR , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , How To

Product

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