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. 

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:                                                           

    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.

Specific records, irrespective of parameter selected.

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

SAP Crystal Reports XI R2