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

SAP Knowledge Base Articles - public

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


  • 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


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.


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.


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



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


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