SAP Knowledge Base Article - Public

1284178 - How to get the related records of field irrespective of the parameter selected.

Symptom

Generate the report to retrieve related records of field irrespective of the parameter selected. 

Reproducing the Issue

Environment Details:
Crystal Designer : Crystal Reports XI / XIR2 / 2008.
Database : Any Database.
Operating System : Windows

Resolution

Steps to Resolve the Issue:
1) Create a subreport using the same command as used for main report.
2) Right click on the 'Section expert '> Insert section on the 'Detail section', place sub report in 'Detail section B'.      

3) Right click on subreport- -> select change subreport links --> select journal number and account desc.                            

4) Create a formula in the main report to join the parameter as an array:                                                           
    join(?account,",")                                                                                                                 

5) In sub report selection formula write the Condition:
  not {account.descr} like {?pm-accountnumber}  
6) Refresh the report to view the records.

Keywords

Specific records, irrespective of parameter selected.

, KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem

Product

SAP Crystal Reports XI R2