SAP Knowledge Base Article - Public

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


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


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:                                                           

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


Specific records, irrespective of parameter selected.

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


SAP Crystal Reports XI R2