SAP Knowledge Base Article - Public

1712174 - How to get corresponding values of the parameter instead of multiple parameter values in report header.

Symptom

How to get corresponding values of the parameter which are in the report , instead of multiple parameter values in report header.

Environment

  • Crystal report 2008.
  • Crystal report 2011.

Resolution

  1.  Create a following formula and place it in the report footer.

WhilePrintingRecords;

Numbervar x:=x+1;

Stringvar zw;

 If x=1 then (

x:=2;

zw:={Field};

)

else if previous({Field})<>{Field} then (

zw:=zw&" , "&{Field};

)

else zw;

  1. This will give the list of corresponding values present in the report based on the parameter selected.
  2. Place the above formula in the report footer.
  3. Insert the same report as a sub report in the report header of the main report and suppress all the sections except report footer.
  4. The corresponding values of the parameter in the report will be in the report header.

 

Keywords

Corresponding values of parameter, other field values in the report for parameter, other field values, parameters equivalent values, values in the report to the parameter, respective values of the parameter. , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , How To

Product

SAP Crystal Reports all versions