SAP Knowledge Base Article - Public

1537946 - How to display the Parameter’s description on Report Header?

Symptom

How to display the Parameter’s description on Report Header?

Environment

  • Crystal Reports XI R2 (All Patch levels)
  • Crystal Reports 2008 (All Patch levels)

Reproducing the Issue

  1. Create a Crystal Report against the Xtreme Sample Database
  2. Create a Parameter (Field Explorer -> Right Click Parameter Fields ->New)
  3. Create a Dynamic or a Static Parameter by choosing ‘Customer.Customer ID’ in the ‘Value’ field and ‘Customer .Customer Name’ in the ‘Description’ field
  4. Click OK and drag the Parameter onto the ‘Report Header’ section
  5. Observe that the when the report is refreshed, it does not display the Parameter’s description and there is no option to display it as well

Resolution

  1. Insert a Subreport ( Insert -> Subreport) and place it beside the Parameter on the ‘Report Header’
  2. During the creation of the Subreport make sure you add the same Database tables which are in the Main report using the ‘Report Wizard’
  3. Right click the Subreport and click on ‘Change Subreport links’
  4. Move the Parameter which was created to the ‘Field(s) to link to’ section
  5. Check on the ‘Select data in Subreport based on field:’ checkbox and select ‘Customer.Customer ID’ from the drop-down and click ‘OK’
  6. Right click the Subreport and click ‘Edit Subreport’
  7. Suppress all other sections except ‘Report Header a’ and drag the ‘Customer Name’ field onto this section
  8. Refresh the report and select the Parameter value; the report will show the Customer ID with its description i.e. Customer Name beside it

Keywords

Parameter description, Crystal Reports , 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 R2