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
- 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;
-
This will give the list of corresponding values present in the report based on the parameter selected.
-
Place the above formula in the report footer.
-
Insert the same report as a sub report in the report header of the main report and suppress all the sections except report footer.
-
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
SAP Knowledge Base Article - Public